Answered

Planner Flow Date Value Format Error

(0) Share

Report

Posted on by 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.

Annotation 2019-03-08 070039.jpg Annotation 2019-03-08 070231.jpg

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-zhos-msft on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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.

Was this reply helpful? Yes No
RobElliott 10,323 Super User 2025 Season 2 on at

Like (1)

Report
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

Was this reply helpful? Yes No
DSP_SC 3 on at

Like (0)

Report

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'))

Was this reply helpful? Yes No