Display datetime-local value in flow email action

Like (0) Share

Report

Posted on 31 Aug 2022 09:01:33 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 01 Sep 2022 at 06:45:58

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
Srinivas Kadamati 3,150 Super User 2025 Season 1 on 31 Aug 2022 at 13:17:26

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