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.
"message": "Property assignments in payload has a value that does not match schema.",
Has anyone got a same problem?
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
I hope this helps.
Fausto Capellan, Jr
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:
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;
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..
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks