cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jakson
Helper III
Helper III

Break out MS Forms multiple choice checkboxes

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

 

example3.jpg

 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.

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Jakson 

Please take a try to use Join action like below.

vLilyWmsft_3-1635391396978.png

After flow runs, Test2 will receive an email like this:

vLilyWmsft_1-1635391130354.png

Hope the content above may help you.

Best Regards

View solution in original post

4 REPLIES 4
RezaDorrani
Dual Super User II
Dual Super User II

Hi @Jakson 

 

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

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.

Hi @Jakson 

Please take a try to use Join action like below.

vLilyWmsft_3-1635391396978.png

After flow runs, Test2 will receive an email like this:

vLilyWmsft_1-1635391130354.png

Hope the content above may help you.

Best Regards

View solution in original post

testfile.jpg

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!!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (3,006)