Forum Discussion
MS Forms data stored in SharePoint List
Hi zstjmb
Using Flow as Alan Marshall has suggested is the way to go.
Here's one I have mocked up which shows you how to do it in Microsoft Flow.
Use the headings in the image to find the same parts to add in Flow.
A pop up box appears on the side when looking for attributes to add in. If you don't see any in that pop up box, there should be hyperlinks in it that say "See more". Click onto them for the options to appear.
Make sure to create a SharePoint list with the appropriate columns to house the data, and then match the data to those columns (bottom of the picture).
Let us know how you go with this? Hopefully it's the solution to your query!
Best wishes and good luck!
Cheers
Damien
pyvonner yes, the answers to a multiple choice question in the form will end up in SharePoint like this:
If you want to remove the brackets and the quotation marks this could be done in Power Automate before it creates the item in the SharePoint list.
Rob
Los GallardosMicrosoft Power Automate Community Super User
RobElliott how does one remove the brackets and the quotation marks in Power Automate? I have matched the choice options in the MS Form with the choice options in the SP list. I want to make sure that I can filter and sort by the same choice options whether the entry came from the MS Form or was entered directly in the sharepoint list.
