Forum Discussion
Auto Dates Update in SharePoint List
I'm glad to hear it. If you feel this was the solution, I'd greatly appreciate marking my answer as the solution. Thanks!
Thanks for the follow-up Doug!
The dates I have are dates associated with when a client's payroll is due, or when taxes need to be done etc. So each year, the date in terms of month and day remain the same but of course, the year needs to change for each new year. To you question (@If I understand you correctly, you are wanting to update all existing list items with a new year? For example, there is a column called "renewal date" that are all 2019, and you want this to automatically roll over to 2020?), yes, 100% correct.
I've attached a screenshot for you if that helps.
Great thanks for confirming. The best option here would be a Microsoft Flow. I did a quick test and in simplest terms it takes a trigger and 2 actions:
- Trigger - Run once yearly on Jan 1
- Get the items in the list
- For each item in the list, update the column for the item
I'm using an expression for the value but you could use OOTB actions for this. Here is my Flow:
The Start Date in my example is the column to update. I use the following expression:
That worked perfectly! Thanks, Doug!
I'm glad to hear it. If you feel this was the solution, I'd greatly appreciate marking my answer as the solution. Thanks!
- Done! Sorry...brand new to the forum. Thanks again!