Convert Date Time from One Time Zone to Another in Power Automate or MS Flow | Advanced Expression

Sometimes there are situations where we need to convert the value of Date Time from One Timezone to another time zone in Microsoft Flow or Power Automate.

In that case, we need to use the Custom Expression in Power Automate which is convertTimeZone(). In this function, we need to provide the Source Time Zone and Destination Time Zone to convert the date string to destination time.

Real-Time Scenario:

I have come across the requirement where I am storing my data in the SharePoint list. SharePoint store the created date in UTC time. I want to convert that UTC time to IST time and send the converted time to the Email Notification. So, basically, here we are converting Time zones from SharePoint to Microsoft Flow. At that time this concept used a lot.

For the reference of different Time Zones, please refer the following URL.

***************
Contact me for any Questions, Consulting Service or Development Service:
Whatsapp: [phone]

#PowerAutomate
#MicrosoftFlow
#PowerPlatform

[AssassinUK]

Thanks for this vid. Set me on the right track.... This is what I used in the end to help with the hour difference set by the BST (British Summer Time) issue ..
convertTimeZone(triggerOutputs()?['body/start'], 'UTC', 'GMT Standard Time', 'dd/MM/yyyy HH:mm')

[FCabralSa]

My settings work reliably till now. They are:
Convert Time Zone:
<Base Time> "Timestamp" from Dynamic Content;
<Format String> "Full date/time pattern (short time)... ;
<Source time zone> (UTC+00:00) Dublin, Edinburgh, Lisbon, London;
<Destination time zone> (UTC +05:30) Chennai, Kolkata, Mumbai, New Delhi

[FCabralSa]

Thanks for the input... I have a Flow which Adds a Row to an Excel sheet. I solved my timestamp issue with the Action "Convert Time Zone" instead of "Compose". Later I shall compare the two actions. Incidentally, I read that if the timestamp (eg. 2020-04-28T16:25:43.8086588Z) ends with "Z" then it is UTC.

[kamsalalakshman]

Bro i need to create flow for notifictation, that shoud b sent before 4 Pm, if any sents after 4pm that notifications needs to go next day

[akbarmahfuzalam]

Why only IST TOME WHY CANT WE CHANGE AS PER THE TRIGGER USER TIME ZONE AND SAVE IT TO SP

[srinivaskolisetti]

Dhruvin - Can you show a simple approval workflow for a list item created date. Ex: When a item is created send approval flow to the Owner. Along with this send reminder email after 14 days to the owner again if doesn't approve. (like Created Date + 14 days) . It would be great if you show end to end scenario's

[AhmedKhodir-novyPro]

Hi Man, I have created a flow where I created a trigger with the date, that will go to Excel online file/table and get a row depending on its date, but the date in the Excel online table is being extracted by the "Get a row" action as numbers (43322), so the trigger's date will be 2019-10-01 while the date in the table os in numbers, so the flow will not be able to identify the required row, how can I resolve this?