How to Process MS Forms Multiple Choice Field in Power Automate

[@ivettesilvas697]

Two days I’ve been trying to figure this out! Your explanation was so much clearer and simpler than any other I’ve found!

[@TheOyinbooke]

Glad you found this helpful. Thank you for the comment

[@joannepope7132]

Olanrewaju, thanks so much!! I'm brand new to Power Automate, and this type of detail is really confusing. Your video is the only one that explained things simply and clearly, and I was able to replicate it in my own work. I'm looking forward to combing through the rest of your videos!

[@TheOyinbooke]

Hi JoAnne Pope, Thank you for your comment and support. I am glad you find this useful. Do let me know of any unique use case you are trying to solve, I can create content on it for you.

[@jonsteen6141]

Configure Run Options is a gold mine for me.

[@M365PowerAdmin]

Dude, you have helped me out so much with this video. The outputs into email have been driving my team mad recently and this helps tidy up the process perfectly.

[@TheOyinbooke]

Glad you found this helpful

[@billypope]

Thanks very much for sharing, it worked perfectly for me with some tweaks! A star!

[@val136Amstel]

THANK YOU for these golden tips💯! I'm a newbie and it took me forever to figure this format issue!

[@sarahvandeberg8510]

Thank you so so much! I spent hours trying to work out how to take multi choice questions from a Form and put into a choice field in Lists! I was using a method from Intelogy but I think the initialize variable was in the wrong place, so your method worked great (although I used her additional compose action to remove the superfluous [" ,"] '

[@TheOyinbooke]

Glad you found this useful

[@jayfab4689]

Thanks for the new material.

[@whatisiswhatable]

Thank you for this. Another example of Microsoft making something way harder than it needs to be and actually bastardizing a standard programming thing

[@ebubefestus2186]

Thank you for this. The second method is so preferable👍

[@TheOyinbooke]

Thank you for your support

[@bobbirowlett6728]

Very happy with this explanation. You give us two options. That is great! I like the simplicity of the JSON. Thank you! Is it possible to grab each selection and put it as a check box in a Word template? Thanks again!

[@bhuvanasaravanan4105]

You’re awesome bro😎

[@dalebraden9556]

Great video! you saved me a lot of time and frustration. I used your examples to populate a word document but would very much appreciate an example of how I can format the output vertically?

[@gunasekaran4288]

Any comments for this?

[@umairismail9555]

Can this output be used for performing filter in the get rows action?

[@samratthakar41295]

Thank you so much for the video! Can we add multiple input on Json or we have to use multiple Json one by one for more than one multiple-choice answers?

[@cravocanela]

Does it work in the Document library too?

[@TheDers907]

How would you do this if you have multiple-multi-select questions? Say I have 4 or 5 questions with multiple multi-select options.

[@TheOyinbooke]

I will try this scenarios and see what is possible

[@RockyHughes-c4t]

@@TheOyinbooke I have the same scenario as this.

[@AntoniaMartinezPhd]

@@TheOyinbooke Hi. Were you ever able to figure out how to process multiple multi-select questions?

[@cina070206]

I am extracting data from MS forms, getting the response details and creating an item in SharePoint and then sending out an email containing the Reponses from the form. I have the responses for 20 form questions in the body of the email. Do I need to complete this exercise for each response value?

[@6psycho9]

​ @Microsoft Power Tools What if I have multiple questions with multiple choice. How can I strip this out? That way I can draft an email with the responses from the MS Form.

[@MalekAlthubiany]

how to make Get response details dynamic content available, I cant fetch it says "No dynamic content available". When using "Join" action

[@catorolea7122]

Hi There - I don't seem to see the Apps Familiar With field in the Create Item section. Any idea why that is? Thanks

[@RockyHughes-c4t]

Hello and thank you for making these videos. I was able to implement your solution and have successfully been able to format the output from a Multiple Choice Field on a form that I have created. However, I have four other questions on the same form that also allow multiple answers. I have attempted using commas within the json() to separate out each question. I have tried creating multiple compose and join statements (one for each question). Among a few other things. All fails. Any help is appreciated! Thank you in advance!

[@azeezadegbenro7354]

The second method is simple 😁. Thank you. Is there anything "Compose" function can do that "join" cannot do or any scenario where we can use "Compose" and "join" will not not work, if no, i go with the second method

[@TheOyinbooke]

Thank you @Azeez for your comment. Compose action card basically can take any expression. It is meant to evaluate expressions. I only use the replace function because that is what I need to use. I can use several other functions. But the primary work of JOIN Action card is to join two or more characters. Or even sentence, names etc...

[@azeezadegbenro7354]

@@TheOyinbooke All right. Thanks for the clarity.

[@gunasekaran4288]

Hi am looking this is one from morning. Great finally I got it But I have similar scenario. I need create a line item based on multi choice column count. If examples 4 line need to create for unique ID. Is it possible in power automate?

[@JT-gd4pv]

Can you make each multi-response selection create a separate sharepoint entry? Essentially let the customer select multiple, but it enters SharePoint like separate responses?

[@TheOyinbooke]

Thank you for this use case. I will explore its possibilities and do a video on it

[@ogunmolaololade7600]

My flow keeps throwing an error when nothing is selected for the multi choice field. Please what can I do

[@TheOyinbooke]

See the solution here kzbin.info/www/bejne/bpDJkqaVZ7Jmqpo

[@slcrab19]

same.

[@robh2489]

This is a great video, so helpful, are you able to past the expression in a reply?

[@TheOyinbooke]

Here is a use case that can be applied to the same scenarios kzbin.info/www/bejne/bpDJkqaVZ7Jmqpo

[@redbug2011]

Thank you for this tutorial. What if I am sending the response via e-mail and wanted it to be separated by comma as well.

[@TheOyinbooke]

I will look into this scenario

[@yilinjia5627]

Hi sir, If one value from Form is empty, how can I use automate to return a fixed value, like N/A into SharePoint list?

[@TheOyinbooke]

Hi Yilin Jia, You can use Power Automate Expression "empty" to check if the said field is null. Add a condition action card to it and define what happened if null or not. Do let me know if you need me to do a brief tutorial on this.

[@robh2489]

@@TheOyinbooke it would be great to see a tutorial on "empty"😊😊

[@manjulmishra990]

Can we have the answer vertically as well?

[@manjulmishra990]

When i create html file of this i need to have all possible answer vertically, but its coming with ,;”[ and horizontaly.

[@TheOyinbooke]

I believe we can. I will explore the possibility and share a video on it

[@Kabita221]

@@TheOyinbooke hi, did you get any solution for getting the responses vertically?