Unanswered

Flow runs into error moving table to excel table

(0) Share

Report

Posted on by MMHL

I get below error when I try to create a flow to move data to an excel table

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.

I'm new to the whole flow and power bi so help is appreciated.

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (0)

v-jefferni on at

Like (0)

Report

Hi @MMHL ,

As of the error message, one of the Power BI values in Apply_to_each Control is blank and cannot be evaluated. You can use a Filter array action to exclude blank values from the array.

Best regards,

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @MMHL ,

Have you solved this problem?

Best regards,

Was this reply helpful? Yes No
MMHL 4 on at

Like (0)

Report

No, the issue still exists. You need to give me more information on how to change as the solutions I tried did not work.

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @MMHL ,

Please check in below thread:

Solved: Error -- 'Apply_to_each' / Power BI - Power Platform Community (microsoft.com)

So, you can add a Compose above Apply to each and use the output in the Control.

BR,

Was this reply helpful? Yes No
MMHL 4 on at

Like (0)

Report

Still not working running into error.

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @MMHL ,

So, in the latest run history, could you find any outputs from the Compose action? You need to check if there is a table from trigger.

Best regards,

Was this reply helpful? Yes No