Answered

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

(0) Share

Report

Posted on by Community Power Pla...

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:

Business Process Flows

I have the same question (0)

All responses (3)

Answers (1)

v-xiaochen-msft on at

Like (0)

Report

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

Hi @Anonymous ,

Please try this:

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

Best Regards,

Wearsky

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

Like (0)

Report

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

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

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (0)

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

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

Was this reply helpful? Yes No