Planner Flow Date Value Format Error

[Afex]

I am using the template "Create a daily summary of Planner Tasks by Bucket" and am trying to customize it.

I want to change the "value planner due date" date format to a more user friendlt option but when I enter an expression instead of the value it crashes the flow.

When I replace the value below with the following expression the flow fails:

formatDateTime(items('Iterate_through_tasks')?['dueDateTime'], 'yyyy-MM-dd').

If I look at what the code for the actual value is it's:

items('Iterate_through_tasks')?['dueDateTime']

I just want the date to be in a more standard user friendly format. How do I change this value without breakign the flow? I must be missing something as it works everywhere else except when setting the variable. 

[v-zhos-msft · Accepted solution]

Hi @Afex ,

You want to change the "value planner due date" date format in the flow.

I have made a test for your scenario, please check it for a reference.

I added two 'compose' action before the 'Set TaskDetails variable' action.

The expression of 'Compose 2' is:

formatDateTime(outputs('Compose'),'yyyy-MM-dd')

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you!  How did you create the function/expressions to go into Compose 2?  When I created the second compose action and copied and pasted the expression in the value text box it didn't turn into a Function.

[RobElliott]

Flow doesn't like copying and pasting unless it's plain text. In the Compose 2 go over to the Expression tab on the right and paste in or type

formatDateTime(outputs('Compose'),'yyyy-MM-dd')

then click OK.

Rob
Los Gallardos

[DSP_SC]

Thank you for this.  A few years later and still useful 🙂  I took your text and added a condition to check if it was null first since some people on the team didn't enter due dates and caused this to fail.

if(empty(outputs('Compose')), null, formatDateTime(outputs('Compose'),'yyyy-MM-dd'))