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
Deleted's avatar
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's avatar
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

 

 

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

    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

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

      thanhtran91 

       

      In addition to what Sai Gutta has said, if you happen to be the owner/have shared access to the form, you can also just select it from the drop down list when you click into Form ID in Flow.

       

      Cheers and best wishes

      Damien

    • 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

  • Deleted's avatar
    Deleted
    Apr 11, 2019

    Damien_Rosario Thanks! I haven't found the time to test this yet but once I do I'll let you know how it goes.

Resources