Building a Flow - Issue with "Apply To Each"

(0) Share

Report

Posted on by jpierce-1234

I am building a flow and running into an issue with the 'apply to each' step.

The below is the error message I see.

The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@json(outputs('Get_response_details')?['body/re81566135ec54113b84b2e5734f15217'])' is of type 'Null'. The result must be a valid array.

Any suggestions or assistance would be very appreciated!

Categories:

Building flows

Error.png

I have the same question (0)

All responses (5)

Answers (0)

rzaneti 4,241 Super User 2025 Season 2 on at

Like (0)

Report

Hi @jpierce-1234 ,

It looks like you are trying to loop a value that is not an array. What exactly are you passing as input to the "Apply to each"?

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@jpierce-1234 You might find this YT Tutorial helpful while you build out your flow: How to Get a Microsoft Form RSVP Response into a SharePoint List

I cover the following in this video tutorial:
✅ How to get a Microsoft Form Response into SharePoint
✅ How to get a Microsoft Form ID
✅ How to get a Microsoft Form response
✅ How to Build a Microsoft Form with Conditional Fields
✅ How to used Branching in Microsoft Forms
✅ How to format Microsoft Form multiple choice responses for a SharePoint multi-choice column
✅ How to parse a Microsoft Form multiple choice response as string of text
✅ How to convert a text response to a number
✅ How to use the Switch action
✅ How to create a custom email confirmation for a Microsoft Form submission
✅ How to Create a Custom View in a SharePoint list
✅ How to use the Compose Action
✅ How to write Power Automate Expressions

Was this reply helpful? Yes No
jpierce-1234 4 on at

Like (0)

Report

Hi there, I entered json(outputs('Get_response_details')?

Below is what this portion of my flow looks like.

For reference, I am trying to create a flow that will send an email once a Microsoft Form is completed, as well as include attachments that are included in the form to the same email.

Screenshot 2024.png

Was this reply helpful? Yes No
ChadVKealey 1,393 on at

Like (0)

Report

Yeah, the problem is that you can't just use the "json" expression in there. You need a "parse json" action to form a proper array. See this playlist for details: https://www.youtube.com/playlist?list=PLMVyjgrWIGnwQowO2RsvHg0pZ8EozvAG-

Was this reply helpful? Yes No
rzaneti 4,241 Super User 2025 Season 2 on at

Like (0)

Report

Hi @jpierce-1234 ,

You won't need the JSON expression to generate an array for the loop. Could you share an image of the raw outputs of your "Get response details" action? I don't know exactly which type of data are you trying to input in the loop, but analyzing the raw outputs will be helpful to identify any approaches to generate an array from there 🙂

If you are not familiar with how to access the raw outputs, refer to this step-by-step: http://digitalmill.net/2023/06/29/how-to-access-the-raw-outputs-in-power-automate/

Was this reply helpful? Yes No