Display datetime-local value in flow email action

(0) Share

Report

Posted on by David_Nguyen_vn

Hello guys,

I have input value from html<input type="datetime-local>

example 2022-09-03T15:43+07:00

After saving it to dataverse, it is converted to UTC timezone. Now I need to display it to local user in format

9/3/2022 3:43 PM or

3 Sep 2022 3:43 PM

I tried to use convertfromUTC expresstion and ConvertTimeZone action but it requires destination to be text not UTC+7:00 format. I do not want to select it manually as user might come from other timezones.

Thinking of using addHour expression but it requires interval to be integer. How if the user is in timezone with +5:30 ?

Hope any solution for displaying the datetime-local value in format:

9/3/2022 3:43 PM or

3 Sep 2022 3:43 PM

Thank you

All responses (2)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (0)

Report

Re: Display datetime-local value in flow email action

Hi @David_Nguyen_vn ,

Thinking of using addHour expression but it requires interval to be integer. How if the user is in timezone with +5:30 ?

You could use addMinutes instead.

Best Reagrds,

Bof
SriniK 3,025 Super User 2025 Season 1 on at

Like (0)

Report

Re: Display datetime-local value in flow email action

Hi @David_Nguyen_vn

Try as below

formatDateTime(utcNow(),'MM/dd/yyyy H:mm tt')

Thanks,
Srini