Date and Time Format when an email is received in Outlook.

Like (0) Share

Report

Posted on 30 Dec 2021 13:56:15 by jayzone

Hi,

I manage to create a flow with Outlook to Excel.

I have a flow were once an email is received it will send the Date and Time to the Table by adding a row.

The problem I'm having is the format of Date and Time.

I was trying to format the date and time the email was received (ex: Col A - January 01, 2022 Col B - 08:00 AM) . I have followed other steps from other discussions here but nothing seems to work.

My flow is when an email arrive add a row into a table then on that row I have dynamic content of Received Time.

Is there anything I'm missing here? Thank you.

All responses (2)

Answers (1)

jayzone 26 on 04 Jan 2022 at 09:31:58

Like (0)

Report

Re: Date and Time Format when an email is received in Outlook.

Hi Pat,

Thank you very much for your response.

I am new with Power Automate. I follow what you have advised and it was working but if I have the Dynamic content added next to the Expression, the content is captured as well in my spreadsheet so its's now double, if I remove the Dynamic content then the format is also removed.

What I'm trying to achieve is when a new email arrive the Received Date and Time will be added in a new row in a spreadsheet.

Also is it possible to separate the Date and Time on a column?

Thank you.
Verified answer

mahoneypat 1,720 on 30 Dec 2021 at 14:17:05

Like (0)

Report

Re: Date and Time Format when an email is received in Outlook.

You should be able to use an expression like this to get the result shown. What issue are you seeing?

formatDateTime(triggerOutputs()?['body/receivedDateTime'], 'MMMM dd, yyyy hh:mm:ss')

Pat