How To Input Multiple Answers from a Microsoft Form into a SharePoint List Column | 2022 Tutorial

Hi Everyone,

In this video, I demonstrate how to input multiple answers from a Microsoft Form into a SharePoint List Column correctly. Without the proper Power Automate Flow, it will be sent as an Array instead of the correct JSON.

Feel free to Like, Comment, Subscribe if you enjoyed the video.

✨Support My Channel✨

If you enjoy my content and would like to support my work, consider buying me a coffee! Your support helps me create more videos and keep the channel going. ☕💖

🪙BTC🪙: 3LpmcBaJB537RweJu2tRjSqT6NhnQDDBWy
⛓️ETH⛓️: 0xbAEb6d6Df7CE5cfC55797B3133342e165B78A444
🐕DOGE🐕: DNKNUduorzBWMJ4XTSRqUSsUKk3ZiehHin

#PowerAutomate #MicrosoftForm #SharePoint

[droppisalt]

FINALLY! Been searching forever for this simple solution. Everyone else just removes the [] and "" but this is the actual solution I was looking for. Thank you!!

[Voltzz]

Thank you sir! Great explanation for a common issue and you did it within a few minutes. BRAVO!

[annatatistcheff]

I have been struggling for two whole days to get this functionality to work. Thank you so much!!!

[KaiRi]

This video is super helpful specially for me that uses a lot of questions with multiple answers. I was able to solve my problem using this video. :) Please keep them coming.

[tigertext]

I've been at this for 2 days but when I get to minute 3:45, for adding the Select Data, I can add the JSON formula but the dynamic content is not available. So I don't have the outputs value to put into the formula. This is all new to me so I'm guessing I'm probably making a mistake somewhere. Not sure if you have any advice?

[sofianmaretno]

thank you for this michael. can you share the sintaks of json setting for choice button, please

[capri]

thank you for this but can we have new record for each multiple option is selected and export in excel?

[cravocanela]

Hi, Thank you for the video! Does it work in a document library or is only for lists? I really need this for my doc library!

[aguilarrob]

Hi Michael, I am dealing with the multiple select option in forms and having some issues when the user selection is not in the same order the listing is created, so when I am validating the options selected by the user, the order in the array is passed to power automate as it was clicked, (user could click the option 4, first instead of the 1), how can I send the array in the same order the options are in the listing instead of the order they were clicked in forms. thanks for your help.

[matthewlogan]

Thank you for this Michael. Do you have an example or suggestion on how to do this with a Microsoft Form that has more than one multiple answer question? I can get this working in the flow when it is a single multi-choice question, but can't seem to replicate it when I have more than one.

[rawiaadel]

👏👏👏thanks for your great job
my question is in Sharepoint list is one column that has multiple answer, if we link this list with Power BI to show what this column has and even i can have a report from this column, do you think that will work🤷‍♀or is there any other way to get each answer in a sperate column?

[KatieBryant-wv]

Works great... however, in my form its an option field, when left blank I get an error - how can I resolve this?

[natasha-holisticneuroacade]

Thanks for this, really clear and helpful.

Could you help with another problem please?
I'd like to send two different emails when a sharepoint list is modified, however I can't quite work out the correct process. Specifically:
1. When the status column is changed to 'approve', automate sends an 'approved' email
2. When the same status column is changed to 'rejected' automate sends a 'rejected' email.
3. When the status column is not changed, nothing happens!

There seems to be lots of info about sending an email when the column status has changed, but not when those changes have different conditions (approved or rejected).

Any help would be mega! Thanks.

[carlosm]

Hello excellent explanation, but i follow all the steps but when i insert a new value it only appears with this [name of the option]. What i'm doing wrong. Thanks

[yreniers]

Hi Michael, this is a great solution, but it seams the expression feature is no longer available in the "select data operation". If you now follow the instructions, the interface is difference... Does anyone know how to solve it?

[crismarcruz]

Awesome! finally found a way to do it. Just a question though, when I add additional step to create a task, the value it creates shows like this


Do you have a way to convert it to a plain text?