Aug 25 2021 05:04 AM
Hello,
Is it possible to create a flow that will automatically delete files in specific SPO folders after 3 months? I have tried using a flow, but I am not experienced with them and am having trouble.
Thanks.
Aug 25 2021 06:36 AM
Solution@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 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
Aug 26 2021 01:49 AM
Aug 26 2021 02:02 AM
Aug 26 2021 03:29 AM
@RobElliott I have attached two screenshots of the flow. I haven't included it in the screenshot, but the code I'm using for the filter query is 'addDays(utcNow(),-90).
I have removed the actual SharePoint site address and the specific folder I'm using.
Dec 07 2021 03:14 AM
@RobElliott Thanks for this This flow doesn't seem to work for me, and I'm not entirely sure why, but it seems like it is looking for anything created exactly 3 days ago (I need things deleted more than 3 days old). So I've used Created It 'addDays(utcNow(), -3)', but I keep getting this error.
Am I missing something obvious?
Dec 07 2021 03:46 AM
@Filmanac Power Automate is a good option if you need to do more actions before or after deleting the docs. If you don´t have a complex scenario you could create a retention policy in the document library. See attached images. You will need to activate the site collection feature called "Site policy" in order to use this functionality.
Dec 07 2021 07:47 AM
I know you weren't replying to my query, but about this solution, as I'm giving it a try to see if it works for my problem. I can't see how you can apply this to individual folders from within a document library. Doesn't it apply to the library as a whole?
Dec 07 2021 07:59 AM
@LCSilliman, First, create a custom folder content type for your specific purpose. Make sure that your folder is using this content type. Then, open the Information management policy settings. You will now have the option to select your custom FolderCT and apply a retention policy. This would apply to all folders using this content type, which can be very useful in some cases.
May 10 2022 09:43 PM
May 10 2022 11:22 PM
Jun 12 2022 07:19 AM
Jun 12 2022 06:05 PM
Jun 23 2023 06:36 AM - edited Jun 23 2023 06:37 AM
@Dan0365 @LCSilliman I'm also running into this error. Any advice? Were you able to get it resolved? Thank you!
Jun 26 2023 12:38 AM
@anniewendel I've had no resolution to this issue, but it was because I don't have the appropriate rights in the enterprise version my workplace is using.
Jun 26 2023 12:54 AM
Aug 25 2021 06:36 AM
Solution@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 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