Unanswered

forms delete all responses

(5) Share

Report

Posted on by Omar

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.

Categories:

Building flows

I have the same question (2)

All responses (81)

Answers (1)

v-yamao-msft on at

Like (1)

Report

Re: forms delete all responses

Hi @Omar,

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:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Best regards,

Mabel Mao

Was this reply helpful? Yes No
GabrielStJohn on at

Like (1)

Report

Re: forms delete all responses

Hello, @Omar!

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.

Thank You!

-Gabriel
Flow Community Manager

Was this reply helpful? Yes No
Verified answer

Omar on at

Like (2)

Report

Re: forms delete all responses

Thank you, posted as a suggestion to https://powerusers.microsoft.com/t5/Flow-Ideas/Flow-action-to-delete-all-MS-Form-responses/idi-p/131849

Was this reply helpful? Yes No
MayureshT 2 on at

Like (1)

Report

Re: forms delete all responses

Hi All,
Did anyone find how to deleted Microsoft Forms responses from excel using flow?

Was this reply helpful? Yes No
GrahamKelly on at

Like (1)

Report

Re: forms delete all responses

@MayureshT try this, Delete Excel Rows X Amount of Days Old - Power Platform Community (microsoft.com).

Was this reply helpful? Yes No
WendyOx 4 on at

Like (2)

Report

Re: forms delete all responses

This is not solved! The suggestion is just a request to Voice Ideas ... unmark as solved!

Was this reply helpful? Yes No
ewfefwef 57 on at

Like (7)

Report

Re: forms delete all responses

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.

Was this reply helpful? Yes No
Someone69 13 on at

Like (6)

Report

Re: forms delete all responses

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

Was this reply helpful? Yes No
clh 54 on at

Like (3)

Report

Re: forms delete all responses

The Send HTTP request solution has one problem, as mentioned in this Reddit post:
https://www.reddit.com/r/PowerPlatform/comments/111amhf/how_to_use_power_automate_to_delete_responses_to/

It deletes ALL current responses in the form.

If the form gets used heavily where there's a high likelihood of multiple users submitting responses close together, or happens to submit something at the exact moment the flow runs to delete all responses, then some responses will get missed.

I discovered a way to delete THIS response, i.e., the specific individual response that's being handled by the current run instance of the Automate flow so that it doesn't impact other responses. That is to add the Response Id in parentheses after the /responses part of the Uri.

To get the Response Id, use the trigger "When a new response is submitted" and Response Id is an output from that trigger.

Was this reply helpful? Yes No
apacey 17 on at

Like (4)

Report

Re: forms delete all responses

this did work until now, it returns with BadRequest 400
{
  "status": 400,
  "message": "Unexpected response from the service\r\nclientRequestId: c9e203aa-61ee-4be6-9452-8041ab1dba8b",
  "error": {
    "message": "Unexpected response from the service"
  },
  "source": "sharepointonline-cc.azconn-cc-002.p.azurewebsites.net"
}

Was this reply helpful? Yes No