Answered

Help with Time Conversion in Email.

(0) Share

Report

Posted on by JeffC

Hello,

I built a flow that sends an email and in the email it has the time and date that is coming from a SharePoint list. However, in the email the time is showing incorrectly and I have tried multiple ways to resolve this but can't.

The ConvertTimeZone conversion in my flow seems to be working properly (see below) but it isn't flowing through to the email correctly (UTC to EST)

I then create a variable to convert the time from an unfriendly view to more friendlier view.

Variables Below

Then in the email I create a dynamic query based off of the varDate variable.

formatDateTime(variables('varDate'),'f')

At this point, below is the time that shows up in the emai which is 7 hours behind which isn't UTC or eastern time (I am in EST)

Example Email
My name is XXX and I will be conducting your IT Orientation on Monday, June 20, 2022 4:22 PM.

The time is actually 7 hours ahead of the time I have in my sharepoint list.

So at this point in the beginning of the flow the convertimezone is changing it time correctly by 4 hours. However, when I try to modify the time in the email it shows 7 hours difference.

Any thoughts that anyone has would be greatly appreciated!

Jeff

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

JonDoesFlow 1,304 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey Jeff,

Shouldn't the vardate, be set to the value of the output of the converted time zone ?

Was this reply helpful? Yes No
JeffC on at

Like
a
(0)

Report
Copy link

Link copied!

But the vardate value is set to the orientation date column in sharepoint. If I remove it and add in the converted time into the value then what does the expression look like in the email?

Was this reply helpful? Yes No
JonDoesFlow 1,304 on at

Like
a
(0)

Report
Copy link

Link copied!

Shouldn't you in that case, be doing the conversion of the date on the orientation date, not UTCNOW ?

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @JeffC ,

I have made a simple test on my side. Maybe you could try as follows.

Result Screenshot:

In addition, maybe you could considering using the addHours() function.

addHours(items('Apply_to_each')?['ColumnName'],-8,'f')

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
JeffC on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you very much for your response. I went at it a little differently by inititizing a date/string variable, set a variable to the SharePoint column, created a compose with the date and time format I wanted, and then did a subtract from time.

Thank you again,

Was this reply helpful? Yes No