Answered

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

(0) Share

Report

Posted on by 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?

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

Pstork1 68,739 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Purman2 9 on at

Like (0)

Report

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

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (3)

Report
@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

Was this reply helpful? Yes No
Purman 42 on at

Like (0)

Report

@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?

Was this reply helpful? Yes No
Verified answer

ScottShearer 25,270 Most Valuable Professional on at

Like (2)

Report

@Purman

My mistake.....

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

Was this reply helpful? Yes No
Purman2 9 on at

Like (0)

Report

@ScottShearer

Fantastic! Thank you, it's working!

Was this reply helpful? Yes No