Time Zone Labels in Dynamics 365 Customer Insights - Journeys Events

There is a magical The ‘Event time zone’ field in Dynamics 365 which is used for Events in Customer Insights - Journeys. Technically speaking in the background it all works great, the time is correctly converted to UTC and shows as expected for calendar invite timings etc BUT the actual name of the GMT offset time zone e.g. ’(GMT+10:00) Canberra, Melbourne, Sydney’ is hellishly wordy and it’s only correct for half the year in any region that uses daylight savings… doh! Why do I care? When you include this in your email to show the event time zone of the event, it doesn’t look too smart! This post will show you how to create a simple Power Automate flow to generate a correct and neater time zone label for all your events that can be used in event communications, with style.