How to remove "Apply to each" action?

Like (0) Share

Report

Posted on 11 Jan 2024 15:29:04 by afoster

Hello,

I had a flow that was working perfectly well. The purpose was: when someone fills out an MS form, add a row to an excel table on Sharepoint with the information from the form. I made it exactly as described in this video: Power Automate - Insert MS Forms Responses to Excel Table in SharePoint! (youtube.com) and it was working perfectly well. But suddenly, an "apply to each" action has appered in my flow above the "get response id" and "add row into table" actions, and now my flow keeps timing out (I think there is an unnecessary loop somewhere).

I have searched and searched but I cannot understand how to remove this action or prevent it from automatically appearing. I have seen people suggest using variables but I don't understand how to do that, as I need to populate 9 cells in each row. I'd like to avoid creating 9 variables 😞

Thank you for your help,

Amanda

I have the same question (0)

All responses (14)

Answers (2)

Verified answer

afoster 23 on 12 Jan 2024 at 16:13:35

Like (0)

Report

Re: How to remove "Apply to each" action?

@Chriddle @creativeopinion Thank you both so much for your help. Your solutions worked really well! The setting on the "when a response is submitted" was the key - but the glitches were fixed by following both of your advices on starting a new flow directly in the classic designer (the new one being buggy) and then just deleting and re-inserting the triggers that were causing issues. Thank you for your help and your patience with my beginner questions 🙂

Was this reply helpful? Yes No
creativeopinion 10,474 Super User 2025 Season 2 on 11 Jan 2024 at 21:09:33

Like (0)

Report

Re: How to remove "Apply to each" action?

@afoster You can follow my tutorial:
How to Get a Microsoft Form RSVP Response into a SharePoint List

Although, this tutorial covers how to add an item to a SharePoint list, you can simply replace the Create Item (SharePoint) action with the Add a Row into a Table (Excel) action. You need to parse your multi-choice responses which I cover in this section of the tutorial to prevent the Apply to Each loop.

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

Hope this helps!
If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

Was this reply helpful? Yes No
afoster 23 on 11 Jan 2024 at 19:10:58

Like (0)

Report

Re: How to remove "Apply to each" action?

@Chriddle @creativeopinion thank you both for your investment in this issue! The good news (I did a little dance): the flow is now getting response details without adding the "Apply to each" step! 😄 but now, it does not want to add a row to my table 😅 so - I created a whole new table, just in case the table was faulty, it now has one row that is blank. I have no idea where to go from there... Any ideas? Here are some screenshots that might be helpful:

Seems to understand what I want to put into the table... it just can't seem to do it though.

Thanks again for your help (and patience)

Amanda

Was this reply helpful? Yes No
Chriddle 7,938 Super User 2025 Season 2 on 11 Jan 2024 at 18:28:04

Like (0)

Report

Re: How to remove "Apply to each" action?

And of course, after changing the trigger, you should test the flow “manually” (not “with a recently used trigger”).

Was this reply helpful? Yes No
Chriddle 7,938 Super User 2025 Season 2 on 11 Jan 2024 at 18:11:37

Like (1)

Report

Re: How to remove "Apply to each" action?

Maybe it helps to delete the trigger and insert it again 🤣

It should look like this

Was this reply helpful? Yes No
creativeopinion 10,474 Super User 2025 Season 2 on 11 Jan 2024 at 18:01:34

Like (1)

Report

Re: How to remove "Apply to each" action?

@afoster Did you create your flow and start editing in the New Designer before switching over to the Classic Designer? There are some bugs in the New Designer. Can you try to create a new flow and immediately switch over to the Classic Designer before you start editing? See if that helps!

Was this reply helpful? Yes No
afoster 23 on 11 Jan 2024 at 17:59:06

Like (0)

Report

Re: How to remove "Apply to each" action?

@Chriddle Thanks for all your help! That didn't work though 😞 I got the following error message:

Was this reply helpful? Yes No
Chriddle 7,938 Super User 2025 Season 2 on 11 Jan 2024 at 17:52:56

Like (0)

Report
Re: How to remove "Apply to each" action?

That has never happened to me 😉
It may just be a bug in the web interface.
You can try the following expression

triggerOutputs()?['body/resourceData/responseId']

Was this reply helpful? Yes No
afoster 23 on 11 Jan 2024 at 17:48:38

Like (0)

Report

Re: How to remove "Apply to each" action?

@Chriddle Thank you! Okay, so if there is no dynamic content available, how do I select "Response Id " here ?

Thanks again,

Amanda

Was this reply helpful? Yes No
Chriddle 7,938 Super User 2025 Season 2 on 11 Jan 2024 at 17:16:00

Like (0)

Report

Re: How to remove "Apply to each" action?

There is simply no “list of responses” as each response is triggered separately.

Instead you get one "Response Id".

That's the whole point 😉

Was this reply helpful? Yes No