Invalid Table : Null

(0) Share

Report

Posted on by ImaneYh

Hi,

i'm trying to do a very simple flow, just sending an email to a distribution list that is generated from a PBI table.

Exactly like that: https://www.youtube.com/watch?v=lIZ3OuU3hsk

however my flow doesn't work the error message i get is

"Execution of an 'Apply_to_each' template action failed: The result of evaluating the 'foreach' expression '@triggerBody()?['entity']?['Power BI values']' is null type. The result must be a valid array."

my flow :

does it require a specific table format? i have tried with other reports same error message. am i missing something?

thank you

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

v-qiaqi@microsoft.com on at

Like (0)

Report

Hi @ImaneYh,

Could you please tell me that if the Apply to each is added by Power Automate not the operation by yourself?

Actually, I would add a compose into your flow above the apply to each and insert the "Power BI Data" dynamic value.

In addition, please trigger the flow using the visualization added to the report.

Was this reply helpful? Yes No
ImaneYh 2 on at

Like (0)

Report

Hi @v-qiaqi-msft ,
The apply to each is automatically added when i select the email list from PBi table.
not sure on how to use "Compose" i used instead Variables, but still not working in PBI

Note : same logic i have used in PowerAutomate with "list row present in the table from Excel Business" and it works

Thank you
Imane Y

Was this reply helpful? Yes No