Unanswered

Need to automate deleting files in sharepoint older than 7 days

(0) Share

Report

Posted on by christophermc

Hi there,

I am currently setting up flows for my work. I have files going in on a daily basis and once the file is a few days old it is no longer relevant so planning to upkeep 7 days worth.

I have searched for solutions, followed guides, and I can't seem to get it to work. I have been doing testing on it so there is files that are 3 and 4 days old, so setting the parameters to delete files older than 2 days.

The Test runs however nothing gets deleted.

any help would be greatly appreciated.

Categories:

Building flows

I have the same question (0)

All responses (27)

Answers (0)

annetoal 1,934 Moderator on at

Like (1)

Report
Instead of an ODATA filter, try this instead:
Use the Filter action to filter.
The Created label was picked from the dynamic data picker.
The time I used was utcNow(). You may want to customize that to your own needs.
addDays(utcNow(),-7)
If this helped, please mark it as a Solution and give it a thumbs up.
Anne

Was this reply helpful? Yes No
christophermc 38 on at

Like (0)

Report

Hi Anne,
Where would I place this? would it be between Get files and Apply to each or before Get Files?
thanks

Was this reply helpful? Yes No
annetoal 1,934 Moderator on at

Like (0)

Report

Has to be after Get files (properties only).

Was this reply helpful? Yes No
christophermc 38 on at

Like (0)

Report

unfortunately that doesn't seem to of made a difference.

Was this reply helpful? Yes No
annetoal 1,934 Moderator on at

Like (0)

Report

Show your Flow outputs from a run. Does the filter produce the array of files you want to delete?

Was this reply helpful? Yes No
trice602 15,404 Super User 2025 Season 2 on at

Like (1)

Report

Hi @christophermc ,

Please try filter array - the results look good in my test; modify as needed. Always glad to help! Tom

Was this reply helpful? Yes No
christophermc 38 on at

Like (0)

Report

this is the result of running it

Was this reply helpful? Yes No
annetoal 1,934 Moderator on at

Like (0)

Report

Looks like the problem is you don't have any files in your library that are more than 7 days old. You may want to adjust your addDays parameter to something else, or put some older files in your test group.

Was this reply helpful? Yes No
christophermc 38 on at

Like (0)

Report

That is why currently it is set to -3 instead of -7 so I can make sure it works. then once it all works I will manually delete the files and let it do its thing daily

Was this reply helpful? Yes No
annetoal 1,934 Moderator on at

Like (0)

Report

What are the Created dates in the Get files (properties only) outputs for the files you're testing?

Was this reply helpful? Yes No