Answered

How can I set a 24H format time?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello everyone,

We created a flow which reads lists from Sharepoint. This lists contains some columns that are dates and times (in 24H and in LT).

So, we have to convert this dates and times to UTC time and insert this converted time in an email. The problem is that the time sent via email is in 12H format.

As using 12H format for UTC times can lead to confussion, how can we solve this problem, so that the time sent in the email is in 24H format?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-yamao-msft Microsoft Employee on at

Like (3)

Report
Copy link

Link copied!
Hi @Anonymous,

Please try to use the following code to format the Date and time to 24H format.

formatDateTime(triggerBody()?['OData__x006a_c67'],'yyyy-MM-dd HH:mm:ss')

Hope it could be a reference for you.

Best regards,

Mabel Mao

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you so much!!

It was very useful for me

Was this reply helpful? Yes No