Answered

Multiple UTC Times to EST

(0) Share

Report

Posted on by jbushaw1498

I currently have a flow set up to pull from my Sharepoint site and then put it into an HTML Table, and then email that table. The issue I am having is that because timestamps are stored in UTC, I need to convert it to EST. I have tried converting it but the issue is that one of the dynamic values from the Sharepoint site sometimes result in more than one UTC Timestamp in the "Issue Date" field (sometimes we have more than one issue that is reported through the SharePoint site.) When I have it pull just the Issue Date and create output, then have the Convert Time Zone function convert from that output, it errors out because there's more than one timestamp at a time. Any suggestions?

Categories:

Using flows

All responses (5)

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @jbushaw1498 :

I've made a test for your reference:

1\My SP list:

2\Site Setting

3\My flow

The Result:

Best Regards,

Bof
jbushaw1498 12 on at

Like
a
(0)

Report
Copy link

Link copied!

New issue. The timestamp now shows as 5 AM for one of the timestamps. It should read 6 AM. How do you fix this? Can EST take place of the -5?
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @jbushaw1498 :

Q:The timestamp now shows as 5 AM for one of the timestamps. It should read 6 AM. How do you fix this?

A:This is related to the region set on your site. Actually the local time (the area of the site) is stored in your SP list. When flow reads the time, it will automatically convert it to UTC time.

Because the area of my site is set in the UTC0 time zone, you can get the EST time by setting the time directly to -5.

Q:Can EST take place of the -5?

A:No,you could try -4

Best Regards,

Bof
jbushaw1498 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks so much for the help. Would you by chance know how to modify it so : will show up as : and not &#58 in the HTML table?
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @jbushaw1498 :

Some characters are reserved in HTML.

If you use the ": " in your text, the browser might mix them with tags.

This list details the code positions and characters of the HTML document character set, specified in section SGML Declaration for HTML. This coded character set is based on [ISO-8859-1].

I think this link will help you a lot:

https://www.w3schools.com/html/html_entities.asp

Best Regards,

Bof