Unanswered

"Apply to each" failure

(3) Share

Report

Posted on by ahhunter

Hello, all! Power Automate informs me that this is a "new issue" and I should ask the community for help! I get the following error when I test a flow I've created:

The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@triggerOutputs()?['body']' is of type 'Object'. The result must be a valid array.

The purpose of the flow is to send the responses from a Form I created to a pair of other people in my office. Here's what the flow looks like. Does anyone have any tips on what I'm doing wrong? Thanks so much!

Space request form flow.png

Categories:

Building flows

I have the same question (0)

All responses (37)

Answers (2)

Verified answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (30)

Report

Hi @ahhunter
try to use
array(triggerOutputs()?['body']) instead of body alone.

It will resolve your issue

Mark it as solution if it helps
Regards,
Nived N

Was this reply helpful? Yes No
Verified answer

ahhunter 33 on at

Like (9)

Report

This worked - thank you so much! For other newbies like myself, I had to enter that formula as an Expression rather than as dynamic content.

Was this reply helpful? Yes No
thanuramarapana 9 on at

Like (1)

Report

Thank you. This worked like a charm!

Was this reply helpful? Yes No
fayanan 2 on at

Like (1)

Report

Hi @Nived_Nambiar , I have a similar situation but in my case I get this error:
The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@outputs('Compose')' is of type 'String'. The result must be a valid array.
In my '@outputs('Compose')', I have this function - base64(outputs('Get_file_content')?['body']). When I try to put this in the "Select an output from previous steps", it returns the above error. Do you have any solutions for this
?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Hello @ahhunter ,

I have done a double parsing and i am in the same case.
array(triggerOutputs()?['body']) instead of body alone.
don't solve my issue ?

Can i parse that in one time ? name and link ...

{
"responder": "greg@contoso.com",
"submitDate": "11/22/2022 1:39:41 PM",
"r81ac228c0ac4488fa497a0b3bede58f5": "greg@contoso.com",
"r65f94823d7e243abbe60ddba96e11acd": "[{\"name\":\"vide_test_greg10.xlsx\",\"link\":\"https://greg0.sharepoint.com/sites/maquette/_layouts/15/Doc.aspx?sourcedoc=%7B6A31120B-E18F-4E58-A45C-FD66D7BFF26E%7D&file=vide_test_greg%2010.xlsx&action=default&mobileredirect=true\",\"id\":\"01OAWIEQQLCIYWVD7BLBHKIXH5M3L374TO\",\"type\":null,\"size\":11437,\"referenceId\":\"01OAWIEQXMK7EZ665IWREJBJA2FLKQLD3Q\",\"driveId\":\"b!Xnzz0OGDD0CVULk8BViOmln6Bpb_GmhLmR21BcHUGr2jC7UuyTjNSKFo8l6OOR3-\",\"status\":1,\"uploadSessionUrl\":null}]",
"r51b49594923849d8889ed4b141d8b260": "2022-11-30"
}

My issue is to parse sub-data of r65f94823d7e243abbe60ddba96e11acd.
In addition, this is a form upload file bydefault.
Hope that you can help me

Best regards

Grég

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

What was the expression

Was this reply helpful? Yes No
Community Power Pla... on at

Like (2)

Report

Hi
The solution just worked on a simelar but very different problem. Thx

Was this reply helpful? Yes No
Jon_vB 39 on at

Like (1)

Report

This solution led me in the right direction ... but ... my input was "Run a query against a dataset (Power BI)" ... In the Expression side,I typed "array( " and then clicked over to Dynamic Content and selected the 'First table of rows'. This worked!

It makes sense - treat the first table of rows as an array. I think either the error message could have been more clear, or the input to an Apply to each Step could have been templated to wrap my input into an Array function.

at any rate - this is my first flow - so, I'm very grateful for this thread getting me in the right direction! I was pretty close to giving up and doing it with excel macros.

Was this reply helpful? Yes No
UD-10051243-0 46 on at

Like (1)

Report

I'm having a similar error, not sure what I'm doing wrong.

Here is my flow:

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (2)

Report

Hi @unathid

Write the expression under expressions section

Was this reply helpful? Yes No