Unanswered

Delete 'Archived' Item after Five Years

(0) Share

Report

Posted on by Phineas

5,325 Super User 2025 Season 2

I have a recuring flow that is to delete items that are five years old with a status of 'Archived'.

Will the following Get Items Filter Query get the items I'm looking for?

(Status eq 'string('Archive')' and 'Created eq 'string(formatDateTime(utcNow(),5))'

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

I am assuming the the items are in a SharePoint list.

It depends on the internal names of the columns, but the following should

Status eq 'Archive' and Created le 'addToTime(utcNow(),-5,'Year','yyyy-MM-dd')'

Obviously, the addToTime expression must be entered in the expression window.

Was this reply helpful? Yes No
Phineas 5,325 Super User 2025 Season 2 on at

Like (0)

Report

Will the below return ONLY both status identified that are seven or more days old?

Get Items Filter Query -
(Status eq 'string('Minutes Approved') or (Status eq 'Minutes Pending') and (Modified le addToTime(utcNow(),-7,'Days','yyyy-MM-dd')

Was this reply helpful? Yes No
lumberjacklurch 443 on at

Like (0)

Report

Thank you both for this thread. I used the expression below, but I am getting the below error:

Action 'Get_old_records' failed: The expression "Modified le 10-24-2019" is not valid. Creating query failed.

My expression is almost identical the one verified to work:

Modified le 'addToTime(utcNow(),-5,'Year','MM-dd-yyy')'

The date column I'm checking against is using the standard format.

What am I missing?

Was this reply helpful? Yes No