How to Convert Time Zone in Power Automate

How to Convert Time Zone in Power Automate

When working with Power Automate, date and time values are typically stored in UTC format. However, business users often need to view dates and times in their local time zones.

Power Automate provides built-in actions and expressions that make it easy to convert date and time values from one time zone to another.

Why Convert Time Zones?

• Display local business hours
• Send region-specific notifications
• Schedule meetings accurately
• Support global users
• Handle daylight saving adjustments automatically

Using the Convert Time Zone Action

Power Automate includes a dedicated Convert Time Zone action that simplifies date and time conversions.

1. Add the Convert Time Zone action.
2. Select the Base Time value.
3. Choose the Source Time Zone.
4. Select the Destination Time Zone.
5. Specify the desired date format.

Using convertTimeZone() Expression

You can also use the convertTimeZone() expression when working with dynamic values inside flows.

convertTimeZone(
utcNow(),
'UTC',
'India Standard Time'
)

The expression converts the current UTC date and time into India Standard Time.

Formatting Converted Dates

You can combine time zone conversion with custom date formatting.

formatDateTime(
convertTimeZone(
utcNow(),
'UTC',
'India Standard Time'
),
'dd/MM/yyyy hh:mm tt'
)

Common Time Zones

• UTC
• India Standard Time
• Eastern Standard Time
• Pacific Standard Time
• GMT Standard Time
• Central Europe Standard Time

Common Use Cases

• Email notifications
• Approval workflows
• Meeting scheduling
• Dataverse record creation dates
• SharePoint list reporting
• Global business processes

Best Practices

• Store dates in UTC whenever possible.
• Convert dates only when displaying to users.
• Use built-in time zone names.
• Test daylight saving transitions.
• Apply consistent formatting standards.

Key Takeaways

• Power Automate stores dates primarily in UTC.
• The Convert Time Zone action simplifies timezone conversion.
• The convertTimeZone() expression provides flexibility.
• Formatting can be combined with timezone conversion.
• Proper timezone handling improves user experience and reporting accuracy.