Delete Records older than 5 years

(0) Share

Report

Posted on by lumberjacklurch

443

I have a list of records that I'm trying to set up a reoccurring flow for. I used the expression below (in the Get Items action), 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 one to 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?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Ellis Karim 12,187 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Change the date format to ISO 8601 format:

addToTime(utcNow(),-5,'Year','yyyy-MM-dd')

For more info about this, see: Why Are My SharePoint Dates Wrong in Power Apps and Power Automate? – Ellis Karim's Blog

Ellis

https://elliskarim.com/

Was this reply helpful? Yes No
lumberjacklurch 443 on at

Like
a
(0)

Report
Copy link

Link copied!

I made the correction, but I still get the error.

I don't understand, from the error and the parmeters, it should work.

I feel like I'm missing something obvious.

Was this reply helpful? Yes No
Suggested answer

Ellis Karim 12,187 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Enclose the expression in single quotes as shown below:

Ellis

Ellis Karim's Blog – IT doesn't have to be complicated!

Was this reply helpful? Yes No
lumberjacklurch 443 on at

Like
a
(0)

Report
Copy link

Link copied!

I knew it was something obvious. Thanks!

Was this reply helpful? Yes No