Others

How to Display a Converted SharePoint Created Date in Power Automate Emails

Anum Mushtaq Oct 15, 2026 868 views

Question details

The user wants to format and display a SharePoint Created date in a local time zone rather than UTC within an outgoing Power Automate email.

How to Display a Converted SharePoint Created Date in Power Automate Emails

Product: Microsoft Power Automate and SharePoint
Device & OS: not provided
Scenario: Configuring a Power Automate flow to send an email notification when a new item is created in a SharePoint list, requiring the item's creation date to be shown in the user's local time.
Observed behavior: SharePoint Created values are stored in UTC by default. When inserting the dynamic content directly into the email action, it ignores any intended time-zone conversion and displays the original UTC timestamp.

Before you start

Ensure you have edit access to the specific Power Automate flow and know the exact target local time zone you wish to display in your emails.

Solution 1Recommended

Use the 'Convert Time Zone' Action in Power Automate

This is the most straightforward method to ensure the correct local time is passed to your email body, avoiding the default UTC SharePoint format.

Power Automate processes SharePoint dates in UTC. To fix the email output, you must explicitly convert the time before the email action and ensure you reference the newly converted data, not the original SharePoint field.

Add a new step

Open your Power Automate flow. Click 'New Step' right before your 'Send an email' action.

Select Convert time zone

Search for 'Convert time zone' in the action search bar and select it.

Configure the time conversion

In the 'Base time' field, insert the 'Created' dynamic content from SharePoint. Set 'Source time zone' to '(UTC) Coordinated Universal Time' and 'Destination time zone' to your local time zone. Choose your preferred 'Format string'.

Update the email body

Open your 'Send an email' action. Remove the original 'Created' dynamic content from the email body. Instead, insert the 'Converted time' dynamic content generated by the 'Convert time zone' action.

Use the 'Convert Time Zone' Action in Power Automate

Verification: Test your flow by creating a new SharePoint item. The outgoing email should now display the date and time matching your specified local time zone.

Solution 2

Consult the Power Automate Community

If complex flow logic prevents the standard time conversion from working, specialized guidance from the Power Automate Community may be required.

Free Microsoft Office alternative

Boost Your Daily Productivity with WPS Office

While Microsoft Power Automate and SharePoint are great for complex enterprise workflows, your daily document creation shouldn't be overly complicated. WPS Office provides a free, lightweight, and user-friendly alternative to Microsoft Office for all your Word, Excel, and PowerPoint needs.

1. Download the Installer: Visit the official WPS Office website and click the free download button for your operating system.
2. Install WPS Office: Run the downloaded installation file and follow the brief on-screen instructions.
3. Open Your Files: Launch WPS Office to instantly open and edit your existing Microsoft Office documents without formatting loss.

Fully compatible with Microsoft Office formats (.docx, .xlsx, .pptx)Lightweight application that runs smoothly on almost any deviceFamiliar tabbed interface allows seamless transition with zero learning curveBuilt-in advanced PDF editing, merging, and conversion tools

microsoft office alternative - wps office

Frequently Asked Questions

Why does SharePoint always export the Created date in UTC?

SharePoint stores all date and time fields internally in Coordinated Universal Time (UTC) to maintain data consistency across global servers and users in different time zones. Power Automate retrieves this raw UTC data by default.

Can I use an expression instead of the Convert time zone action?

Yes. You can use the formatDateTime and convertFromUtc expressions directly within the email body's dynamic content box. For example: convertFromUtc(triggerOutputs()?['body/Created'], 'Eastern Standard Time', 'yyyy-MM-dd HH:mm').

Why is my email still showing the wrong time after adding the conversion step?

This commonly happens when you forget to update the dynamic content inside the 'Send an email' action. Ensure you delete the original SharePoint 'Created' field from the email body and replace it with the 'Converted time' output from your conversion step.

Office Quick Solutions