Power Automate - Translation Quality Feedback

I get not the local time from the automate back

(0) Share

Report

Posted on by frixel

901

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

All responses (8)

Answers (0)

Chriddle 7,839 Super User 2025 Season 1 on at

Like (0)

Report

I get not the local time from the automate back

Just replace utcNow() with triggerBody()?['DateTimeReceived'] in your expression.
frixel 901 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.
Suggested answer

David_MA 11,661 Super User 2025 Season 1 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')
frixel 901 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
frixel 901 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
Chriddle 7,839 Super User 2025 Season 1 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']?
frixel 901 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.
Chriddle 7,839 Super User 2025 Season 1 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.