content removed
Hi @SunnyRKFOODLAND. No, there are no sections. I have 87 continuous questions and based on a selection it branches to a certain point and I have end of form at multiple questions in between.
Below is the Test Form
I am adding data To Excel table
and now the FLow
Add all Trailer Numbers in Compose Action
in next action use filter array and use below formula
From
Hope This Helps your problem
If I helped you please accept it as a solution and hit like.
Thanks
Does your Microsoft Form have a section for Each Selection & each Section must have 1,1 2, 123 till 6th option for entering.
Am I Right?
Hi @wskinnermctc,
I have a similar question but its not exactly multiple choice. I have a question that has 5 options.
When I select 1 it asks details for 1 trailer
When I select 2 it asks me information of 2 trailers, then
and so on.
Right now on one submit every trailer information gets saved in one record. There's also branching involved so there can be another reservation for more trailers.
What I need is that if there were 2 trailers selected, then the information captured in those 2 text boxes should be captured in 2 different rows and not one. Is that possible through Power Automate?
Let me know in case you have further questions
Regards
CJ
action before the Json you need run then to flow and then copy the output and then in then add parse json action and then click generate json from example and paste copied output in that and done. you will get json
I want to ask about how to form the JSON part! Thanks
How can I achieve this in Sharelist
Hi @qphalen , if I'm understanding your question correctly, the process would be relatively the same except you would need an additional array in the beginning for the names, then apply to each the names array similar steps from the example.
However, I don't understand how the multiple names are going to be identified? They are selecting the multiple names from the form (why would names be available for selection)? Or will they enter the multiple names via text?
I think if they are entering the names via text then you will have an issue with errors trying to splice out individual names. Then you will start running into problems dealing with actions on single names vs multiple names.
I think they should just submit a single form per-person. It is not an unreasonable request functionally. A form should take no more than 30 seconds or a minute to complete, so that is like 2 minutes for 2 employees at most.
Meanwhile you will spend hours trying to construct a flow that can be flexible and prevent errors, just so they can input multiple people at once. The cost benefit will be to have a single form submission per person.
If you need more assistance, you should submit a new post to the forum. Solvers/SuperUsers don't really look at older posts that were solved, so you would get an answer with a new post that is unsolved.
Hi @wskinnermctc - thanks for this solution as you have also helped me solve my problem! But I am wondering if it is possible to extend this further. I have a form where I would like to be able to select multiple names and multiples of another question which is Products as this is for a training request.
Essentially a manager would submit multiple names to be trained on multiple products and I would like these to come through as individual lines.
In OPs post - what if there were 2+ names to choose (Tom Hanks and Stevie Wonder) and they were all to be joining BCY, ATL and NCC. That way I wouldn't have to submit a new form for each individual person.
Can I use the same process to isolate the names as well as the LERT's? That way each has their own row in excel.
stampcoin
87
Michael E. Gernaey
70
Super User 2025 Season 1
David_MA
48
Super User 2025 Season 1