Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Power Platform Community / Forums / Power Automate - AI Builder / Condense Multiple cont...
Power Automate - AI Builder
Suggested answer

Condense Multiple control actions with apply to each

(2) ShareShare
ReportReport
Posted on by Davefin 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:
Form Processing
  • Davefin Profile Picture
    Davefin 24 on at
    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,047 on at
    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 at
    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.
  • Nived_Nambiar Profile Picture
    Nived_Nambiar 16,047 on at
    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 at
    Condense Multiple control actions with apply to each
    Do you guys have any examples? 
  • Suggested answer
    Nived_Nambiar Profile Picture
    Nived_Nambiar 16,047 on at
    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,512 on at
    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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

September 2024 Newsletter…

September 2024 Community Newsletter…

Community Update Sept 16…

Power Platform Community Update…

Welcome to the new Power Platform Community!…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 141,122

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,414

Leaderboard

Featured topics

Question for everyone : How are you using Create Text GPT in AI Builder?

Product updates

Microsoft Power Platform Community release plans