Delete SharePoint files that are older than 3 months

Like (0) Share

Report

Posted on 22 Jan 2024 11:17:07 by Vstar19

376

Hello.

I have a sharepoint library with around 50+ folders (bad practice i know, but i inherited this setup)

I need to create a solution that delete all files that are older than 3 months. Personally, i thought SharePoint Compliance Center had an Out of the box feature to manage this, but they dont want to get involved).

I have written a Power Automate Flow that get me all the files that are less than 90 days

addDays(utcNow(), -90)

This works fine.

I then created an apply to each then a Delete Action as below

However, its asking me to Choose a file to delete. How i can dynamically get it to delete the ID of the file(s) i got in the previous step?

Bearing in mind, this delete file action needs to go through each folder, sub folder and delete the files?

All responses (3)

Answers (1)

sudosaurus 1,597 Super User 2024 Season 1 on 21 Jun 2024 at 13:50:56

Like (0)

Report

Re: Delete SharePoint files that are older than 3 months

@victorcp how would you extend this to also delete sub-folders?
Vstar19 376 on 22 Jan 2024 at 12:53:39

Like (1)

Report

Re: Delete SharePoint files that are older than 3 months

Thank you Victor. I cant beleive i missed that. I was using the ID column. I didnt see the identifier.

Thanks
Verified answer

victorcp 2,347 Moderator on 22 Jan 2024 at 12:17:01

Like (1)

Report

Re: Delete SharePoint files that are older than 3 months

Hi,

There is a property called Identifier, use it to delete the file

I hope it helps 🙂