Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Power Automate Apply to each error

Hello,

 

I get an error when trying to use apply to each in my flow:

 

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.

 

It seems that the data I'm trying to pass from the Power BI report never makes it to the flow.  I can see the data when I show as table:

 

I'm troubleshooting this issue with a compose operation below.

 

 

 

 

I see several similar issues posted but can't get mine to work.  Any ideas?

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    When you trigger the flow,  DO NOT use the button below.  Only trigger the flow using the visualization added to the report.

     

     

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    When you trigger the flow,  DO NOT use the button below.  Only trigger the flow using the visualization added to the report.

     

     

    • trevrobwhite2's avatar
      trevrobwhite2
      Advocate II
      2 years ago

      Thanks Microsoft, I spent ages debugging that run button, if it doesn't work they should remove it

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Anybody found a solution?. This happens even when we trigger it using the power automate visual as well

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hello,

    I have the same problem, do you find the solution?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you very munch!!! I lost most time whit this problem.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Praying this works - I have been stuck with this for a ridiculous length of time!