Unanswered

Use Power Automate to permanently delete files from a folder or recycle bin - OneDrive Business

(0) Share

Report

Posted on by stefanofondaz

I am trying to delete a file from the trash using an HTTP request but I get the following error "{" odata.error ": {" code ":" - 1, Microsoft.SharePoint.Client.InvalidClientQueryException "," message ": {" lang ":" en-US "," value ":" The type SP.RecycleBinItemCollection does not support HTTP DELETE method. "}}}
clientRequestId: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx":

is there any other solution to empty the recycle bin or permanently delete a file without going through the first and second level recycle bin?

Categories:

Building flows

I have the same question (1)

All responses (11)

Answers (1)

Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (2)

Report
Hi @stefanofondaz,

As far as I am aware you cannot use a $filter in that method. You would have to retrieve the id of the item first and use that in a DELETE request.

https://learn.microsoft.com/en-us/previous-versions/office/sharepoint-visio/jj245382(v=office.15)

Below is an example

GET

_api/web/RecycleBin?$filter=LeafName eq '@{variables('FileNamewithExtension')}'&$select=Id

DELETE

_api/web/RecycleBin('@{body('Send_an_HTTP_request_to_SharePoint')['value'][0]['Id']}')

1 people found this reply helpful.

Was this reply helpful? Yes No
stefanofondaz 10 on at

Like (1)

Report

it works!!!!! thank u so much 😍

1 people found this reply helpful.

Was this reply helpful? Yes No
VASYL_MELNYK 8 on at

Like (4)

Report
Hi.

https://learn.microsoft.com/en-us/previous-versions/office/sharepoint-visio/jj246426(v=office.15)

POST http://<sitecollection>/<site>/_api/web/RecycleBin/deleteAll()
use "Send an HTTP request to SharePoint" for POST

Was this reply helpful? Yes No
AEES 13 on at

Like (1)

Report

Hi,
Could you share the entire PA flow you used? Trying to empty recycle bin like very 5-10 days but cant get it working properly after some test.

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

Show your flow. Do you see any errors?

Was this reply helpful? Yes No
pcamida 9 on at

Like (0)

Report

Thanks for the solution! Can someone share the whole flow to copy-paste? I want to delete all items, empty recycle bin without exception. Thank you very much!

Was this reply helpful? Yes No
pcamida 9 on at

Like (0)

Report

Thank you very much!! It's very simple but it's working. Now, I can empty automatically my recycle bin every day.

Was this reply helpful? Yes No
pcamida 9 on at

Like (0)

Report

Any solution for users No Business (no Sharepoint) to empty automatically the recycle bin?

Was this reply helpful? Yes No
ChrisSullivan 101 on at

Like (0)

Report
Hi there.

This is not working for me. I am trying to delete a list item from the recycle bin after it is delete.

I am using
"When an Item is Deleted" trigger and the dynamic content "FileNameWithExtention" for the LeafName.
_api/web/RecycleBin?$filter=LeafName eq'Test delete item from recycle bin if deleted before moving'&$select=Id
It is not pulling the ID from the Item....?

What might I be doing wrong?

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
Hi @ChrisSullivan,

In the example I shared earlier the query was looking for a file, not a list item. That filter was using the LeafName property.

In your case it is a Title of list item you are using in your filter. In that case try and use the Title property in the filter instead.

_api/web/RecycleBin?$filter=Title eq '@{triggerOutputs()?['body/Name']}'&$select=Id

Was this reply helpful? Yes No