Forum Discussion
Automate Flow adding rows to table trigger failed
Hi 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'])
It is a manual trigger. I tried your suggestion, still get the same error.
Hi unknown917,
Are you using the below in the Select an output from previous steps field of the Apply to each action?
triggerBody()?['entity']?['Power BI values']Can you also inspect the outputs of the On Power BI button clicked trigger action of your flow run to see what the structure is and if it contains any data at all?
Just want to see what the names of your columns are and it it actually contains the data.
Yes, I am using the
triggerBody()?['entity']?['Power BI values']
as for the Outputs, there are none. The input does show the columns names, though.
Have you selected your data in the visual, when configuring the button visual?
Did you also configure the flow from the Power BI interface? I am asking because of the below limitation:
Create flows that you will use with the Power BI button trigger directly within the Power BI report. Avoid going directly to Power Automate to create these flows, as the trigger will not have access to the data fields necessary for creating the flow.
And you are also testing it from Power BI, correct?
You can only run these Power BI flows within the context of a Power BI report. You can't start flows from the Power Automate portal