You’re offline. This is a read only version of the page.
Hi everyone,
I'm working on a Power Automate flow that uses the "When an appointment is created" trigger to automatically create a post in a Teams channel. The post includes the date and time of the booking appointment using the "StartTime" dynamic content. However, I've encountered two issues:
Time Zone Discrepancy: The displayed time is 3 hours ahead of the desired time zone (UTC-3) and it is on the 12h system, but I need it to be on the 24h system
Date Format Inconsistency: The date format is currently in mm/dd/yyyy, while I need it to be in dd/mm/yyyy format (Brazilian format).
I've tried creating an expression to adjust these settings, but haven't been successful.
Could you please help me achieve the following outcome for the Teams post:
Display the date and time of the booking appointment in UTC-3 time zone.
Format the date in dd/mm/yyyy format.
24h time format
If any further details are needed to assist with this issue, please let me know. Thanks in advance!
That's the flow I'm working on
Hey @Andrew_J
I managed to make the expression work. Now UTC is correct.
I used the this expression: formatDateTime( addHours(triggerBody()['startTime'],-3), 'dd/MM/yyyy HH:mm:ss' )
Thank you very much for your help!
Hi @Andrew_J,
the format is now correct, date dd/mm/yyyy and time in 24h format, but UTC -3 did not work. There is a 3 hour difference. I make the appointment for 12h, but the post on teams the appointment is for 15h.
How do I set the time to the correct UTC?
The MS booking is already configured for UTC -3. Thank you!
Try looking at the variable as below:
The value should be a FX so try that first.
See how we get on, I am from the UK so hopefully you can try it in the next 2 hours.
Andrew
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
Share
Report
All responses (
Answers (
