Unanswered

Power Automate error 'Required properties are missing from object: entity.'.

(0) Share

Report

Posted on by JZCG

Hello,

I am trying to replicate this simple Power Automate https://www.youtube.com/watch?v=z1_c6nsT2qE process to add a new row to an Excel table (end product is at ~10 minutes). I am opening the Power BI report on my desktop and it is connected to live data. The Excel file is in a Sharepoint.

However, when I first run the process, it can run but fails, giving me the following error: "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."

If I try to run the flow again, it gives me this error:

"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 have no idea what "entity" is as there is no "entity" in my data. Any information would be greatly appreciated.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Expiscornovus 33,480 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @JZCG,

Entity is something Microsoft adds to the json response, that is not something you have to add yourself.

Just to double check, have you added the data to your Flow button in the Power BI report? (see the Power Automate data section in the Visualizations panel of Power BI)

You can also check this by adding a Compose action to your flow and see if the out of the box dynamic content fields like Body, Power BI data item and entity show up? (see the screenshot below for an example).

Was this reply helpful? Yes No
JZCG 4 on at

Like (1)

Report
Copy link

Link copied!

Thank you. It seems like I just need to Ctrl + click on the button to run the process.

Was this reply helpful? Yes No