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

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

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

  • @stug45
    @stug45 4 года назад +5

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

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

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

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

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

    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!

  • @JohnDoe-su3lf
    @JohnDoe-su3lf 3 года назад

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

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

    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.

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

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

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

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

  • @hernebaybob
    @hernebaybob 4 года назад +1

    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
      @LordXOne 4 года назад

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

  • @GabrielPetrone
    @GabrielPetrone 3 года назад

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

  • @johngrenfell2936
    @johngrenfell2936 3 года назад

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

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

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

  • @ged1086
    @ged1086 3 года назад

    Absolute life saver with this video!!!

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

    Hi John Liu,
    Thank you so much for this video

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

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

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

    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"

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

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

  • @93maanoj
    @93maanoj 4 года назад

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

  • @tinsleyta77
    @tinsleyta77 4 года назад

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

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

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

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

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

  • @sallekma
    @sallekma 4 года назад

    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.

  • @shellymayo1723
    @shellymayo1723 4 года назад +1

    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?

  • @pfenix88
    @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?

  • @melissaprindiville1876
    @melissaprindiville1876 4 года назад +1

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

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

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

      @@choiyoonmi4679 me too!

  • @carterprine3332
    @carterprine3332 4 года назад

    Thank you! Very clear and helpful!

  • @snuggles4eva
    @snuggles4eva 3 года назад

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

  • @Vladimir-c4k
    @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 :)

  • @vinayayinapurapu
    @vinayayinapurapu 4 года назад

    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?

  • @erixo21
    @erixo21 3 года назад

    THANK YOUUUUUUUUUUUU!!!!

  • @AMERICACOLCHOES
    @AMERICACOLCHOES 4 года назад

    Awesome. Very usefull! Tks a ton

  • @mathildel2083
    @mathildel2083 4 года назад

    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
      @neilp6208 4 года назад

      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.

  • @Comrade_Nikolai
    @Comrade_Nikolai 3 года назад

    thanks king!