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!
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.
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.
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 [" ,"] '
Thank you for this. Another example of Microsoft making something way harder than it needs to be and actually bastardizing a standard programming thing
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!
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?
@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.
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?
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?
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?
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
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...
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?
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.
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!
Two days I’ve been trying to figure this out! Your explanation was so much clearer and simpler than any other I’ve found!
Glad you found this helpful. Thank you for the comment
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!
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.
Configure Run Options is a gold mine for me.
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.
Glad you found this helpful
THANK YOU for these golden tips💯! I'm a newbie and it took me forever to figure this format issue!
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 [" ,"] '
Glad you found this useful
Thanks very much for sharing, it worked perfectly for me with some tweaks! A star!
Thank you for this. Another example of Microsoft making something way harder than it needs to be and actually bastardizing a standard programming thing
Thank you for this. The second method is so preferable👍
Thank you for your support
You’re awesome bro😎
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!
Thanks for the new material.
Can this output be used for performing filter in the get rows action?
How would you do this if you have multiple-multi-select questions? Say I have 4 or 5 questions with multiple multi-select options.
I will try this scenarios and see what is possible
@@TheOyinbooke I have the same scenario as this.
@@TheOyinbooke Hi. Were you ever able to figure out how to process multiple multi-select questions?
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?
Any comments for this?
@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.
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?
how to make Get response details dynamic content available, I cant fetch it says "No dynamic content available". When using "Join" action
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?
Thank you for this use case. I will explore its possibilities and do a video on it
My flow keeps throwing an error when nothing is selected for the multi choice field. Please what can I do
See the solution here ua-cam.com/video/8_fas_2M3t8/v-deo.html
same.
Does it work in the Document library too?
Hi There - I don't seem to see the Apps Familiar With field in the Create Item section. Any idea why that is? Thanks
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?
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
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...
@@TheOyinbooke All right. Thanks for the clarity.
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?
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?
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.
@@TheOyinbooke it would be great to see a tutorial on "empty"😊😊
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!
This is a great video, so helpful, are you able to past the expression in a reply?
Here is a use case that can be applied to the same scenarios
ua-cam.com/video/8_fas_2M3t8/v-deo.html
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.
I will look into this scenario
Can we have the answer vertically as well?
When i create html file of this i need to have all possible answer vertically, but its coming with ,;”[ and horizontaly.
I believe we can. I will explore the possibility and share a video on it
@@TheOyinbooke hi, did you get any solution for getting the responses vertically?