Power Automate Tutorial: Entering Multi-Choice Responses from Microsoft Forms to SharePoint
Vložit
- čas přidán 11. 07. 2024
- In this video Jonathon explains how to take multi-select responses on a Microsoft Form to properly appear on a SharePoint list. Take note of how he uses the Select data operation to shape the JSON to appear properly within the Create Item on a SharePoint list action for Power Automate.
👍 If you enjoy this video and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Jonathon30" at check out when purchasing our On-Demand Learning classes to get an extra 30% off - pragmaticworks.com/pricing/
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: tinyurl.com/2ujujsb5
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/
Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️CZcams: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com
#PragmaticWorks #JonathonSilva
~-~~-~~~-~~-~
Please watch: "(275) Free Pragmatic Works Power Apps Component Library "
• Free Power Apps Compon...
~-~~-~~~-~~-~
This is exactly what I needed for a flow I’m working on. Thank you for the simple pragmatic approach. ❤
super helpful thank you! Cannot say I understood what this does exactly but it worked
Thank you for the easy tutorial! Exactly what I needed 🙂
Great video! Any tips on how you can map the results of 2 multiple choice questions to one list column using Power Automate? I did try a join but since one of the questions could have blank answers it did not work.
Thank you so much!
Your clear explanation really helps and very easy to understand for a beginner like myself.
Thanks for this quick tutorial, it was exactly what I needed. Love your work!
Glad it was helpful! Thanks!
Thank you, it worked splendidly. .
Thank you!
Great tip, Jonathon!
Glad it was helpful!
Excellent!!
Hi, great video! I ran into an error when I only select 1 option from the question. Error:"The 'from' property value in the 'select' action inputs is of type 'String'. The value must be an array." Do you have any advice on solving this? TIA
Hi, this was easy to follow but I have a question, I have a form with multiple, multiple choice questions and cannot get the flow to work, do you have any advice of a video I have not found of yours to show me? Thanks in advance
When the multi select is empty, the flow fails as JSON can't handle null value
Hi, possible to split those multiple choice into different row in sharepoint list?
Hi Jonathon, could you explain the same but for a SharePoint list (copy of items between 2 SP lists). Thank you!
Hi! I need to do this in my document library... is this process valid only for lists?
Thank you so much. Does this work if the input was a "For a selected file" > Add an input (multi-select text list)? I have triied but I cannot get the input to appear in the Dynamic List for the From json() expression??
I could solve it by doing a workaround. Check it on the other comment similar as yours
Great tutorial, but I need to know the quiz score in addition to the start time to calculate the duration of the assessment.
Is there any way to get this data?
What if you have a few choice columns. Should you keep creating more selects etc
Thanks for the tutorial! Just one question, when I'm at the "Create Item" step, mine doesn't have the option "Switch to input entire array". Could you please share if there are other settings to change or something we can work around it? Thanks!
I was able to get the option when I changed the column type in the list to Choice and allowed multiple selections
Such a great video! But still have a follow up question. What do you do when you have a form with Different Multiple Choise Questions?:
Do you have to add more SELECT functions and replicate the same process? Thanks!
did you found the answer?
@itanandrevalenciamendez2370 - Did you ever find the answer to how to do this when you have more than one multiple-choice question?
@@AntoniaMartinezPhddid you ever figure this out ? I need help with this also
Thank you for the video! This was very easy to follow and has gotten me most of the way to where I want for the multi-select choice question... but I'm still seeing a slight bug.
I've gone through my Flow with the video playing several times to make sure I followed each step, and I definitely did everything the same as the video. Each time I make a new submission the first entry for that question comes out looking the same as if I didn't do the 'Select' formatting. It doesn't use one of the choices for the question. This happens no matter which selection is the 'first' selection for that question.
Is there a way to fix this?
I followed this video very closely and couldn't get the Select action to work either. At 11:55 Mr. Silva says "we're going to label that with a value and then each item separately after that." I'm not sure what he means. At any rate, when I run my flow, my data in SharePoint contains [{"Value": DATA1}, {"Value": DATA2}].
Hi sir I have one requirement, 3 years old SharePoint files should auto move into archived folder..
How to complete this requirement..
Please make video on lookup field from SharePoint in power automate it comes as ID how to resolve it?
The dynamic content doesn't show up for the Select JSON function unless I turn off "Split On" for the "When a new response is submitted" in which I can't select ResponseID for the "Get response details" step. What do?
Me too. Could you solve it? whats the functionality of split on?
@@luizhct22 check your column on the list and make sure multi choice in disabled
@@michaelcha6278 but if its disabled, I will have problem in the Create Item, making the "Switch to input entire array" option do not appear. No?
@@luizhct22 are you using the new powerautomate interface?
Hi I could solve it putting the json actions below the create item, erase the multiple answer question on the previous one, and create another create item below this actions, just with the multiple answer question.
Edit: it didnt work, it created two items :(
didn't work for me :(