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!
Solved! Go to Solution.
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
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
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. 🙂
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
4 | |
3 | |
2 | |
2 | |
2 |
User | Count |
---|---|
14 | |
11 | |
6 | |
6 | |
6 |