Forum Discussion
Automate 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()?[...
yes, yes and yes. still not working. going to try deleting and recreating, again.
here is the original error received for flow failing:
The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@triggerBody()?['entity']?['Power BI values']' is of type 'Null'. The result must be a valid array.
Did you test the button while the report was in edit mode?
If so, you also need to press the ctrl button while clicking the button:
To test the flow in edit mode of the report, select Back to report, then press Ctrl while you select the button to run the flow.
