Showing results for 
Search instead for 
Did you mean: 
Advocate II
Advocate II

Task to Planner - UTC Time conversion? problem with the time format

Hi All,

I'm trying to make a simple flow to save Tasks to Planner. I started from the Template, but simply it does not work at all.

I am suspecting the cause is the UTC time format or conversion or what ever it is, and tried as much as possible.


Error message is below: 

I also got the "The request is invalid:\r\nCannot convert the literal '2018-02-28 00:00:00Z' to the expected type 'Edm.DateTimeOffset" when I changed the Format string in Convert the time zone to Universal sortable date/time.

 And I am in South Africa.

  "error": {
    "message""Property assignments in payload has a value that does not match schema.",
    "innerError": {


Has anyone got a same problem?




Memorable Member
Memorable Member

Hi @JunkoOhara


From looking at your screenshots, it seems your issue starts in the Condition step where you check for Due Date is equals to null. If you want to check for a null value, especially on a date, you should try the Coalesce function, which you can read more about it in this site. Additionally, I wrote a blog post a while back to show how to use the Coalesce function. Here's the link to the post 

Check for Null Value Using Flow


I hope this helps.



Fausto Capellan, Jr

Fausto Capellan, Jr
Did I answer your question? Mark my post as a solution! Did my response help? Please give it a thumbs up!

I agree, it is the Null in your condition.

Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!

Community Support
Community Support

Hi @ JunkoOhara,

The error told that the time in the Data Time field isn’t the right format.

I have made a test on my side ,

If I create a flow as you, when I create a task with a null “Due date”, the action “Convert time zone” of the flow would have an error “Evaluation of inputs for the expression action of kind 'ConvertTimeZone' failed: 'Required property 'baseTime' expects a value but got null. Path ''.'.” , and the would run failed.

You should move the “Convert time zone” under the Condition.

You could create a flow as screenshots below to solve your problem:


The expression of the “Condition” as below:


The expression of the “Start Data Time” as below:


The expression of the “Due Data Time” as below:




When a task with a null “Due date” is created in the “Outlook task”, the flow would run successfully as below:


When a task with a exist “Due date” is created in the “Outlook task”, the flow would run successfully as below:



Alice Zhang

Thank you so much @v-yuazh-msft and @faustocapellanj.

I'm still strugling to get it work.


So far I have cut the problems, and now know that checking the 'Null' in the Due Date is not working for me so far.

I saw @faustocapellanj's blog and tried below;

@equals(coalesce(triggerBody()?['DueDateTime']?['DateTime'],''), '')




All not working.. The problem is I really don't get the syntax in the first place.

So not sure what to put in, so just guessing around. I'm starting to think that this is too advanced for me..


2018-03-13 17_16_48-Edit your flow _ Microsoft Flow - Opera.png

Helpful resources

Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (19,015)