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 difficult to work with the phone layout and if they can remember to change to the tablet layout, getting the pictures they want, and branching questions, etc., are much harder for users to get their forms into PowerApps. I know you can export the data into Excel, but it would just be easier if users had the option to use MS FORMS or POWERAPPS for more complicated forms.
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
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
- 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
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?
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
- Did you know you can also use Flow to write every response into a SharePoint list when it is added. There is a Forms trigger for this but does require configuring for each form you want to do this.
- How do you handle Forms Branching in SharePoint lists? In a forms branch - depending on the answer the following question can be different - but the numerical number will be the same. How do I get around this error when creating a workflow from Forms to SharePoint?
DataLady you just make sure that you have a column in your SharePoint list for every question in the form. Due to branching not all of them will get populated by the crearte item action in the flow, but that's the way you do it.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
