Answered

Check if an item is over a year old

(0) Share

Report

Posted on by Ubertortle

Hello, I am attempting to setup a condition to check if a SharePoint list item from Get items was created over 1 year ago. My thought at first was to check if the 'created' column of the item is greater then 'created' + 365 days. But I have not only found the best way to do this, I didn't realize that checking if something is greater or less isn't an option in the condition action. Any suggestions?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!
Hi @Ubertortle,

The best option for you is to use the filter query option in the get items action.

Add the following text in that box:

create gt [date of a year ago]

Extra tip: you can easily calculate that date with the following expression:

addDays(utcNow(), 365)

Hopefully this works for you!

Cheers,

Daniel

Was this reply helpful? Yes No
Ubertortle 52 on at

Like (0)

Report
Copy link

Link copied!

This is what I was looking for. But it appears it is comparing the date the item was created with a year from right now. Which it is not greater than.

Was this reply helpful? Yes No