How can I delete file from SharePoint library based on date column?

[Purman]

Hello,

I tried to create a flow which will delete the files in case of "Deletion" column's (date column) is less than today's date. I couldn't get it to work. I tried several ways, such as filtering if Deletion column is not empty but no success. 

How can I create a working flow?

[Pstork1]

The key here is what you use as a trigger. For this kind of Flow you'll need a recurrence trigger that runs on a schedule, maybe once a week.  Then when it runs get all the documents in the library and process them with a ForEach loop.  in the loop do your comparison and delete the document if the deletion date is less than today.

[Purman2]

Thank you for you answer. I use the once per week trigger. What should I modify to get it work? 

(Sorry, it's my secondary user) @Purman 

[ScottShearer]

@Purman 

If you want to delete files with a date in the "Deletion" column less than or equal to today, try something similar to the following screen shot.

Please note:

• There are single quotes around my expression in the filter query
• I am assuming that you are using a recurrence trigger
• In my expression I used le for less than or equal to.  You may want to use lt for less than instead

[Purman]

@ScottShearer 

Thank you for your answer! I had this error message:

"message": "The expression \"Deletion le 1 ' 2019-07-31'\" is not valid. 

What should I modify?

[ScottShearer · Accepted solution]

@Purman 

My mistake.....

Remove the 1 after le in the filter and you should be OK:

[Purman2]

@ScottShearer 

Fantastic! Thank you, it's working!