cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
wookawsh
Level: Power Up

Add days Microsoft Planner Due Date from Creation Date

Im trying to create a planner task with a DUE DATE 1 day from creation date of Sharepoint list item. 

Here is my FLOWPlanner Due Date Flow.PNG

 

The AddDays expression is as follows: 

addDays(triggerBody()?['Created'], +1, 'yyyy-MM-ddT00:00:00Z')
 
The flow runs successfully, but the due date is not updated to the Created Date +1 (in this case it should be 5/4/2019Planner due Date, Planner.PNG

The circled in red should be 5/4/2019

 

As you can see the Flow Data appear appropriateSuccessful Planner Flow 1.PNG

 

Successful Planner Flow 2.PNG

The due date for both INPUT and OUTPUTE is 2019-05-04 

What am I not doing correctly? 

Thank You!

1 ACCEPTED SOLUTION

Accepted Solutions
wookawsh
Level: Power Up

Re: Add days Microsoft Planner Due Date from Creation Date

Thank you. 

Good pick up on the ZULU time zone. Smiley Very Happy

Your solution worked very well.  It created with +1 date. 

As you said, mulitple solutions.

I changed my created date from ZULU

addDays(triggerBody()?['Created'], +1, 'yyyy-MM-ddT00:00:00Z')

To MST

addDays(triggerBody()?['Created'], +1, 'yyyy-MM-ddT00:00:00MST')

I tested this and it works as well. Now I dont have to worry about my time zone or adding hours. 

Do you see any issues with this approach?

 

Thanks again. 

 

View solution in original post

2 REPLIES 2
Super User
Super User

Re: Add days Microsoft Planner Due Date from Creation Date

@wookawsh 

I'm new here, so I could be off base...but I think because your due date is stored as midnight Zulu time (UTC), Sharepoint is translating that to your local time which may be a few hours behind.

 

20190503d.PNGThere's probably a bunch of ways to fix this, but the easiest might be to set the due date time for + 1 day, and then set the time for something that gives enough hours for Sharepoint to back out and still keep the same day.  As an example, I am 7 hours behind, so if I set the Due Date Time to 10:00:00Z, then I should still see the same date.

 

Let me know what you think.  Good luck!

wookawsh
Level: Power Up

Re: Add days Microsoft Planner Due Date from Creation Date

Thank you. 

Good pick up on the ZULU time zone. Smiley Very Happy

Your solution worked very well.  It created with +1 date. 

As you said, mulitple solutions.

I changed my created date from ZULU

addDays(triggerBody()?['Created'], +1, 'yyyy-MM-ddT00:00:00Z')

To MST

addDays(triggerBody()?['Created'], +1, 'yyyy-MM-ddT00:00:00MST')

I tested this and it works as well. Now I dont have to worry about my time zone or adding hours. 

Do you see any issues with this approach?

 

Thanks again. 

 

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,389)