Answered

Formatting value Completed Date Time in daily summary of Planner Tasks by Bucket

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

https://make.powerautomate.com/galleries/public/templates/df5797658f954281b54bad8bf9cc8246/create-a-daily-summary-of-planner-tasks-by-bucket?fromflowportal=true

I am using the above linked flow but would like to be able to format the 'value Completed Date and Time' to a normal M/dd/yyyy h:mm tt format, but I cannot seem to figure it out.

Right now, it outputs as this format:

Any help would be appreciated!

Categories:

Building flows

All responses (3)

Answers (1)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Please try this:

formatDateTime(items('Iterate_through_tasks')?['completedDateTime'],'M/dd/yyyy h:mm tt ')

Best Regards,

Wearsky
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

When I use formatDateTime(items('Iterate_through_tasks')?['completedDateTime'],'M/dd/yyyy h:mm tt ') I receive this error:
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hello,

I was able to find the solution, thanks to this post: https://powerusers.microsoft.com/t5/Building-Flows/How-do-I-format-the-date-in-the-standard-template-Create-a-daily/td-p/278359

if(empty(items('Iterate_through_tasks')?['completedDateTime']),'',formatdatetime(items('Iterate_through_tasks')?['completedDateTime'],'MM/dd/yyyy'))