Power Automate - Translation Quality Feedback

I get not the local time from the automate back

(0) Share

Report

Posted on by frixel

921

Hello,

I have the Power Automate below but I don't get the correct local time in the Excel table.

The correct time is in the received message but as soon as it goes through the Power Automate I have an incorrect time in the sheet.

What can I change?

Categories:

General

I have the same question (0)

All responses (8)

Answers (0)

Chriddle 8,083 Super User 2025 Season 2 on at

Like (0)

Report

I get not the local time from the automate back

Just replace utcNow() with triggerBody()?['DateTimeReceived'] in your expression.

Was this reply helpful? Yes No
frixel 921 on at

Like (0)

Report

I get not the local time from the automate back

I can do this

convertTimeZone(utcnow(),'UTC','W. Europe Standard Time','dd/MM/yyyy HH:mm:ss')

in the expression what is working with the right time and date in the Excel sheet

But than it takes NOT the time that the eMail is received.

Was this reply helpful? Yes No
Suggested answer

David_MA 12,236 Super User 2025 Season 2 on at

Like (0)

Report

I get not the local time from the automate back

I believe your problem Is caused because your expression is not valid. The expression needs to include T in the expression: addHours(triggerBody()?['DateTimeReceived'],'yyyy-MM-ddTHH:mm:ss')

Was this reply helpful? Yes No
frixel 921 on at

Like (0)

Report

I get not the local time from the automate back

When i do this then i get the right time

addHours(triggerBody()?['DateTimeReceived'],1,'dd-MM-yyyy HH:mm:ss')

So i think i must

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

combine with

utcnow()

is that what it is, i don`t know how to do that

Was this reply helpful? Yes No
frixel 921 on at

Like (0)

Report

I get not the local time from the automate back

i don`t understand 😢

When i don`t use the '2' in:

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

then i get this error

Was this reply helpful? Yes No
Chriddle 8,083 Super User 2025 Season 2 on at

Like (0)

Report

I get not the local time from the automate back

The error is from the addHours() function and it states that the datetime value is null.

This shouldn't happen. Are you sure that you are processing triggerOutputs()?['body/receivedDateTime']

Furthermore

Why do you still add 2 hours?

Why do you convert utcNow() to local time. Isn't this about triggerOutputs()?['body/receivedDateTime']?

Was this reply helpful? Yes No
frixel 921 on at

Like (0)

Report

I get not the local time from the automate back

Hi @Chriddle

Now i get this.

But i get then this error.

Was this reply helpful? Yes No
Chriddle 8,083 Super User 2025 Season 2 on at

Like (0)

Report

I get not the local time from the automate back

The date probably is in UTC.
Use convertFromUtc() to convert to your local time zone.

If the according Excel column is formated as DateTime, don't use a format string but set the Excel connector's DateTime Format to ISO 8601 (in the connector's advanced options) and set the values display settings within Excel.

Was this reply helpful? Yes No