Delete files older than 3 years

(1) Share

Report

Posted on by Godmaster

Hello,

I would like to create a flow to delete files older than 3 years ( date of creation ) in a sharepoint librairy.

I watched some exemples in this site but advanced condition are not working anymore ( option not visible )

Need help thanks you !

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (1)

efialttes 14,756 on at

Like (0)

Report

Re: Delete files older than 3 years

@Godmaster

Are you using a "Condition" action block to evaluate if a File is olderenough to be deleted?

If so, it seems "edit in advanced mode" option is not available anymore since some improvements in the UI were implemented for this action block.

Please also note this "edit in advanced mode" is still available on "Filter array" action block. So if you prefer yo can implement a filter based approach instead

Step#1 Manual trigger or REcurrence trigger

Step#2 Sharepoint "Get items" from target SP Library

Step#3 "Filter array" action block to skip the files not old enough

Step#3 "Apply to each" using the output of "Filter array" as its input

Step#3.1 Delete file, using the ID from current item

So in step 3, flow will iterate all through the files old enough to be deleted

Hope this helps

Was this reply helpful? Yes No
Godmaster 38 on at

Like (0)

Report

Re: Delete files older than 3 years

I dont understand how to write step 3 and 4.

Was this reply helpful? Yes No
Godmaster 38 on at

Like (0)

Report

Re: Delete files older than 3 years

how can we write this since the advanced condition is not available anymore ?

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (4)

Report
Re: Delete files older than 3 years

Hi @Godmaster ,

You could configure the following Expression in Condition.

At present, Flow can't get the number of days in the past three years. So I use a year with 365 days to calculate.

Use formatDateTime() function to format Created into ‘yyyy-MM-dd’ and then calculate the date three years ago.

If the former is less than the latter, then the current file is deleted.

Expression reference:

formatDateTime(item()['Created'],'yyyy-MM-dd')

addDays(utcNow(),-1095,'yyyy-MM-dd')

Image reference:

Hope it helps.

Best Regards,

Was this reply helpful? Yes No
Godmaster 38 on at

Like (1)

Report

Re: Delete files older than 3 years

Thanks you so much v-bacao-msft !
After test on many documents older than 1095 days and recent document on the same librairy, the flow works perfectly !

Was this reply helpful? Yes No
Godmaster 38 on at

Like (0)

Report

Re: Delete files older than 3 years

I spoke too fast, there is a little problem lol
I watch in the history of the flow and i see that there is a limit of 100 entries for the condition
How can i can cross this limit of 100 items ?

Was this reply helpful? Yes No
Godmaster 38 on at

Like (3)

Report

Re: Delete files older than 3 years

I have found the solution to cross more than 100 entries.
In the"get property" i put a value of 5000 elements.

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report

Re: Delete files older than 3 years

@Godmaster

Good news! Please do not forget to Accept the solution from @v-bacao-msft !

Was this reply helpful? Yes No
Godmaster 38 on at

Like (0)

Report

Re: Delete files older than 3 years

Do you know how to go beyond 5000 items ? My librairy has more than 10000 items
Its really disappointing...

Was this reply helpful? Yes No
MichaelVreuls on at

Like (0)

Report

Re: Delete files older than 3 years

Thanks
It works as long as "Get Files (Properties only)" is preceded by "List Files in Folder".
(took me a while to find that out 😉

Was this reply helpful? Yes No