Unanswered

How to Convert Time Zone in "Create a daily summary of Planner Tasks by Bucket"

(0) Share

Report

Posted on by devon_birch

How do I change the time zone from UTC to CST when I'm in the template "Create a daily summary of Planner Tasks by Bucket"? On the daily report, I want it to show the time that it was complete and this is the current formula I'm using to do that:

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

This is mostly what I need but I need it to be in CST and it is currently showing as UTC. How would I go about doing this? I've tried a few different things but keep getting error messages.

I know there is a way to convertFromUtc but I cannot figure out where in the formula above that it would go.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (0)

Report
You can use the Convert time zone action, such as:
This is the example output:
You can customize the output format of the date to your needs:

The equivalent expressions would be:
convertFromUtc(utcNow(),'Central Standard Time', 'MM/dd/yyyy')

Ellis

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

Was this reply helpful? Yes No
devon_birch 9 on at

Like (0)

Report

This is closer! How do I get the converted time into my HTML table? I've tried inserting it into the "From" spot but that didn't work.

Was this reply helpful? Yes No
Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (0)

Report
The output of the converted time can be used via dynamic content:
I didn't understand the question. You may need to share the screenshots of the flow and the format of the data in the Task variable.

You could use the Select action to select the fields for the HTML table, perhaps even change the names of the columns, add the date fields using the output from the convert time zone (or even use an expression):

convertFromUtc(utcNow(),'Central Standard Time', 'MM/dd/yyyy')

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

Was this reply helpful? Yes No
devon_birch 9 on at

Like (0)

Report

Going back to the convert time zone, I want the time to be the time that they marked the task complete, not "utcNow()."
Say the task was marked complete at 12:15pm CST. When I test run my report, it shows the time that I run the report as the completed time rather than the time it was marked.

Was this reply helpful? Yes No
Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (0)

Report
Here is a demo flow that uses the List tasks action to get some task data (I'm not a Planner user!).
The Select action then (very quickly) iterates through each task item: if there is no CompletedDateTime field for the task, return null (empty), else convert the CompletedDateTime to CST time and return the date in the format MM/dd/yyyy hh:mm:
This is the expression that is used in the Select action:
if(empty(item()?['CompletedDateTime']),null, convertFromUtc(item()?['CompletedDateTime'],'Central Standard Time','MM/dd/yyyy hh:mm'))
Hope this helps.

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

Was this reply helpful? Yes No