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

[@stug45]

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

[@mattbrown4783]

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!

[@deirdrewiley6352]

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!

[@michaelbas4259]

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!

[@kyleortman6689]

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!

[@rschmidt2691]

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

[@kevinwells990]

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-su3lf]

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!

[@gideonkenny7471]

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 :-)

[@LordXOne]

Seconded - I've been tinkering with variables (one per choice, which looked ugly) and trying to pass them into SharePoint online for a couple of days. I wish I'd found this video sooner! Cheers :)

[@johngrenfell2936]

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

[@ged1086]

Absolute life saver with this video!!!

[@michaeljuel2]

Hi John Liu, Thank you so much for this video

[@93maanoj]

Worked perfectly...... thanks very much John !

[@kbsalui]

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

[@nicoletimmons2344]

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

[@tinsleyta77]

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

[@pfenix88]

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?

[@carterprine3332]

Thank you! Very clear and helpful!

[@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"

[@shellymayo1723]

John, thanks for this video. How would you pass multiple email addresses from a MS Form field into a SharePoint Person or Group selector which allows multiple selections? I can send a single email address from the form, and SharePoint will transform it to Name (with Presence), but I cannot send multiple ones. Any ideas?

[@sallekma]

Hi John Liu... thanks finally I’m able to do it... but what if I have more than two option controls on the form that is accepting multiple options? I repeating the steps with having second “Select” but them I’m getting “Outputs” ..and its not formatting as intended.

[@snuggles4eva]

@John Liu Absolutely loved it John. Very well put together. I am struggling with this. I am using MS Forms with cascading dropdowns and sending it to Dataverse through Flow. All works except for the dropdown outputs. The first dropdown (Company) branches to two different sections (Clients) so it is not easily picked up in Flow. Those dropdowns branch into about 10 different branches (Sites). Should I look for the solution in MS Forms or in Flow? I have watched your "Flow for working with multiple choices..." and think it could be done by using a loop to find the "Client" that is selected and also the selected "Site" but not sure how to put that into JSON. Your help is appreciated. Thanks John.

[@lztoniolo]

How do you create that Other field in forms, so the user can enter their own information/data? Thanks

[@ddelamont]

This works perfectly for me when my multi-select choice field from my Form has one or more of the options selected, but sometimes that field is null due to branching in my form. When it's skipped, I get an error in my flow on the select block: The 'from' property value in the 'select' action inputs is of type 'Null'. The value must be an array. How can I adjust it to handle cases when that field is null?

[@samdacombe]

Hi Darryl, have you figured out an answer to this yet?

[@AMERICACOLCHOES]

Awesome. Very usefull! Tks a ton

[@erixo21]

THANK YOUUUUUUUUUUUU!!!!

[@vinayayinapurapu]

Liu, thanks for the nice article. I followed exactly the same steps but with out 'compose' i am running into issue 'The from property in the select option is of type string'. Once i use compose and take the 'Outputs' from compose action and using that in 'From property' of select option sorted the issue out. Not sure what i was doing wrong though, but i have to keep the 'compose' in order to make the flow work to capture the form responses. Is there any recent update from Power Automate side for 'Select' action?

[@waellkhanji3466]

i need your help please

[@melissaprindiville1876]

What happens if the MS Form question is not required. An error is then returned Input type of Null. The value must be an array. How do you solve?

[@choiyoonmi4679]

Have you found the solution? I'm facing the same error.

[@samdacombe]

@@choiyoonmi4679 me too!

[@Comrade_Nikolai]

thanks king!

[@mathildel2083]

Hi John ! I get an empty field in my list after following the tutorial. The body input looks of create item in sharepoint good but the output goes like this: "CommunityKeywords": [], Any advice ? :)

[@neilp6208]

Power Automate has changed a little since John made this video. I found that I did not need to use a compose step to build my json statement. In the "from" field of the Select step, I used the Expression tab to add the json() function. Then, between the parentheses of the json function, I used Dynamic Content to insert the Choice field from my Microsoft Form. Note the syntax this creates looks a little different now than what is seen in this video. I built the Map part of the Select step the same as John.

[@Vladimir-c4k]

The SELECT throws an error if question number 2 is not answered. If answered, it works. Update: IF you move Select under the Condition under if Yes, it will work :)