Skip to main content

Notifications

Power Automate - AI Builder
Suggested answer

Condense Multiple control actions with apply to each

Like (2) ShareShare
ReportReport
Posted on 6 Sep 2024 12:53:57 by 24
Hello,
I am using a form with over 100 questions and as of right now my flow works but editing it is super slow and annoying. A section of the flow will have actions for each form question which it checks if it has an answer or not. If it does then it adds a row to my excel table. Once I reached about 70 of these "Check" actions the page becomes "Unresponsive" and you have to wait for it to load. I was wondering if there is a solution to apply to each question: Is it answered? if yes then, add row to excel and input Question text and answer in that row. Any assistance would be gratefully appreciated. 
 
Categories:
  • Davefin Profile Picture
    Davefin 24 on 12 Sep 2024 at 16:17:51
    Condense Multiple control actions with apply to each
    The final result in Excel is this inputting the form question which has the part number and description and the user inputs the qty. Right now the part number and description are hardcoded and matched up with the corresponding question on the form. Hence the 100+ Actions like the above screen shot.
     
     
  • Nived_Nambiar Profile Picture
    Nived_Nambiar 16,882 on 11 Sep 2024 at 17:40:22
    Condense Multiple control actions with apply to each
    Hi,
     
    Thanks for the responses, but i could not get one point here -
     
    Also does the column name in excel for form responses field corresponds to name of field in MS forms ?
    yes it does. the name of the question is the column labeled item. only the quantity is input from the form.
     
    what you meant by this highlighted point ?
     
     
  • Davefin Profile Picture
    Davefin 24 on 10 Sep 2024 at 17:36:52
    Condense Multiple control actions with apply to each
    before explaining the solution - i want to know one thing-  how the rows are added to excel ? I add row via connector
     
    does some fields are hardcoded and other field in excel are dynamically filled via form responses ? yes but they dont have to be.
     
    Also does the column name in excel for form responses field corresponds to name of field in MS forms ?
    yes it does. the name of the question is the column labeled item. only the quantity is input from the form.
  • Suggested answer
    Nived_Nambiar Profile Picture
    Nived_Nambiar 16,882 on 10 Sep 2024 at 17:08:13
    Condense Multiple control actions with apply to each
    Hi, 
     
    before explaining the solution - i want to know one thing-  how the rows are added to excel ?
     
    does some fields are hardcoded and other field in excel are dynamically filled via form responses ?
     
    Also does the column name in excel for form responses field corresponds to name of field in MS forms ?
     
    Thanks & Regards,
    Nived N 
    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs
     Found my answer helpful? Please consider marking it as the solution!
     Your appreciation keeps me motivated. Thank you!

     
  • Davefin Profile Picture
    Davefin 24 on 09 Sep 2024 at 13:44:17
    Condense Multiple control actions with apply to each
    Do you guys have any examples? 
  • Suggested answer
    Nived_Nambiar Profile Picture
    Nived_Nambiar 16,882 on 08 Sep 2024 at 17:21:28
    Condense Multiple control actions with apply to each
    Hi,
     
    another approach would be to get list of questions and their associated ID and iterate through each. This can be done via form api to get the questions and their corresponding id.
     
    Thanks & Regards,
    Nived N 
    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs
     Found my answer helpful? Please consider marking it as the solution!
     Your appreciation keeps me motivated. Thank you!

     
  • Suggested answer
    AnthonyAmador Profile Picture
    AnthonyAmador 2,516 on 06 Sep 2024 at 17:56:53
    Condense Multiple control actions with apply to each
    Hi,

    It is possible, but you have to work with the body of the response details to extract only the responses from the form and generate an array to iterate through with a condition to check if it is blank or not. That would be my approach.

    Hope this helps.
    Anthony

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

End of Year Newsletter…

End of Year Community Newsletter…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #11 New Opportunities…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,654

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,440

Leaderboard
Loading started