Problem with converting the time zone

(1) Share

Report

Posted on by CU01071350-0

Hello everyone,

I am currently using the connector to convert to a time zone. As far as I know, I have entered everything correctly, but I am still getting the time in the wrong format.
The desired time is Tuesday, 02.07.2024 09:00 but the output is
"Tuesday, July 2, 2024 9:00 AM"

Best regards

Toebses

Screenshot 2024-07-01 154605.png Screenshot 2024-07-01 154625.png

Categories:

Using flows

All responses (4)

Answers (0)

Sort by

Ellis Karim 12,344 Super User 2026 Season 2 on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @Toebses ,

Try a custom format string:

dddd, dd.MM.yyyy HH:mm

See: Custom date and time format strings - .NET | Microsoft Learn

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site
Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Toebses,

Convert time zone using converttimezone() function:

Syntax

convertTimeZone(<<timestamp>>, <<sourceTimeZone>>, <<destinationTimeZone>>, <<format>>)

Example:

convertTimeZone(utcNow(), 'UTC', 'W. Europe Standard Time', 'f')

Regards

Kaif
Töbses 2 on at

Like
a
(1)

Report
Copy link

Link copied!

Hey @ekarim2020,
thanks the output is now correct, but my next step failed.

Wanted to change the template "Find a meeting time" only to German, but somehow there are many problems
Ellis Karim 12,344 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @CU01071337-0 ,

To use a Date/Time value in the "Fine Meeting times" and other similar actions, the date time needs to be in 8601 format: YYYY-MM-DDThh:mm:ss (e.g., 2024-07-08T14:30:00).

I suggest trying the following:

The compose action uses the following expressions:

formatDateTime(body('Convert_time_zone'),'dddd, dd.MM.yyyy HH:mm')

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site