Automate Flow adding rows to table trigger failed

[unknown917]

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()?['ColumnName']),'',triggerOutputs()?['ColumnName'])

but I now get this error when triggering the flow:

The input body for trigger 'manual' of type 'Request' did not match its schema definition. Error details: 'Required properties are missing from object: entity.'.

Any insight as to the error and if my expression is incorrect?

[Anonymous]

Hi @unknown917 ,

For this error message "The input body for trigger 'manual' of type 'Request' did not match its schema definition. Error details: 'Required properties are missing from object: entity.", I would recommend removing and re-adding the trigger to help determine if the issue persists.

Best Regards,

Bof

[unknown917]

Allow me to better explain the situation.  The columns I'm exporting inevitably will have null values at the row level.  They are text columns, so I don't want to have a zero replacing the null or empty cell.  I made the assumption that the flow failed because of this.  

[Expiscornovus]

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'])

[unknown917]

I 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

[unknown917]

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

[Expiscornovus]

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.

[unknown917]

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]

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-serv...

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-serv...

[unknown917]

yes, yes and yes.  still not working.  going to try deleting and recreating, again.

[unknown917]

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.

[Expiscornovus]

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.

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-automate-visual?tabs=powerbi-serv...