Break out MS Forms multiple choice checkboxes

(0) Share

Report

Posted on by Community Power Pla...

I need to turn an array style list of multiple choice check box answers into an iterated format.

I need to take these answers and break them out one checkbox at a time.

Formatted like this:

Indicate Subjects Discussed directly or indirectly:

My Dignity / how I feel people treat me

(carriage return)

My Safety

(carriage return)

My Home / My Placement / My Space

...

Any idea how to achieve this?

Currently all I'm getting out of the raw output is:

["My Dignity / how I feel people treat me","My Safety","My Home / My Placement / My Space",...]

This formatting as it is is making it incredibly difficult to read the information accurately and speedily.

Any help is deeply appreciated.

All responses (4)

Answers (1)

Community Power Pla... on at

Like (0)

Report

Re: Break out MS Forms multiple choice checkboxes

This is exactly what I needed!!!

Thank you so so much @v-LilyW-msft and @RezaDorrani!!! You guys rock!!!

I've finally got it to spit out the results in a running list format. I'll attach the test document.

Thank you again!!
Verified answer

v-LilyW-msft on at

Like (1)

Report

Re: Break out MS Forms multiple choice checkboxes

Hi @Anonymous
Please take a try to use Join action like below.
After flow runs, Test2 will receive an email like this:
Hope the content above may help you.
Best Regards
Community Power Pla... on at

Like (0)

Report

Re: Break out MS Forms multiple choice checkboxes

Hey Reza,

This video demonstrates exactly what I want to accomplish with my data format, but I'm having a difficult time understanding what I need to accomplish to achieve my goal.

I've followed the steps in the linked video and I get a more formatted string still enclosed in braces.

I'm missing something, I'm certain of it. I'm not sure what I don't know though, so this is really tricky.

Could you walk me through the steps piece by piece?

Thank you very much for your assistance, Reza.
RezaDorrani 12,141 on at

Like (1)

Report

Re: Break out MS Forms multiple choice checkboxes

Hi @Anonymous

Check https://www.youtube.com/watch?v=kbqXsKPTmZk

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter