Power Automate

I get not the local time from the automate back

(0) Share

Report

Posted on by frixel

1,004

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:

Translation quality feedback

I have the same question (0)

All responses (8)

Answers (0)

Chriddle 8,523 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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
frixel 1,004 on at

Like (0)

Report
Copy link

Link copied!

Hi @Chriddle

Now i get this.

But i get then this error.

Was this reply helpful? Yes No
Chriddle 8,523 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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 1,004 on at

Like (0)

Report
Copy link

Link copied!

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
frixel 1,004 on at

Like (0)

Report
Copy link

Link copied!

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
Suggested answer

David_MA 13,489 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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 1,004 on at

Like (0)

Report
Copy link

Link copied!

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
Chriddle 8,523 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No