web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to remove "Apply t...
Power Automate
Unanswered

How to remove "Apply to each" action?

(0) ShareShare
ReportReport
Posted on by 23

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).

 

afoster_0-1704986834460.png

 

 

 

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

Categories:
I have the same question (0)
  • creativeopinion Profile Picture
    10,502 Super User 2025 Season 2 on at

    @afoster Are one of your form responses a multi-choice? If so, this is why an Apply to Each action is automatically being added to your flow. You will need to parse your multi-choice response first before you use it in the Add Row into a Table action. I cover that in this section of a YT Tutorial.

     

    If not, there is a bug in the New Designer. Did you start editing your flow in the New Designer then switch over to the Classic Designer? If so, I would recommend creating a brand new flow and start editing in the Classic Designer first.

     

    You might also be interested in a new YT Tutorial I recently uploaded: 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

     

    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

  • Verified answer
    Chriddle Profile Picture
    8,436 Super User 2025 Season 2 on at

    Check the settings of the trigger "When a response is submitted".

    If "Split On" is set, you get a "Response Id" in the Dynamic content and it works as you expect.

    If not, the trigger responds with an array of form submissions. That's why you get the "Apply to each".

     

    Chriddle_1-1704989534598.png

  • afoster Profile Picture
    23 on at

    @Chriddle  Thanks, that worked to not create an "apply for each" action, however, now I can't get the "list of response IDs" in dynamic content under "get response details" because changing that setting you suggested makes dynamic content unavailable in this second step

    afoster_0-1704992704713.png

    any ideas on how to go about fixing that? 

  • afoster Profile Picture
    23 on at

    @creativeopinion Hello, thank you for your quick response! 

     

    In answer to your question: I had made the flow before the new editor existed. But now, it got edited by the new editor and even when I go back to the classic editor, the flow does not go back to how I originally had it. I tried to delete it and create a new one in the old editor and it still automatically triggers the "apply to each" function 😞 

     

    The problem is I am using a mutlilingual form, so yes, all of my responses are multi-choice and there is no way around that. 

     

    I am not very knowledgeable about powerautomate : do you happen to know of any tutorial that is simple to follow step by step, that achieves the purpose: when a new MS form is submitted, add a row to an existing sharepoint excel sheet and populate it with the results of the form? 

     

    (basically, I am trying to do what a google form does with google sheets automatically, but MS forms has me use powerautomate to do this and I need some help 🙂 )

     

    Thanks!

  • Chriddle Profile Picture
    8,436 Super User 2025 Season 2 on at

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

    Instead you get one "Response Id".

    That's the whole point 😉

  • afoster Profile Picture
    23 on at

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

    afoster_0-1704995305269.png

     

    Thanks again,

     

    Amanda

  • Chriddle Profile Picture
    8,436 Super User 2025 Season 2 on at

    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']

     

  • afoster Profile Picture
    23 on at

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

    afoster_0-1704995923983.png

     

  • creativeopinion Profile Picture
    10,502 Super User 2025 Season 2 on at

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

  • Chriddle Profile Picture
    8,436 Super User 2025 Season 2 on at

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

    It should look like this

    Chriddle_1-1704996680242.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard