Forum Discussion

Icon for Helper IV rank

Helper IV

1 year ago

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()?[...

Tips and Tricks

Icon for Helper IV rank

Helper IV

1 year ago

It is a manual trigger. I tried your suggestion, still get the same error.

Icon for Most Valuable Professional rank

Most Valuable Professional

1 year ago

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.

unknown917
Helper IV
1 year ago
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.
- Expiscornovus
  Most Valuable Professional
  1 year ago
  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.
  https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-automate-visual?tabs=powerbi-service#considerations-and-limitations
  
  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
  https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-automate-visual?tabs=powerbi-service#test-the-flow
  - unknown917
    Helper IV
    1 year ago
    yes, yes and yes. still not working. going to try deleting and recreating, again.

Related content