Answered

How to convert SharePoint 'created' column's time zone in power automate flow and show the output correctly in the email?

(0) Share

Report

Posted on by NewSPuser

Hi,

I am sending email when a sharepoint list item is entered. The email includes ‘created’ which is by default UTC time zone in power automate flow. I have used convert time zone. It is converting correctly but the email is still showing the record in UTC format. How can I show the output correctly in the email ?

TIA!

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (1)

NewSPuser 22 on at

Like (1)

Report
Copy link

Link copied!

Thank you wskinnermctc! It worked perfectly. I needed to convert it before composing the table.

Was this reply helpful? Yes No
Verified answer

wskinnermctc 6,519 Moderator on at

Like (2)

Report
Copy link

Link copied!
With your current flow, you are attempting to convert the time zone of an Excel value and it has nothing to do with the HTML table.

You need to convert the timezone before or when it is getting put into the HTML table.

You will need to make the HTML custom columns and then convert the timezone with an expression.

Here is a quick example, you should be able to use the expression with your time zone.
ConvertFromUtc SharePoint Created Time

Here is the expression to use. I put in your timezone after checking your photo.
convertFromUtc(item()?['Created'],'Eastern Standard Time','MM/dd/yyyy hh:mm tt')

Let me know if this works for you

Was this reply helpful? Yes No