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):
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:
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!
@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!
@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.
@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.
@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:
@magistra the Current Time action is exactly like using utcNow(); it returns the UTC time.
You have to convert from UTC to your timezone.
If there is a "Z" at the end of a timezone then it is UTC.
@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?
@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!
stampcoin
69
Michael E. Gernaey
66
Super User 2025 Season 1
David_MA
42
Super User 2025 Season 1