How to extract date and time stamp of specific emails received in Outlook automatically and populate data in Excel File ?

(0) Share

Report

Posted on by memento

I have checked the following and tried to incorporate them:

Solved: Re: Create a Flow when email body contain a specif... - Power Platform Community (microsoft.com)

Solved: Re: Extract an Email Received Date/Time and Update... - Power Platform Community (microsoft.com)

but I am stuck - how to i get the action name for "Extract the date and time of the email received" ?

condition: The emails received with specific words

and with those emails, extract:

- the date and time received

- from (sender)

- message subject

- Size of message

and place the above information in an excel file that is in sharepoint site.

This is the current skeleton of my flow

Categories:

Building flows

I have the same question (0)

All responses (16)

Answers (0)

Ellis Karim 11,985 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

HI @memento ,

Search for the Received Time property. In the example below the Received Time property is being stored in a Compose action:

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

Was this reply helpful? Yes No
memento on at

Like (0)

Report
Copy link

Link copied!

Thanks @ekarim2020
This is what i did, the flow ran successfully but nothing was added to my excel table:

The message :
But in the email test message, I did include the following statement "Pertaining to the below complaint,"
What went wrong ?

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @memento ,

Regarding the format of line breaks in the body of an email, I suggest you split each word into.

I did a test for your reference.

My Excel Table:

My Flow:

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
memento on at

Like (0)

Report
Copy link

Link copied!

Thanks @v-yetonggu-msft it works now.

But how to just show the date only under Date Received
and also time only in local time under Time Received?

Desired Output
Date Received = 2024-06-24
Time Received = 11:24

Thanks.

Was this reply helpful? Yes No
memento on at

Like (0)

Report
Copy link

Link copied!

Hi

I have managed to resolve the date and time part:

formatDateTime(utcNow(),'yyyy-MM-dd')
formatDateTime(utcNow(),'hh:mm')

But the time is incorrect.
How do I convert the time to local time?

Was this reply helpful? Yes No
memento on at

Like (0)

Report
Copy link

Link copied!

I checked this
Reference guide for expression functions - Azure Logic Apps | Microsoft Learn
and
Default Time Zones | Microsoft Learn

But I can't seem to get right syntax to convert the time.

Please help !

Was this reply helpful? Yes No
memento on at

Like (0)

Report
Copy link

Link copied!

Refering to Default Time Zones | Microsoft Learn

I tried to change:
formatDateTime(utcNow(),'hh:mm')

to
formatDateTime(utcNow(),'hh:mm', 'Singapore Standard Time')

and the error states the locale time cannot be found. But i checked "Singapore Standard Time" is found in the table in Default Time Zones | Microsoft Learn

So what have i typed wrongly ???

Was this reply helpful? Yes No
memento on at

Like (0)

Report
Copy link

Link copied!

Hi @ekarim2020 @v-yetonggu-msft any advice for the above questions on conversion in the time extraction ?
Thanks

Was this reply helpful? Yes No
memento on at

Like (0)

Report
Copy link

Link copied!

And how to get the text of the body from the email?
I tried to find dynamic content 'text' but it's not available.

As i use Body
the output in excel turns out to be all HTML codes.

any idea ?

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @memento

Expression you have used is wrong - it should be like this

convertFromUtc(utcNow(),'Singapore Standard Time','hh:mm')

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No