Get text date values from email and convert them for use in updating a group plannner task start date and end date

[Anonymous]

errorflow diagram
formulas usedIm trying to use the Start and End dates in an email to update the Start and End dates in a Planner Task. I've dug through multiple posts trying to figure this out but i can't seem to find the right answer. The error seems to be in trying to convert the text date from the email to a usable format. Everything I've tried results in the error in the first picture.

[Brad_Groux]

You need to make sure you are formatting your definitions correctly, as defined by the Microsoft Planner Connector documentation. Accord to the Planner API documentation, the date/time needs to be formated similar to: 

The Timestamp type represents date and time information using ISO 8601 format and is always in UTC time. 
For example, midnight UTC on Jan 1, 2014 would look like this: 
2014-01-01T00:00:00Z

You can covert the date and time using the utcnow() and formatDateTime expressions. The links below outline all of the various ways to use these expressions and covert date/time. 

• Working with Dates and Times inside of your flows
• Formatting Date And time in MS Flow
• Custom date and time format strings
• Use expressions in flow actions