"Apply to each" failure

[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!

[Nived_Nambiar · Accepted solution]

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

[ahhunter · Accepted solution]

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.

[thanuramarapana]

Thank you. This worked like a charm!

[fayanan]

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

?

[Gregoire035590]

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-A45...",\"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

[IbrahimEnwuzor]

What was the expression

[luislanca]

Hi

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

[Jon_vB]

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.

[unathid]

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

Here is my flow:

[Nived_Nambiar]

Hi @unathid 

Write the expression under expressions section

[Jon_vB]

@unathid - the input to the for each - as Niven N said - just needs to be typed into the Expression builder.   Then - the actions should be something you want to do with the array of outputs from your previous action.   It looks like this for me:

[Gift]

I am also facing the same problem. Kindly advice. I tried the array but I have no options on my expressions

``Error:  ExpressionEvaluationFailed. The execution of template action 'For_each' failed: the result of the evaluation of 'foreach' expression '@triggerBody()?['incidentUpdates']' is of type 'Null'. The result must be a valid array.``

[Jon_vB]

Hello @Gift -   the idea of the For Each is that it will work on a LIST (aka array) of items.  Does the Microsoft Sentinel Incident item give you a list of incidents, or just one?   if it is a list ... then try typing "Array(" into the Expression side and then click "Dynamic Content" and select the output from the step you want to process.   (then type a closing ")" if necessary).

If Sentinel incident is a SINGULAR incident, then you don't need the for each.