web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Where to Place Convert...
Power Automate
Unanswered

Where to Place Convert Time Zone in Calendar Flow

(0) ShareShare
ReportReport
Posted on by 37

Hello Power Automate Community!

 

I used this post to guide my design for a daily calendar preview. Everything is functioning as intended, with the exception of the time conversion. It keeps returning in the default format (and for some reason, 4 hours later than the actual meeting time):

2023-09-18_13-26-16.png

 

I initially tried the FormatDateTime function, but wasn't fully sure where to place it and as a result the flow failed. I saw in another post where a user recommended the Convert Time Zone action, which I believe I have set up correctly:

2023-09-18_13-28-59.png

 

I have tried placing this action at a few points in my flow, as indicated by the yellow arrows below; however, when I run a test, the result is the same as indicated in the first image. I'd appreciate any recommendations for successfully setting up this step!

 

2023-09-18_13-35-45.png

 

 

 

Categories:
I have the same question (0)
  • creativeopinion Profile Picture
    10,502 Super User 2025 Season 2 on at

    @magistra I'm assuming that you would like to display the Event time in your local time zone. If that's the case, you need to put the Convert Time Zone action in your Apply to each action to convert the Start and End time returned by each Event.

     

    Hope this helps!

    If I helped you solve your problem—please mark my post as a solution ✅.
    Consider giving me a 👍 if you liked my response!

    👉 Watch my tutorials on YouTube
    👉 Tips and Tricks on TikTok
  • magistra Profile Picture
    37 on at

    @creativeopinion Thank you for looking at my query! This is how I placed the Convert Time Zone in the Apply to Each action. Unfortunately it is still returning in the default format. Do you have any idea why this might be?

    2023-09-18_16-14-14.png

     

  • Verified answer
    wskinnermctc Profile Picture
    6,519 Moderator on at

    @magistra the Current Time action is exactly like using utcNow(); it returns the UTC time. 

     

    You have to convert from UTC to your timezone.

     

    Convert Time Zone.pngConvert Time Zone Results.png

     

    If there is a "Z" at the end of a timezone then it is UTC.

  • magistra Profile Picture
    37 on at

    @wskinnermctc That was most helpful! I see now that the conversion is successfully being made, but that it is somehow being "dropped" in the Compose and Create HTML Table actions:

     

    2023-09-18_16-29-38.png

     

    2023-09-18_16-26-24.png

    2023-09-18_16-27-26.png

    2023-09-18_16-27-40.png

  • Verified answer
    creativeopinion Profile Picture
    10,502 Super User 2025 Season 2 on at

    @magistra If you want to return the Start/End Time of the event you need to adjust the Base Time to the Start or End Time dynamic content from the Get Events action. 

     

    You also need to adjust the Source Time Zone to UTC which is the timezone returned from the Get Events action. 

  • creativeopinion Profile Picture
    10,502 Super User 2025 Season 2 on at

    @magistra Refer to my post below. Your base time is incorrect as you are referencing the wrong time. It's not being dropped—just not referenced.

    creativeopinion_0-1695069699924.png

     

  • magistra Profile Picture
    37 on at

    @creativeopinion @wskinnermctc I see now what you both were saying about the UTC conversion, and needing to reference the Start Time and End Time with Dynamic Content.

     

    Once I added the Convert Time Zone actions for Start Time and End time, I realized I was making a similar error with referencing the wrong Dynamic Content in the Compose action. I swapped out Start Time and End Time for Converted Time and Converted Time 2, and now it is working. Thank you both very much for your support!

    2023-09-18_17-16-08.png

     2023-09-18_17-16-36.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard