Forum Discussion

zstjmb's avatar
zstjmb
Copper 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
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

  • Damien_Rosario's avatar
    Damien_Rosario
    Silver Contributor
    Dec 06, 2019

    Hi TheGaryB 

     

    The form responses shouldn't repeat as they would be captured at the point of submission only.

     

    The flow should never recapture the same Form response ID twice so your SharePoint lists should be clear of duplicates.

     

    Oh and the 'formerly Microsoft Flow' thing is something I do to remind myself to call it Power Automate as well! Still wrapping my head around breaking that old habit.

     

    Best wishes and enjoy your weekend ahead

    Damien

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

    Damien_Rosario 

    Thanks for the quick response!  My only worry was that somehow the same response might be copied again, but I added the Form's ID to the SharePoint list and set it to require unique values. That's close enough for now. 🙂

    And yes, I need to stop calling it Flow. 🙂

     

    g

  • Damien_Rosario's avatar
    Damien_Rosario
    Silver Contributor
    Dec 05, 2019

    Hi TheGaryB 

     

    It's not currently an option to delete data from Forms via Power Automate (formerly Flow) at present.

     

    It could possibly be a future addition though I suspect it will need to be advocated on UserVoice for it to get some traction.

     

    Your only option is to periodically clear all results from the Form manually in the Form > Responses tab > ... > Delete all responses.

     

    Cheers

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



Resources