This should be relatively simple depending on your experience. All you need to do is put the form response with the multiple responses into an Array.

Power Automate - Building Flows

Answered

Turn multiple choices in Microsoft Forms into multiple rows in Excel

Like (0) Share

Report

Posted on 1 Dec 2023 21:24:47 by CU16121921-0

content removed

Categories:

Business Process Flows

All responses (17)

Answers (1)

cjatseaspan 4 on 02 Jul 2024 at 14:26:10

Like (0)

Report

Re: Turn multiple choices in Microsoft Forms into multiple rows in Excel

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.
SunnyRKFOODLAND 101 on 01 Jul 2024 at 06:30:38

Like (0)

Report

Re: Turn multiple choices in Microsoft Forms into multiple rows in Excel

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
split(outputs('Compose'),',')
trim(item()) not equal to (blank)
and then use initialize variable and use the output of filter array in value

Hope This Helps your problem
If I helped you please accept it as a solution and hit like.
Thanks
SunnyRKFOODLAND 101 on 01 Jul 2024 at 05:06:49

Like (0)

Report

Re: Turn multiple choices in Microsoft Forms into multiple rows in Excel

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?
cjatseaspan 4 on 28 Jun 2024 at 17:43:21

Like (0)

Report

Re: Turn multiple choices in Microsoft Forms into multiple rows in Excel

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
SunnyRKFOODLAND 101 on 28 Jun 2024 at 04:47:12

Like (0)

Report

Re: Turn multiple choices in Microsoft Forms into multiple rows in Excel

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
Nicole2 2 on 30 May 2024 at 21:59:26

Like (0)

Report

Re: Turn multiple choices in Microsoft Forms into multiple rows in Excel

I want to ask about how to form the JSON part! Thanks
SunnyRKFOODLAND 101 on 05 Feb 2024 at 11:39:52

Like (0)

Report

Re: Turn multiple choices in Microsoft Forms into multiple rows in Excel

How can I achieve this in Sharelist
CU16121921-0 on 22 Jan 2024 at 22:47:37

Like (0)

Report

Re: Turn multiple choices in Microsoft Forms into multiple rows in Excel
wskinnermctc 6,517 Super User 2025 Season 1 on 14 Dec 2023 at 14:41:15

Like (0)

Report

Re: Turn multiple choices in Microsoft Forms into multiple rows in Excel

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.
CU-19081224-4 39 on 13 Dec 2023 at 18:30:30

Like (0)

Report

Re: Turn multiple choices in Microsoft Forms into multiple rows in Excel

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.