It would be great to have an action that when triggered deletes a response or possibly all responses. Due to GDPR having data saved both in Forms and in SharePoint (if the form data is copied into SharePoint) is not ideal and there is currently no way to automate the deletion of the responses from within Flow. I know all of the responses within a form can be deleted from within the Forms action menu so having something similiar as an action within Flow would be great.
Solved! Go to Solution.
Are you working with SharePoint forms? Do you want to delete the items in the forms using Microsoft Flow?
If yes, I am afraid that currently there is no available action can be used. Please consider submitting a request on Flow Ideas Forum:
If you have already posted your idea to the Flow Community Ideas Forum then you need to post the URL to your idea’s thread as a reply to this thread and then "Accept as Solution" on that reply so other users may vote for your Flow Idea and identify the information easily.
Flow Community Manager
Use Send HTTP Request to SharePoint Connector in Power Automate.
You need your TenantID, UserID and FormID(s).
See Azure Active Director or Powershell to get Tenant and UserIDs. The form URL shows the ID.
My flow deletes all responses from many forms each night.
I created a simple array FormID with Name & ID of all the forms. You could easily use a MS List or excel or whatever source you want to maintain for Form Name/IDs.
Loop the array and delete all responses.
You Parse the JSON (your array) inside the loop to be able to use the ID string variable in the HTTP connector. Makes it easy to read and understand the flow, I just prefer to an expression.
Holy mother of all it does work your way !
the difference is i change
the Users/[Uservariable] for Groups/[GroupVariable]
using the sharepoint http request allows you to authenticate
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.