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

All responses (2)

Answers (0)

ImaneYh 2 on at

Like (0)

Report

Re: Invalid Table : Null

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
v-qiaqi@microsoft.com on at

Like (0)

Report

Re: Invalid Table : Null

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.