How to Process MS Forms Multiple Choice Field in Power Automate

Поделиться
HTML-код
  • Опубликовано: 2 дек 2024

Комментарии • 52

  • @ivettesilvas697
    @ivettesilvas697 2 года назад +4

    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
      @TheOyinbooke  2 года назад

      Glad you found this helpful. Thank you for the comment

  • @joannepope7132
    @joannepope7132 2 года назад +1

    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
      @TheOyinbooke  2 года назад

      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
    @jonsteen6141 3 месяца назад

    Configure Run Options is a gold mine for me.

  • @M365_Minion
    @M365_Minion 2 года назад +1

    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.

  • @billypope
    @billypope Год назад

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

  • @sarahvandeberg8510
    @sarahvandeberg8510 2 года назад +1

    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 [" ,"] '

  • @val136Amstel
    @val136Amstel 2 года назад

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

  • @jayfab4689
    @jayfab4689 3 года назад +1

    Thanks for the new material.

  • @bobbirowlett6728
    @bobbirowlett6728 11 месяцев назад

    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
    @bhuvanasaravanan4105 Месяц назад

    You’re awesome bro😎

  • @umairismail9555
    @umairismail9555 9 дней назад

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

  • @6psycho9
    @6psycho9 2 года назад +1

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

  • @ebubefestus2186
    @ebubefestus2186 2 года назад +1

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

  • @whatisiswhatable
    @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

  • @samratthakar41295
    @samratthakar41295 2 года назад

    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?

  • @cina070206
    @cina070206 9 месяцев назад

    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?

  • @MalekAlthubiany
    @MalekAlthubiany 6 месяцев назад

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

  • @catorolea7122
    @catorolea7122 2 года назад

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

  • @TheDers907
    @TheDers907 Год назад +2

    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
      @TheOyinbooke  Год назад

      I will try this scenarios and see what is possible

    • @RockyHughes-c4t
      @RockyHughes-c4t Год назад

      @@TheOyinbooke I have the same scenario as this.

    • @AntoniaMartinezPhd
      @AntoniaMartinezPhd 9 месяцев назад

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

  • @dalebraden9556
    @dalebraden9556 2 года назад

    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?

  • @JT-gd4pv
    @JT-gd4pv 2 года назад +2

    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
      @TheOyinbooke  2 года назад +2

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

  • @RockyHughes-c4t
    @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!

  • @ogunmolaololade7600
    @ogunmolaololade7600 2 года назад +2

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

    • @TheOyinbooke
      @TheOyinbooke  2 года назад +1

      See the solution here ruclips.net/video/8_fas_2M3t8/видео.html

    • @slcrab19
      @slcrab19 Год назад

      same.

  • @gunasekaran4288
    @gunasekaran4288 2 года назад

    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?

  • @cravocanela
    @cravocanela 6 месяцев назад

    Does it work in the Document library too?

  • @azeezadegbenro7354
    @azeezadegbenro7354 3 года назад +1

    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
      @TheOyinbooke  3 года назад +1

      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
      @azeezadegbenro7354 3 года назад

      @@TheOyinbooke All right. Thanks for the clarity.

  • @robh2489
    @robh2489 2 года назад +1

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

    • @TheOyinbooke
      @TheOyinbooke  2 года назад

      Here is a use case that can be applied to the same scenarios
      ruclips.net/video/8_fas_2M3t8/видео.html

  • @yilinjia5627
    @yilinjia5627 3 года назад +1

    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
      @TheOyinbooke  3 года назад

      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
      @robh2489 2 года назад

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

  • @redbug2011
    @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.

  • @manjulmishra990
    @manjulmishra990 2 года назад

    Can we have the answer vertically as well?

    • @manjulmishra990
      @manjulmishra990 2 года назад

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

    • @TheOyinbooke
      @TheOyinbooke  2 года назад

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

    • @Kabita221
      @Kabita221 2 года назад

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