cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

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!

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 Solution Authors
Top Kudoed Authors
Users online (4,603)