Delete files older than 3 years

[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 !

[efialttes]

@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

[Godmaster]

I dont understand how to write step 3 and 4.

[Godmaster]

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

[v-bacao-msft · Accepted solution]

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,

[Godmaster]

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 !

[Godmaster]

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 ?

[Godmaster]

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

[efialttes]

@Godmaster 

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

[Godmaster]

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

[MichaelVreuls]

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 😉