How to Convert UTC to Local Time Zone in Power Automate?

Do you know how to convert UTC to local time zone in Power Automate? Well, this Power Automate tutorial will explain how to convert UTC to local time with various examples.

Here, I will discuss three ways to convert UTC to local time:

  • Power Automate convert UTC to local time Convert time zone action.
  • Power Automate convert UTC to local time using the ConvertFromUtc() function.
  • Power Automate convert time in SharePoint List using Convert time zone action.

How to Convert UTC to Local Time Zone in Power Automate

The “Convert time zone” action is a built-in function that allows you to convert date and time values from one time zone to another within your automated flows. This action typically involves specifying the source and target time zones.

Using Power Automate Convert time zone action, let’s see how Power Automate converts UTC to local time.

1. Navigate to https://make.powerautomate.com in your browser to open the Power Automate home page, click on + Create -> Then select the Instant cloud flow -> Provide the flow name and choose the trigger’s flow (Manually trigger the flow).

Power Automate Convert utc to local time

2. Add the ‘Convert time zone’ action to convert date and time values from one time zone to another within your automated flows. Set all the required details:

  • Base time: I have given the expression utcNow() from Expression.
  • Format string: Select the exact format string patterns.
  • Source time zone: Provide the value in which the base time is currently expressed.
  • Destination time zone: Select the time zone where you want to convert the base time.
How to Convert UTC to Local Time Zone in Power Automate

3. Add the ‘Compose’ flow action and set the required field.

  • Inputs: Here, I have given Converted time from dynamic content.
How to convert utc to local time using Power Automate

4. Now click Save and Test -> Test it Manually -> Then the Compose flow action will display the output according to the convert time zone action output.

Power Automate convert time zone action

This is how Power Automate converts UTC to local time using the Convert time zone action.

Power Automate Convert UTC to Local Time Using ConvertFromUtc() Function

I will show you how to convert UTC to local time using the ConvertFromUtc() Function. To work around this, follow the steps below.

1. Open the Power Automate home page, click + Create -> Select the Instant cloud flow -> Enter the flow name and choose the trigger’s flow (Manually trigger the flow).

Power Automate ConvertFromUtc() function

2. Next, add the ‘Initialize variable’ to store the text value during the flow and set the required fields set the required fields. Set all the required details.

  • Name: Provide the name of the initialized variable.
  • Type: Select the type of variable as String.
  • Value: Here, I have given the expression utcNow() from Expression.
utcNow()
Power Automate convert time zone expression

3. Add the ‘Compose’ flow action to convert UTC to local time expression.

convertFromUtc(utcNow(), 'Eastern Standard Time','dd-MM-yyyy hh:mm tt' )
Power Automate convert from utc expression

4. Now, it’s time to Save and Test. Test it Manually -> The Compose flow action will display the output according to the expression below.

Power Automate convert time zone format

This is how Power Automate converts UTC to local time using the ConvertFromUtc() expression.

Power Automate Convert time in SharePoint List using Convert time zone action

In this part, I will show you how to convert time in a SharePoint list using the Convert time zone action.

Here, I will show how to convert the time of a created column in a SharePoint list and display when the SharePoint item is created with day, date, and time with the local time zone.

Convert SharePoint item time using Convert time zone action in Power Automate

To work around this, follow the steps below.

1. Navigate to https://make.powerautomate.com in the browser to open the Power Automate home page. Click on + Create -> Select the Automated cloud flow -> Provide the flow name and choose the trigger’s flow(When an item is created and modified).

  • In this trigger, provide the Site Address and List Name.
Power Automate Convert SharePoint time zone

2. Then add the ‘Convert time zone’ flow action to convert date and time values from one time zone to another within your automated flows and set the required field.

  • Base time: Select the value you want to convert.
  • Source time zone: Provide the value in which the base time is currently expressed.
  • Destination time zone: Set the time zone to which you want to convert the base time.
  • Format string: Select the exact format of the string pattern as per your scenario.
Power Automate convert time zone custom format

3. Add the ‘Update items’ flow action to modify or update specific properties of an item in a data source and set the required fields.

  • Site Address: Provide the SharePoint site URL.
  • List Name: Select the name of the SharePoint list.
  • Id: Select the item Id of a SharePoint list.
  • Event Post Date&Time: Here, I have given Converted time from dynamic content.
Power Automate convert time of SharePoint time zone format

4. Now, click on Save and Test. Select Manually and test it. Then open the SharePoint list, which displays the output according to the Convert time zone action.

Convert SharePoint time format using Power Automate

This is how Power Automate Convert time in SharePoint List using Convert time zone action.

Conclusion

I hope you find this Power Automate tutorial helpful. I have discussed how to convert UTC to local time using the Convert time zone action and how to convert UTC to local time using the ConvertFromUtc() function.

Moreover, I have explained how Power Automate converts time in a SharePoint list using the Convert time zone action.

Also, you may like some more Power Automate tutorials: