691
Hello, I have a Sharepoint list with a "Date" column and a "Money pot" column.
I would like to create a Power Automate feed so that when the date is more than 3 years old, we add the value "300" in the "Money pot" column. But I don't know at all how to do that.
Can you help me please?
Hi @s44
You can filter out the item whose date is more than 3 years through Get items action, and then use Update action to change the value of the money pot to 300.
At present, Flow can't get the number of days in the past three years. So I use a year with 365 days to calculate.
I set up a flow, you can refer to the below screenshots.
This is my test list.
Flow in details.
Flow runs every day.
Filter out items whose date are more than three years.
Expression:
Update Money pot column.
After flow runs, the items whose date are more than three years
The value of Money pot column will be updated to 300.
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.
Share
Report
All responses (
Answers (
