Forum Discussion

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

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

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

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