Power Automate wrong time zone

Are you getting the wrong time while fetching the date and time from the SharePoint list in Power Automate? In this Power Automate tutorial, we will see how to fix the Power Automate wrong time zone problem.

Power Automate wrong time zone

For example, I have a Sharepoint list called Event list, and we have a column that contains the date and time of the Event. So, based on the current date, we will get the events and we will send an email notification to the Organizer.

power automate wrong time zone

So, when we send an email to the organizer, you can see the first item i.e. Personal development event date and time is 10/17/2023 11:25 AM. But when I pass the event date by formating ‘yyyy-MM-dd hh:mm tt’ in the ‘Send an email (V2) action, the event date and time are coming as 2023 -10-17 06:25 PM.

power automate time zone wrong

This is what my flow looks like:

email time is wrong in Microsoft Power Automate

Now let’s see how we can fix the wrong time zone problem in Power Automate.

Solution: Wrong time zone in Power Automate

Here we are facing the problem of the wrong time due to the time zone mismatch between SharePoint and Power Automate.

So, we will convert the date and time to the required time zone. To get the required time zone you can check the time zone in the SharePoint Regional setting.

outlook showing wrong time zone

Once you have the required time zone, you can add the action ‘ Convert time zone’ to the flow. Then provide the below information:

  • Base time: Select the date and time you want to convert.
  • Format string: Select the format.
  • Source time zone: Select the source time zone
  • Destination time zone: Select the destination time zone i.e. the time zone shown in the Regional setting of SharePoint.
email time is wrong in Power Automate

Next, pass the output of the Convert time zone in the email details below.

Microsoft power automate wrong time zone

Now if you run the flow, you will get the correct time in email as it is in the Sharepoint list.

power automate wrong time zone

Conclusion

In this Power Automate tutorial, we saw how to resolve Power Automate wrong time zone for the SharePoint list column.

See also  Power Automate Desktop Mathematical Operations

You may also like:

>