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
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, something
Any ideas what could be the issue?
- RobElliottFeb 05, 2020Silver Contributor
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 - Damien_RosarioFeb 06, 2020Silver Contributor
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