Do you know how to use correct timezone in your Power Automate flows?
Updated by Tiago Araújo [SSW] 12 months ago. See history
❌ Complex time zone calculations - Handling time zone conversions manually can become cumbersome, especially when dealing with events and meetings across multiple time zones ❌ Daylight saving time issues - While UTC doesn't observe daylight saving time, your local timezone might. This can lead to confusion and scheduling problems when your local time changes ❌ Confusing user experience - In user-facing applications, presenting times in UTC without local context can be confusing for end-users who expect times in their local time

❌ Figure: Bad example - Comparing Datetime in default timezone: UTC with UTC
So to convert it to the correct timezone, you can use built-in expression in your flow:
convertTimeZone({{ array/object }}?[{{ 'timedate variable' }}], 'UTC', 'AUS Eastern Standard Time')

✅ Figure: Good example - You are comparing it in local timezone (i.e AEST with AEST)
For further details on converting timezones in Power Automate Flow, refer to the Microsoft Learn - Converting time zone.
For default timezones, refer to the Microsoft Learn - Default time zones.
Categories
Need help?
SSW Consulting has over 30 years of experience developing awesome software solutions.