Dealing with Time Zones
A Bing search of "dealing with time zones in Power Automate" returns over 2.3 billion results.
The first result describes how to deal with this issue on an individual basis, which is great if you are creating a flow just for yourself. But it is not helpful for a problem I have, which I will describe.
I am developing a solution for our sales people to book appointments in our virtual design centers. The sales people, as well as our customers are located around the world. We have virtual design centers in multiple countries. All this leads to dealing with multiple times zones for one request. We might have a salesperson in California who needs to book a session in the Chicago design center for a customer in Hawaii, and the credentials of the person in IT who developed the Power Automate solution is in Germany. Four time zones for one request.
When a request is submitted the sales person chooses the date and time for the virtual meeting. The flow kicks off and checks the shared calendar of the specified design center for conflicts. If there are no conflicts, it adds the meeting to the shared calendar, and then sends a notification to the salesperson, the design center and the customer that the meeting has been booked. How do we send an e-mail so each person sees the date and time of the meeting in their time zone? And what time zone should be specified in the create event action?
Digital computers have been around since 1945, so it is time for big tech to come up with a solution for dealing with a global economy where people interact with one another from around the world. My suggestion would be that all dates are saved behind the scenes in UCT (Universal Coordinated Time) but are displayed everywhere (e.g, Word, Excel, Outlook, Edge, etc.) in the time zone of the user based on the time zone of their device. We shouldn't have to do any conversions of time zones, it should be seamless and automatic.
