Forum Discussion
unknown917
Helper IV
Helper IVAutomate Flow adding rows to table trigger failed
I have a flow set up to add rows to a table. I received an error for null values when adding rows. I attempted adding the following expression to account for nulls: if(empty(triggerOutputs()?[...
Expiscornovus
Most Valuable Professional
Most Valuable ProfessionalHi unknown917,
Which trigger action are you using? Can you share a screenshot of your flow setup?
If this an action in the middle of flow you would normally use the item() function (in an apply to each loop) instead of a reference to the trigger action.
So, it might be the case that you want to use that function instead:
if(empty(item()?['ColumnName']),'',item()?['ColumnName'])
unknown917Helper IV
Helper IVI am finding now that the function results in omitting the entire row from being added to the table. Even if there is nothing in the column, I still need the row to populate with data from the other columns