Planner Tasks - Writing NULL to Start or Due datetimes

[ridgetech119]

Is this possible? We need to nullify Planner Tasks Start Times if it already has a date. I've tried adding a Compose that uses fx NULL, but then it turns into a literal '' when attempting to write to a planner tasks start/due.

[StretchFredrik]

Try using string(' ')

[ridgetech119]

I get:

"message": "The request is invalid:\r\nCannot convert the literal ' ' to the expected type 'Edm.DateTimeOffset'.",
Previously, similar message:
"message": "The request is invalid:\r\nCannot convert the literal '' to the expected type 'Edm.DateTimeOffset'.",

[ekarim2020]

Hi @ridgetech119 ,

Please check that you are using the NULL "value" in your expression, for example:

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

[ridgetech119]

Hi @ekarim2020 ,

I get the 2nd error message in my above post when I try this. Did it work for you?

[ekarim2020]

Hi @ridgetech119 ,

Here is the sample data followed by the runtime output of my demo flow:

Flow run:

Can you share the exact expressions used in your flow? Please provide screenshots too.

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

[ridgetech119]

Hi @ekarim2020 ,

Sure, below is just a null for expression to test and it doesn't work.

Raw inputs on failed action:

Can you show me your exact expression in the Update a task action?

[ekarim2020]

Hi @ridgetech119 ,

Please post a screenshot of the error message and the screen of the runtime output at the point where the flow failed.

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

[ridgetech119]

[ekarim2020]

Hi @ridgetech119 ,

I am just using the null value in the expression:

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

[ridgetech119]

There are spaces but I can't do anything about it. Specifically, when I cursor all the way to the left, I have to press the right-arrow twice as if there was a space there, but backspace and delete doesn't seem to remove this space without removing the null with it. I mean, it's a pretty simple ask... click a input field, click Expression, type null, click OK and it takes. Seems to work for EVERY other null usage I have in my flow. Just not this planner update task. I am using Power Automate web; are you using the Desktop version?

[ridgetech119]

Hi @ekarim2020 ,

Further testing shows that it works when I use a Manually trigger a flow action.

My flow is triggered from Sharepoint when an item is created or modified.
Designer:

Run details:

Is this expected behaviour when using different triggers?