Help! --> 3 random selections from a multiple choice of 10 on Forms - transferred to Excel so each has it's own column space

(0) Share

Report

Posted on by CU09091727-0

Power Automate multi choice issue.PNG Please help......

This graphic explains what I want to do ----->

I need to get a multiple choice question from Microsoft Forms where people choose 3 characteristics out of a selection of 10..............and have an Automate Flow that takes the individual's choices (whatever they are), separates them into 3 distinct answers and then can be entered as single items in an existing spreadsheet that has 3 columns.

Behaviours Split Automate so far.PNG This is what I have so far for this particular issue ---->

I think it might be something to do with creating an Output(s) via a 'Compose' element or a number of them, or maybe an array of some sort.....?

I just can't seem to make it 'click' in my mind and know how to do it correctly.

Please can someone help me to resolve this issue?

Everything else I've programmed separately has worked fine, but I just can't seem to get my head around this one aspect of the Flow! Thanks in advance. 🙂

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (2)

Verified answer

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (1)

Report

Use a Compose action and a Select action. Your json() expression can go into the Compose action. Use the Select action to Compose the results.
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

Was this reply helpful? Yes No
CU09091727-0 76 on at

Like (0)

Report

How would I get that to translate the three individual items from the array onto the three separate columns in Excel though?

It keeps just loading all three into the first column when I try to use arrays/split.

Was this reply helpful? Yes No
CU09091727-0 76 on at

Like (0)

Report

Like this.............

Was this reply helpful? Yes No
Verified answer

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (1)

Report
The Select action will produce an Array. So you can access each item with the array index.
[insert select action output here][0]['value']
First position will be [0], second [1]....

Hope this helps!

Was this reply helpful? Yes No
CU09091727-0 76 on at

Like (0)

Report

Ok I'll give it a try and see how it goes. 🙂

Was this reply helpful? Yes No
CU09091727-0 76 on at

Like (1)

Report

It worked perfectly.............Thanks for your help! 🙂

Was this reply helpful? Yes No