Email me with a list of upcoming Calendar events template not showing correct time

[phanley]

I'm using the "Email me with a list of upcoming Calendar events" power automate template and it's able to pull get the calendar events with the correct time (but wrong timezone). I've tried to convert the Start and End times to Eastern using 'convertTimeZone' function but can't get to replace the original times in the array and into the html table in the email.

However, simply using the template doesn't function properly. Example below shows "Start": "2022-08-15T17:00:00.0000000+00:00" 

Then when it's put into an HTML Table, the time gets converted incorrectly as "StartTime": "2022-08-15T05:00:00",

Ideally, I'd like to get these times in Eastern Standard Time

[phanley · Accepted solution]

Nevermind, I figured it out where to update the variable with the convertTimeZone function.

[v-yujincui-msft]

Hi @phanley ,

Glad to see you figured it out. 

Maybe you could consider marking your reply as a 'Solution' so that it will be useful for others and close the case. 

Best Regards, 

Charlie Choi