Auto-delete items based on Modified date (standard format)

(0) Share

Report

Posted on by jaanihsm

300

Hi! I am trying to perform auto-delete items based on the Modified column (standard format) in SharePoint.

Items that are older than 4 weeks (28 days) should be deleted.

Am I missing something with my filter query? It could be some simple tweak I overlooked. Appreciate your help!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Pstork1 69,024 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Since the internal Dates will be stored in UTC format it would be better to use ISO 8601 utc format for the date when you are querying. I would just do AddDays(UtcNow(), -28). You may also want to test the Status eq 'Completed' piece separately. Status is probably a choice column which is hard to query on.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
jaanihsm 300 on at

Like (0)

Report
Copy link

Link copied!

Hi @Pstork1! Appreciate the response!

Unfortunately, I will need to include the filter for Status = Completed. I tried using AddDays(UtcNow(), -28) but it did not return any results from the query. What did you mean by test separately? Sorry, a bit of a newbie...

I have a similar code for Status = Pending and EndDate eq AddDays(UtcNow(), -21, 'MM/dd/yyyy') and is working well (EndDate column was manually created vs Modified column from SharePoint default).

So could be that my Modified date/time format in the query is wrong? Do you have another recommendation? Greatly appreciate it!

Was this reply helpful? Yes No
jaanihsm 300 on at

Like (0)

Report
Copy link

Link copied!

My bad @Pstork1! It is working! I missed something on the code. Thank you so much for your time and support!

Was this reply helpful? Yes No