Answered

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 (3)

All responses (11)

Answers (1)

Verified answer

Expiscornovus 33,830 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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
Copy link

Link copied!
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
Copy link

Link copied!

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,079 on at

Like (0)

Report
Copy link

Link copied!

Show your flow. Do you see any errors?

Was this reply helpful? Yes No
pcamida 9 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!
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,830 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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