Answered

Incorrect date of email receipt

(0) Share

Report

Posted on by PW-05121753-0

I have recently noticed a small problem with my flow. I will describe it briefly.

After receiving a specific email with an excel attachment, the flow starts and downloads the file to the sharepoint folder, changing its name to "email receipt date" + file name.
Such a report is downloaded every hour. I have noticed that if the email is sent, for example, on 06.12.2024 00:18, the flow will show the date 05.12.2024 23:18.
I tried to bypass the error by using the UTC NOW variable, but the results are the same.

Has anyone had the same or a similar problem and found a solution?
Thanks in advance for your help.

Adding also pictures.

Categories:

Using flows

Flow started at.png

Output data.png

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

I think the issue you're experiencing is due to time zone differences between your email server, SharePoint, and Power Automate. By default, Power Automate works with UTC (Coordinated Universal Time), and this can lead to the time discrepancies you've observed.

The time shown in the email headers is likely in UTC or the server's local time.

Actions like utcNow() and time-related operations are in UTC unless explicitly converted.

To address this, extract the timestamp of the email and convert it to your desired time zone using the convertFromUtc() function.

convertFromUtc(utcNow(), 'Eastern Standard Time', 'yyyy-MM-dd HH:mm:ss')

Was this reply helpful? Yes No
PW-05121753-0 4 on at

Like (1)

Report

@SudeepGhatakNZ

Thank you very much for your answer. The convertFromUtc() function solved my problem.

Was this reply helpful? Yes No