Unanswered

Empty/delete OneDrive (business) recycle bin automatically?

(0) Share

Report

Posted on by AEES

Trying to find a way to empty the recycle been more frequently then the 30 days. Been looking in the below thread but cant really figure out how to get it to completely empty it. All steps is not fully visible and im not an engineer myself.

There is a delete POST in the bottom of the thread and cant figure out how to use that.

Any guidance?

https://powerusers.microsoft.com/t5/Building-Flows/Use-Power-Automate-to-permanently-delete-files-from-a-folder-or/m-p/1825071/highlight/true#M201308

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (0)

Rhiassuring 8,692 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi there,

Which part are you having problems with in that post? Can you show what you've configured so far, and where you are running into issues?

🐟 I imagine you'll trigger on a Schedule ... every 5 days? 15 days? Whatever you need.
🐟 You'll initialize your OneDrive URL in a variable.
🐟 Then, you'll want to "Get Items" first from your Recycle Bin. That'll help you identify what needs to be deleted (if anything).
🐟 Next, use the HTTP action, for the "GET". Where he has the variable, instead, you'll just point at your Dynamic Content from "Get Items" for the FileName w/ Extension. It'll turn into an Apply To Each, which means it'll loop through each item from the "Get Items".
🐟 Then you'll do the HTTP with the "DELETE" - but where "body()" is, you'll point it at the output from the "GET" (which should be the ID.)

The flow will loop through until each item is gone.

Was this reply helpful? Yes No
AEES 13 on at

Like (0)

Report
Copy link

Link copied!

Thanks, i get the concept but fail on the details. What exactly to input where?

Was this reply helpful? Yes No
Rhiassuring 8,692 Moderator on at

Like (1)

Report
Copy link

Link copied!

I built it out and found a a cleaner way to do it:

File attached.

EmptyMyOneDriveRe...

Was this reply helpful? Yes No
AEES 13 on at

Like (0)

Report
Copy link

Link copied!

Cool, thanks! Will try and test it during week 🙂

Was this reply helpful? Yes No
AEES 13 on at

Like (1)

Report
Copy link

Link copied!

Tested it and its working, thanks for great support @Rhiassuring!

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/code to copy-paste? I want to delete all items, empty recycle bin without exception. I don't know how to use your attached file. Thank you very much!

Was this reply helpful? Yes No
nicktalsma 38 on at

Like (1)

Report
Copy link

Link copied!

You download and import the zip file.

But here is the JSON:

{
    "type": "object",
    "properties": {
        "d": {
            "type": "object",
            "properties": {
                "results": {
                    "type": "array",
                    "items": {
                        "type": "object",
                        "properties": {
                            "__metadata": {
                                "type": "object",
                                "properties": {
                                    "id": {
                                        "type": "string"
                                    },
                                    "uri": {
                                        "type": "string"
                                    },
                                    "type": {
                                        "type": "string"
                                    }
                                }
                            },
                            "Author": {
                                "type": "object",
                                "properties": {
                                    "__deferred": {
                                        "type": "object",
                                        "properties": {
                                            "uri": {
                                                "type": "string"
                                            }
                                        }
                                    }
                                }
                            },
                            "DeletedBy": {
                                "type": "object",
                                "properties": {
                                    "__deferred": {
                                        "type": "object",
                                        "properties": {
                                            "uri": {
                                                "type": "string"
                                            }
                                        }
                                    }
                                }
                            },
                            "AuthorEmail": {
                                "type": "string"
                            },
                            "AuthorName": {
                                "type": "string"
                            },
                            "DeletedByEmail": {
                                "type": "string"
                            },
                            "DeletedByName": {
                                "type": "string"
                            },
                            "DeletedDate": {
                                "type": "string"
                            },
                            "DeletedDateLocalFormatted": {
                                "type": "string"
                            },
                            "DirName": {
                                "type": "string"
                            },
                            "DirNamePath": {
                                "type": "object",
                                "properties": {
                                    "__metadata": {
                                        "type": "object",
                                        "properties": {
                                            "type": {
                                                "type": "string"
                                            }
                                        }
                                    },
                                    "DecodedUrl": {
                                        "type": "string"
                                    }
                                }
                            },
                            "Id": {
                                "type": "string"
                            },
                            "ItemState": {
                                "type": "integer"
                            },
                            "ItemType": {
                                "type": "integer"
                            },
                            "LeafName": {
                                "type": "string"
                            },
                            "LeafNamePath": {
                                "type": "object",
                                "properties": {
                                    "__metadata": {
                                        "type": "object",
                                        "properties": {
                                            "type": {
                                                "type": "string"
                                            }
                                        }
                                    },
                                    "DecodedUrl": {
                                        "type": "string"
                                    }
                                }
                            },
                            "Size": {
                                "type": "string"
                            },
                            "Title": {
                                "type": "string"
                            }
                        },
                        "required": [
                            "__metadata",
                            "Author",
                            "DeletedBy",
                            "AuthorEmail",
                            "AuthorName",
                            "DeletedByEmail",
                            "DeletedByName",
                            "DeletedDate",
                            "DeletedDateLocalFormatted",
                            "DirName",
                            "DirNamePath",
                            "Id",
                            "ItemState",
                            "ItemType",
                            "LeafName",
                            "LeafNamePath",
                            "Size",
                            "Title"
                        ]
                    }
                }
            }
        }
    }
}

Was this reply helpful? Yes No
fcfgts 2 on at

Like (0)

Report
Copy link

Link copied!

yeah thanks it worked at first, but at the next run I got this error:

Unable to process template language expressions for action 'Apply_to_each' at line '0' and column '0': 'The number of foreach items limit exceeded for action 'Apply_to_each': maximum '5000' and actual '11612'.'.

So there's 10,000+ trashed files in my onedrive account and I got that 5000 limitation, how to make the script delete the first 5000 and then the next 5000 in the next schedule? @Rhiassuring thanks

Was this reply helpful? Yes No
Paul_ZA_NZ 2 on at

Like (0)

Report
Copy link

Link copied!

Hi sorry to bump an old topic, but this the closest I could find to a similar situation I am trying to achieve.

I have a 365 for developers account, in which several onedrive accounts automatically add & delete data. - My only issue is that the Recycle bin isn't able to be emptied, and I have to log in, and do it manually - if I don't, the accounts eventually get full and it is a little bit of a hindrance.

This is the first time I am attempting to use PowerAutomate - I eventually will find my way, I just need some firm guidance. I was thinking of running a command to automatically empty the recycle bin once per day - this should sort all the issues I have been having.

I have tried using Rhea's script, and edited the relevant info to reflect my own Onedrive account, using Wordpad. I also changed the frequency from 3 days, to one day, I am then able to import file into power automate, but I cannot add a connection to OneDrive, and once I exist the PowerAutomate page, it doesn't show up again.

Will wait for a response.

Thanks so much in advance.

Was this reply helpful? Yes No
Keenum 2 on at

Like (0)

Report
Copy link

Link copied!

I had to go into my Connections and make sure my Sharepoint connection was fixed before I was able to run this successfully. Make sure all of your connections look good.

Was this reply helpful? Yes No