Power Automate Tutorial: Entering Multi-Choice Responses from Microsoft Forms to SharePoint

Подписаться 227 тыс.

Просмотров 15 тыс.

50% 1

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
✔️RU-vid: / 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...
~-~~-~~~-~~-~

Опубликовано:

31 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

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

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

This is exactly what I needed for a flow I’m working on. Thank you for the simple pragmatic approach. ❤

@amichinen7510 Год назад

Thank you so much! Your clear explanation really helps and very easy to understand for a beginner like myself.

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

Thank you for the easy tutorial! Exactly what I needed 🙂

@RobynJarman Год назад

Thanks for this quick tutorial, it was exactly what I needed. Love your work!

@PragmaticWorks Год назад

Glad it was helpful! Thanks!

@marie-andreefurlong354 8 месяцев назад

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.

@erickung4302 Месяц назад

Thank you, it worked splendidly. .

@TiGGowich Месяц назад

super helpful thank you! Cannot say I understood what this does exactly but it worked

@AdiCristea Год назад

Great tip, Jonathon!

@PragmaticWorks Год назад

Glad it was helpful!

@bennyj33 Год назад

Thank you!

@davidalonsogarciachirinos6112 28 дней назад

Excellent!!

@leeellis633 День назад

im just wondering why my array isnt available in the select action?? i can see the array if i use a compose but for some reason i dont have any dynamic content using the select action..

@brs14sa 10 месяцев назад

When the multi select is empty, the flow fails as JSON can't handle null value

@user-fl7us1jj8u Год назад

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

@mikenitti2546 Год назад

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

@user-qi9dv1so4f 11 месяцев назад

Hi, possible to split those multiple choice into different row in sharepoint list?

@claudiantenegri2612 Год назад

Hi Jonathon, could you explain the same but for a SharePoint list (copy of items between 2 SP lists). Thank you!

@gavinklose4403 Год назад

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??

@luizhct22 4 месяца назад

I could solve it by doing a workaround. Check it on the other comment similar as yours

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

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?

@londonengland2309 3 месяца назад

What if you have a few choice columns. Should you keep creating more selects etc

@cravocanela 2 месяца назад

Hi! I need to do this in my document library... is this process valid only for lists?

@cassidykjwei1264 Год назад

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!

@howtoguidesamharic5071 10 месяцев назад

I was able to get the option when I changed the column type in the list to Choice and allowed multiple selections

@AwesomeAbdul4q Год назад

Hi sir I have one requirement, 3 years old SharePoint files should auto move into archived folder.. How to complete this requirement..

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

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?

@luizhct22 4 месяца назад

Me too. Could you solve it? whats the functionality of split on?

@michaelcha6278 4 месяца назад

@@luizhct22 check your column on the list and make sure multi choice in disabled

@luizhct22 4 месяца назад

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

@michaelcha6278 4 месяца назад

@@luizhct22 are you using the new powerautomate interface?

@luizhct22 4 месяца назад

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

@kyunkal 5 месяцев назад

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?

@alaindewitt 3 месяца назад

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}].

@itanandrevalenciamendez2370 Год назад

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!