Get Items with date column older than one year.

(0) Share

Report

Posted on by AdamD

156

Hello,

I'm trying to craft a flow that gets items in a sharepoint list where a DateColumn returns as older than one year and the column IsActive returns as true. So far I've tried variations on the following OData filter query in Get Items:

month(DateColumn) eq @{formatDateTime(utcNow(),'mm')} and year(DateColumn) lt @{formatDateTime(utcNow(),'yyyy')} and IsActive eq true

I know that my date functions crafted in Flow are returning correctly, but the OData query syntax and functions must be off. I tried following the syntax listed here in section 4.5 under the date functions, but I'm a newbie and must be making a mistake somewhere. Any help would be most appreciated!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hello @AdamD ,

you can't use any expression on the SP column when using in the OData query, you must use it as it is, all operations must be done on right side of the condition in the 'value' part.

To get everything older than one year I'd compare the DateColumn with today's date - 1 year:

DateColumn lt '@{addToTime(utcNow(),-1,'Year')}'

and add the IsActive filter, I guess it's a Yes/No column so you should compare it with 1/0 value:

Date lt '@{addToTime(utcNow(),-1,'Year')}' and IsActive eq 1

Was this reply helpful? Yes No
AdamD 156 on at

Like (0)

Report
Copy link

Link copied!

Yes! Thank you so much @tom_riha !

Was this reply helpful? Yes No
Power_Person 71 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your great solution!
How could I change the condition to send an email when the date is exactly 60 days ago?

Was this reply helpful? Yes No