Date and Time Conditions/Expressions

[nelsonbj]

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!

[v-yamao-msft · Accepted solution]

Hi @nelsonbj,

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

[nelsonbj]

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. 🙂