Forum Discussion
Deleting Files Automatically after 3 Months
Filmanac yes this can be done with a simple flow in Power Automate as shown below.
1. Your trigger needs to be a recurrence schedule which you set to 1 day (and the timezone and time you want it to run) so that it checks the library every day:
For the first action select the SharePoint get files (properties only), select your site and the Document library. But you only want to bring back those items that were created over 3 months ago, the rest you can ignore. So in the Filter Query field add the following:
Created lt '{expression}addDays(utcNow(), -90){/expression}'(Created is the column that is being checked, lt = less than, utcNow() = today, -90 is 90 days ago).
Don't forget to put the expression inside single quotes!
It will default to bringing back items from the entire document library but you can limit it to a specific folders by clicking the folder icon on the right and selecting the folder:
Finally, add a SharePoint delete file action. It will automatically wrap itself in an apply to each (as the previous action was get items). Select Identifier from the dynamic content box. The items that were brought back by the get items will then be deleted.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
But how to delete folders?
all files as well as in sub folders are deleted but the folders are still remaining.
- Thanks for replying, Iv voted for this feature!
On a related note, my script failed this morning with the error that a subfolder did not exist, even tho it does and there are files inside that are out of date and should be deleted.
its been running ok for the past month, but i think today is when files now out of date.
Any idea why its showing not existing ?
