Answered

Date and Time Conditions/Expressions

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I am trying to build a flow that runs on a weekly schedule, checking for items (in a SharePoint List) that have been created more than one year ago. If an item has not been created more than a year ago, then the flow takes no further action. But, if the item has been created more than a year ago, then flow will take steps to move that item to a separate SharePoint List.

I mostly have things figured out (I think), but am having a lot trouble figuring out what the correct expression would be (to test whether or not an item has been created more than a year ago). So far, I have:

@equals(items('Apply_to_each')?['Created'], utcNow(addDays(365)))

Creating expressions is definitely something that I have long struggled with, so any help you could provide would be much appreciated!

Thanks a bunch!

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-yamao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous,

Do you want to check items that have been created more than one year ago and save them into another list?

I have made the following test. As I don’t have an item created one year ago, so I create a Date column. It is trigged by a Button, while you could change it to a Recurrence trigger according to your needs.

In the Condition, use the following code:

@equals(formatDateTime(items('Apply_to_each_2')?['Date'], 'yyyy-MM-dd'),formatDateTime(adddays(utcnow(),-365),'yyyy-MM-dd'))

Note: Make sure you have formatted the two dates into the same format.

The flow is configured as below and it works fine. Please take it for a reference.

Best regards,

Mabel Mao

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

To answer your question, yes. The goal is to check items on a list, saving them to a different list if they have been created more than one year ago.

Which is what I believe your expression below does. For testing purposes, if I changed -365 to -1, that shouldn't break anything right? It would just change the flow so that it looks for items older than one day instead of one year?

Thanks a bunch for all your help, I really appreciate it. 🙂

Was this reply helpful? Yes No