Forum Discussion

zstjmb's avatar
zstjmb
Brass Contributor
Oct 29, 2018

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 ...
microsoft forms
thanhtran91's avatar
thanhtran91
Copper Contributor

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

Sai Gutta's avatar
Sai Gutta
Iron Contributor
Apr 15, 2019

thanhtran91 In the Form Id Dropdown select Enter Custom Value. 

 

Now go back to you form and select SHARE on the top right corner, in the url presented at the end you should see a paramter ID, enter the ID parameter value in the custom value 

  • thanhtran91's avatar
    thanhtran91
    Copper Contributor
    Apr 16, 2019

    HiSai Gutta 

     

    Thank you for your quick response.

    Let me explain the background.

    I created a priviate MS teams for my team, and created a group MS forms to collect data from each member. I dont want to store data in Excel file because data is going big day by day and Excel is not user friendly app, so I wanted data to store in Sharepoint List using Flow.

    come back to my issue, Could not select Form Id at "When a new response is submitted" and "Get reponse details" even Enter Custom Value.

    And the response ID should be interger ID? This is my response ID:

    https://forms.office.com/Pages/ResponsePage.aspx?id=fs9ZuIr_u0C9D9pW5twOuCpP96jnYShAuCu94l9vubZURjNUNFdTS0VUODExRlE1MVFUWE5ORkwyVyQlQCN0PWcu

     

    Thank you,

    Thanh

    • Damien_Rosario's avatar
      Damien_Rosario
      Silver Contributor
      Apr 17, 2019

      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 wishes

      Damien

      • TheGaryB's avatar
        TheGaryB
        Copper Contributor
        Dec 05, 2019

        Damien_Rosario 

        Just what I needed, and Perfect timing.

        Do need to figure out one more step:

        As with the Move from one SharePoint list to another, (which, btw can be turned into Add into another list when one is created, by just dropping the delete step)  I want to remove the item from Forms so the data is only in the SharePoint list.  

        Pointers appreciated. 🙂



    • Sai Gutta's avatar
      Sai Gutta
      Iron Contributor
      Apr 18, 2019

      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

       

Resources