Unanswered

Delete Files in SharePoint Folder based on LastModified - X Days

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I am building a flow to delete files on a SharePoint folder based on the date Last Modified - X Days.

I used the following approach as a guideline: https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Delete-files-older-than-X-days-from-OneDrive-using-Flow/ba-p/368561

However it seems I am getting a wrong output in the LastModified field as per screenshots: "0001-01-01T00:00:00"

Am I using the correct field for this purpose?

Can anyone assist?

Thank you!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

kierian Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Solved: Delete files older than 3 years - Power Platform Community (microsoft.com)

try this

hope this help.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

So I replicated that flow, but it doesn't seem to be doing anything:

Were you able to replicate it?
Any ideas?

Was this reply helpful? Yes No
v-LilyW-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous
Has your problem been solved?
If you want to delete a file based on it's modified date , you can refer to the following screenshots.
I have a folder like this:
Flow in details:
Expression: formatDateTime(items('Apply_to_each')?['Modified'],'yyyy-MM-dd')
Expression: addDays(utcNow(),-7,'yyyy-MM-dd')

After flow runs, the files will be deleted.
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

It doesn't seem to work for me. I'm getting that the flow is running successfully, but nothing is getting deleted; I still have files from January...

Not sure what is going on...

formatDateTime(items('Apply_to_each')?['Modified'],'yyyy-MM-dd')
addDays(utcNow(),-7,'yyyy-MM-dd')

Was this reply helpful? Yes No