web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Convert time stamp to ...

Power Automate

Unanswered

Convert time stamp to european time format

(0) Share

Report

Report

Posted on by SveinT83

14

i am seting up an SMS remainder from Outlook calendar, to my customers.

Im converting timezone whitout problem, but the time is showing like this: "12/16/2019 8:00 AM"

i need it to be convertet to: "16/12/2019 08:00"

Can any help?

Categories:

I have the same question (0)

All responses Img

All responses (6)

Answers Img

Answers (1)

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report
You can use a custom format string with your converted date time to format it the way you want. Here's an example

formatDateTime(utcNow(),'dd-MM-yyyy H:mm:ss')

Was this reply helpful? Yes No
SveinT83 14 on at

Like (0)

Report

Thanks. Can i chanche the "utcnow" to what i hawe in the calendar? i the calendar event is in the futore, this output shows todays date and time.

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

Yes, you should be able to just substitute the date time string you are generating for the UTCNow(). That was just a quick example to test that it works.

Was this reply helpful? Yes No
SveinT83 14 on at

Like (0)

Report

I dont understand what to change "UTCnow" to, in order to format the time.

I did try:
formatDateTime(Test(),'dd-MM-yyyy H:mm:ss

Was this reply helpful? Yes No
Verified answer

SveinT83 14 on at

Like (0)

Report

I got the suluton 🙂

In an "Compose" i put this code: "@formatdatetime (body('tf'),'dd-MM-yyyy hh:mm' )"

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (1)

Report

You can just use the Enter Custom Value in the time string of the Convert timezone action and paste in the custom format string there. That will automatically do the formatting when you convert. Then you won't need an extra compose or FormatDateTime function.

Was this reply helpful? Yes No

Join the conversation