Reply
Level: Power Up
Posts: 2
Registered: ‎11-16-2017
Accepted Solution

Automatically delete files in Document Library after X days

Hi,

 

How can i create a flow so that everytime a file is created/added in a SharePoint Document Library, that the particular file than will be deleted in lets say in "7 days".

 

The point is that the no files older than 7 days will stay in the Document Library.

 

Thanks...

 

 

 


Accepted Solutions
Level 8
Posts: 117
Registered: ‎04-21-2017

Re: Automatically delete files in Document Library after X days

[ Edited ]

Hi @adamk, first of all thanks for post.

 

i think the best way to do this is using a schedule to get all documents, look at example below:

flow1.png

 

Detaileds Steps:

 

1 - Use an schedule trigger with 1 day interval

2 - Use the action - SharePoint - Get file properties only

      Put your Site and Document Libary name

3- Use an foreach and put values as result

4- Use an advanced condiction to verify if the actual date is greater than document created date + 7

      This is the condiction code, in red are the days to add, change if you need:

      

@greater(utcNow('yyyyMMdd'), formatDateTime(adddays(item()?['Created'],7),'yyyyMMdd'))

 

5- If the condiction is yes, the document is older than 7 days

6- Use the action - SharePoint - Delete Item

 

Hope this helps.

 

Best Regards,

 

Gustavo Moraes

View solution in original post


All Replies
Level 8
Posts: 117
Registered: ‎04-21-2017

Re: Automatically delete files in Document Library after X days

[ Edited ]

Hi @adamk, first of all thanks for post.

 

i think the best way to do this is using a schedule to get all documents, look at example below:

flow1.png

 

Detaileds Steps:

 

1 - Use an schedule trigger with 1 day interval

2 - Use the action - SharePoint - Get file properties only

      Put your Site and Document Libary name

3- Use an foreach and put values as result

4- Use an advanced condiction to verify if the actual date is greater than document created date + 7

      This is the condiction code, in red are the days to add, change if you need:

      

@greater(utcNow('yyyyMMdd'), formatDateTime(adddays(item()?['Created'],7),'yyyyMMdd'))

 

5- If the condiction is yes, the document is older than 7 days

6- Use the action - SharePoint - Delete Item

 

Hope this helps.

 

Best Regards,

 

Gustavo Moraes

Level: Power Up
Posts: 2
Registered: ‎11-16-2017

Re: Automatically delete files in Document Library after X days

Hi Gustavo,

 

Thank you very much for your reply. I will try this out later

What if you want to change from 7 days to lets say 60 minutes?

 

Thanks again

Highlighted
Level 8
Posts: 117
Registered: ‎04-21-2017

Re: Automatically delete files in Document Library after X days

Simple change adddays to addminutes, you can use other functions, to see docs look here inside Date Functions

Community Support Team
Posts: 481
Registered: ‎09-21-2017

Re: Automatically delete files in Document Library after X days

Hi @adamk,

 

I agree with @gamoraes’s thought, I have made a test on my side and the flow works well.15.JPG

The flow works successfully as below:16.JPG

If you have any further questions, please feel free to reply me here.

 

Bets regards,

Kris

Level: Power Up
Posts: 1
Registered: a week ago

Re: Automatically delete files in Document Library after X days

For the flow when you get to the Action for "SharePoint - Delete Items " It is asking me for the list and for the id. Am I doing something wrong? I am wanting to auto delete all files older than 21 days that were added to the Documents folder.