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
Highlighted
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.

Highlighted
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

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

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

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (6,234)