Time zone in Power Automate

user_18610189 0
Viewed 1069

I'm using ConvertTimeZone function in power automate to convert from UTC to a certain time zone. The only conversion that has passed is from UTC to Eastern Standard Time:

convertTimeZone(triggerOutputs()?['body/Maintenance_x0020_Window'],'UTC','Eastern Standard Time','dd-MMM-yyyy hh:mm tt')

Next I need to convert to the time zone in London - Greenwich Mean Time/GMT and to Lyon, Rhône, France time zone Central European Summer Time/CEST but i get this error: the value provided for the time zone id 'Central European Summer Time' was not valid.

Any idea what I'm doing wrong?

power-platform power-automate sharepoint-online timezone time
1 Answers

It would seem that the convertTimeZone function expects a Windows time zone identifier. For your requested zones, the IDs are:

  • "Eastern Standard Time" - for the Eastern time zone of US & Canada inclusive of both EST and EDT
  • "GMT Standard Time" - for Great Britain, inclusive of both GMT and BST
  • "Romance Standard Time" - for France and several other European countries, inclusive of both CET and CEST

Yes - the names are confusing. You can read more about this and see ways to get the entire list of zone names by reading the subsection titled "The Microsoft Windows Time Zone Database" within the timezone tag wiki.

user_6348240
Related