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! CheersDamien

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.

thanhtran91 Hi Thanh Your response ID is everything after ID in the URL: fs9ZuIr_u0C9D9pW5twOuCpP96jnYShAuCu94l9vubZURjNUNFdTS0VUODExRlE1MVFUWE5ORkwyVyQlQCN0PWcu Click make sure you scroll and choose Enter custom value before you paste. Cheers and best wishesDamien

thanhtran91 - Flow will automatically get your response Id, if you look at the Damien_Rosario reply with screenshot you will see that response id is getting input from the dynamic field based on your previous step output. below gif should help you

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. CheersDamien

MS Forms data stored in SharePoint List

Damien_Rosario
Silver Contributor
Nov 01, 2018
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
- Deleted
  Apr 03, 2019
  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.
  - Damien_Rosario
    Silver Contributor
    Apr 03, 2019
    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
- pyvonner
  Copper Contributor
  Jan 18, 2020
  But does it transfer a multiple choice option from the form to SharePoint?
  - RobElliott
    Silver Contributor
    Jan 19, 2020
    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 Gallardos
    Microsoft Power Automate Community Super User
- ToFfern
  Copper Contributor
  Feb 05, 2020
  Damien_Rosario
  
  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?
  - RobElliott
    Silver Contributor
    Feb 05, 2020
    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
Alan Marshall
Steel Contributor
Oct 29, 2018
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.
DataLady
Copper Contributor
May 21, 2021
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?
- RobElliott
  Silver Contributor
  May 21, 2021
  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

Forum Discussion

MS Forms data stored in SharePoint List

Resources