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

Рет қаралды 17,427

Pragmatic Works

Күн бұрын

Пікірлер: 44

@sudosaurus 9 ай бұрын

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

@marie-andreefurlong354 11 ай бұрын

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.

@leeellis633 2 ай бұрын

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

@RobynJarman Жыл бұрын

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

@PragmaticWorks Жыл бұрын

Glad it was helpful! Thanks!

@amichinen7510 Жыл бұрын

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

@simondittmann2883 Ай бұрын

Great video!! For anyone having trouble with this, try creating a new column in the SPO list under 'See all column types,' select 'Choice,' and then 'Checkboxes' - this will allow you to select the option 'Switch to detail inputs for Array item' in Power Automate.

@TiGGowich 4 ай бұрын

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

@GlynnRyan Жыл бұрын

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

@AdiCristea 2 жыл бұрын

Great tip, Jonathon!

@PragmaticWorks 2 жыл бұрын

Glad it was helpful!

@AnnyLi-w3t Жыл бұрын

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

@erickung4302 4 ай бұрын

Thank you, it worked splendidly. .

@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 7 ай бұрын

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

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

@thisizzellie2531 Жыл бұрын

did you found the answer?

@AntoniaMartinezPhd 7 ай бұрын

@itanandrevalenciamendez2370 - Did you ever find the answer to how to do this when you have more than one multiple-choice question?

@tonymcqueen 3 ай бұрын

@@AntoniaMartinezPhddid you ever figure this out ? I need help with this also

@gabrielferreiraguimaraes2092 11 ай бұрын

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?

@brs14sa Жыл бұрын

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

@cravocanela 5 ай бұрын

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

@bennyj33 Жыл бұрын

Thank you!

@GeminiLoh Жыл бұрын

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

@londonengland2309 6 ай бұрын

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

@claudiantenegri2612 Жыл бұрын

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

@cassidykjwei1264 2 жыл бұрын

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 Жыл бұрын

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

@michaelcha6278 8 ай бұрын

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 7 ай бұрын

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

@michaelcha6278 7 ай бұрын

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

@luizhct22 7 ай бұрын

@@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 7 ай бұрын

@@luizhct22 are you using the new powerautomate interface?

@luizhct22 7 ай бұрын

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 8 ай бұрын

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 6 ай бұрын

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