cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SemiEvilMonkey
Level: Powered On

Planner Time Conversion

I am creating planner tasks from emails I get. I pull the email in a pull out the data I need. I am working on the planner start\due dates, these values come from the email in the format of MM-dd-yyyy. In the body of the email it loos like this:

 

Assigned to: person, some

Start Date: 03/01/2020

End Date:  03/30/2020

Hours Booked:  5.00

 

So for start date I have a few composes setup to pull 03/01/2020. Now I have tried a few things. If I set the Create Tasks "Start Date Time" to the output of the compose that has the correct value it creates everything fine just the start date is a day before the value it got from the compose...so it uses 2/29/2020. I have tired to also use Convert Time zone and used various timezone settings for force it to be the correct date but no matter what I do my output looks to be the correct date of 03/01/2020 but the task always gets 02/29/2020. Any idea why? 

 

2020-01-20_11-45-38.jpg

 

1 ACCEPTED SOLUTION

Accepted Solutions
WDRC
Level 8

Re: Planner Time Conversion

@SemiEvilMonkeyThis is leap year question that I posed a few years ago now but really did not get resolved.

View solution in original post

5 REPLIES 5
SemiEvilMonkey
Level: Powered On

Re: Planner Time Conversion

I am able to make it work by using this in the format string but still dont understand why its putting it a day behind without doing this

addDays(outputs('StartDatefromEmail'),1,'yyyy-MM-dd')

 

 

Community Support Team
Community Support Team

Re: Planner Time Conversion

Hi @SemiEvilMonkey ,

 

Could you please share a screenshot of the configuration of the flow that use the date 02/29/2020 to replace the date 03/01/2020?

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

WDRC
Level 8

Re: Planner Time Conversion

@SemiEvilMonkeyThis is leap year question that I posed a few years ago now but really did not get resolved.

View solution in original post

SemiEvilMonkey
Level: Powered On

Re: Planner Time Conversion

Thanks
WDRC
Level 8

Re: Planner Time Conversion

@SemiEvilMonkeyso if my past post helped you could you help me understand how I can resolve my issue.

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,389)