Answered

Delete 'Archived' Item after Five Years

(0) Share

Report

Posted on by Phineas

5,331 Moderator

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,280 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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