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))'
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')
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.
Share
Report
4,941
All responses (
Answers (
