Answered

How to add days (1 Month or 1 Year) to an existing Date on Sharepoint list

(0) Share

Report

Posted on by Community Power Pla...

Hello!

I have a list of items that need to get done Monthly/Annually. I am creating a flow to update the date stamp. Example: Item is due 11/12/22. After completion I want to manually run a flow to update the date stamp to 11/12/23. The issue i am having with my flow is that it is adding days to today's date oppose to the date that is in the selected column. Below is my flow and formula. I think what is causing my flow to grasp today's date is "utcNow" in my formula. Is there a way where my formula could say addDays(DayofTheWeek(), 365, 'MM-dd-yyyy') DayoftheWeek is the name of my column where my date is included. I may be wrong... but i need help!

Please refer to the image below

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @Anonymous，

Do you want to update the DayoftheWeek from the selected item 1 year later?

I think you should use the Get item action instead. You should get the Id from the trigger and refer to it in the Get item action to get the DayoftheWeek field.

addDays(outputs('Get_item')?['body/DayoftheWeek'],365,'MM-dd-yyyy')

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

Like (0)

Report

OMG thank you so much, it worked!! Second questions though what formula would you recommend to use to change a date exactly 1month from the assignment date? Because if i put 30 days not every month has 30 days.

Was this reply helpful? Yes No