Flow for working with multiple choices in Microsoft Forms and SharePoint: Select and JSON

How to use JSON() and Select within Power Automate (Microsoft Forms) to work with multiple choices, even custom choices, easily.

[stug]

Had a whole afternoon getting frustrated with googling the answer to this - so simple. Thank you

[mattbrown]

Two years since you made the video, and I still can't find a better, more consistently performing, and easier way to do this. Thank you thank you thank you!

[deirdrewiley]

I wish I could upvote this video a million times. I was getting so frustrated trying to build this with other solutions posted online and something kept going wrong or not working quite right even after building these super-elaborate flows. This is simple, elegant and it works (plus, I understand why it works - great, clear explanation). Thank you so, so much!

[michaelbas]

Your approach is also working for more that 2 questions with multiple options! I wish I tried this since last week. It's been days now since I'm testing the approach with variables and still not successful. Thank you very much John Liu!

[kyleortman]

This is a fantastic video. I am not familiar with JSON() but after watching this video and our business case, we're gonna need it!

[rschmidt]

Wow! This is awesome! So much simpler than the other multi-step methods described by others :-)

[kevinwells]

Great solution! I was not able to use the select's output, but had to use the formula body('Select') in the Create Item action.

[JohnDoe-sulf]

THANK YOU! ... Just what I was looking for (lot of videoes does not focus on MS Forms choices).

[destroyzerplay]

Helped me a lot and more simple than others!!!

[GabrielPetrone]

Thanks man!! Tried a lot of alternatives from MS community but no one solved like you!

[gideonkenny]

You are a lifesaver! Can't thank you enough!

[hernebaybob]

Thank you so much. So new to this and spent hours looking at other solutions and failed. Followed your video and got there in the end. I am very pleased :-)

[johngrenfell]

So much better than the way I've been doing it with string manipulation!

[ged]

Absolute life saver with this video!!!

[michaeljuel]

Hi John Liu,

Thank you so much for this video <3 <3 <3

[kbsalui]

Thank you John. This works . If I want to split the choices into different rows, how to do this?

[nicoletimmons]

This is a fantastic video - thank you for sharing this solution! I have a question related to the "Other" option in your Microsoft Form... Is there any way to isolate the value entered into the "Other" option in Microsoft Forms when copying data to the SP list? In order to make Power BI reporting on this data as simple as possible, I created some columns to store "Yes" or "No" depending on whether specific options are selected. For example, I have an expression that says "If the Choices question response contains "Hotel" then enter "Yes" into the column called "Staying in Hotel", otherwise enter "No"." This works great. However, I can't figure out how to get to the "Other" option, aside from coming up with a complicated if/then statement that says "If the Choices question response is not blank and it does not contain "Hotel" or "Shelter" or "Staying with friends" then enter the response value, otherwise leave blank...

[tinsleyta]

Thank you so much! Been seeking how to do this for some time now.

[pfenix]

What is the script editor you're using middle of the video. For a beginner like me that looks amazing. Is it something I can buy somewhere?

[samdacombe]

Thanks John, this is great. I seem to be having an issue if one of the mulitchoice questions has no answer and the value is "null"