Forum Discussion
MS Forms data stored in SharePoint List
It would be really great if the questions / data collected could be promoted into a SharePoint List (like it used to be with InfoPath) because it is much easier to use than PowerApps. Users find it ...
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
Thanks for a helpful post with screenshots.
I have an issues, there is no "List of response notifications..." to select under "Including dynamic content". This happens even when I select a form (another form, not the group-form I'm going to actually use) from the drop down list, so its not the ID that is wrong. Also quite sure I got the copy&paste part right. 😉
If I add other step, somethingAny ideas what could be the issue?
Hi ToFfern
I'm glad the visuals have been helpful.
I concur with RobElliott.
Make sure to add Get response details after When a new response is submitted. Don't put it in the Apply to each (to avoid confusion, delete Apply to each).
Best wishes with your work!
Cheers
Damien
ToFfern after the When a new response is submitted trigger you need to add a Get response details action. In that you will have the "List of response notifications Response Id" in the dynamic content to select.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
- But does it transfer a multiple choice option from the form to SharePoint?
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.
Damien_Rosario This looks great, thanks. Do you know if there is a way to use a Group Form as the source though? Group Forms don't appear for me in the Form Id drop-down, and errors when I try and type the name manually.
Hi Deleted
You can use group forms by copying the form URL and pasting it into the Get response details action in Flow (this is what I do for my Forms + Flows).
I also have access to the form as I am a part of the group so hopefully you are too!
Let me know how you go. If it doesn't work we may need an offline discussion just to see what's happening.
Cheers
Damien
HiDamien_Rosario ,
Can you show me how to paste the form URL in Get Response Details?
I have tried but could not.
Thank you,
Thanh
