web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details
Power Automate - General Discussion
Answered

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

Like (0) ShareShare
ReportReport
Posted on 30 Dec 2021 13:56:15 by 26

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.

  • Verified answer
    mahoneypat Profile Picture
    1,720 on 30 Dec 2021 at 14:17:05
    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')

     

    mahoneypat_0-1640873781947.png


    Pat

     

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete