Separating Multiple Choice Data

(1) Share

Report

Posted on by brittanykeating

Hi there!

Within my Microsoft form I have a question that allows people to pick more than one option.

Currently, there are 18 options. Generally, the survey takers will not pick more than 4 options.

Is there a way to separate the responses into 4 columns, regardless which 4 were selected?

I don't want to have a column for each of the 18 answer choices.

I also don't want more than one answer in each column.

To give a visual idea:

Person 1: A.B.C.D.

Person 2: B.C.E.F.

Person 3: A.D.F.G.

Output:

A	B	C	D
B	C	E	F
A	D	F	G

Is this possible?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

trice602 15,329 Super User 2025 Season 2 on at

Like (0)

Report

Separating Multiple Choice Data

Hi,

Sure can. What you can do is initialize a string variable at the top of your flow and then add a condition and check if the length() of the question response is greater than 1. If true, append the variable with the response.

There's probably a more efficient way but this will get the job done. One condition for each question.

From there, what you can post in your Item is the output of your string variable which will contain all the answers that were answered.

------------------------------------------------

⭐ If this was helpful, please like and/or mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
trice602 15,329 Super User 2025 Season 2 on at

Like (0)

Report

Separating Multiple Choice Data

Hey there!

I am following up on this post separating multiple choice data in this category building flows from 11/12/2024. I know the post is a little older, but it is a common question here so wanted to take a moment and follow-up. I see there have been 1 replies and 1 likes and asking if your question has been answered. If so, please help the community out by completing one or more of the following actions! Thanks in advance!

Easy as 1-2-3 ‼️💯⭐😎🆒🙏

1) Mark a reply as a verified answer - this is essential, and it helps others with the same general question find this thread. ✅

2) You can also mark one of more replies as a verified answer. Please take a moment and give the author credit for volunteering their time. ✌️

3) Like one or more replies. Kudos always greatly appreciated! 👍

Pro tip: if you found your own solution or workaround, feel free to add a reply to your own post and mark it as the solution too! The goal is to get this thread marked with a verified answer by anyone that finds one or more replies helpful!

Again, thanks in advance for reading and responding, always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No
trice602 15,329 Super User 2025 Season 2 on at

Like (0)

Report

Separating Multiple Choice Data

If I can help with anything else please let me know or tag me in a future post, I enjoy reading and answering questions. Always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No