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)

Sort by

Verified answer

Expiscornovus 33,876 Most Valuable Professional on at

Like
a
(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
a
(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
a
(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
a
(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,081 on at

Like
a
(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
a
(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
a
(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
a
(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
a
(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,876 Most Valuable Professional on at

Like
a
(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