How to extract values from a outlook email and save this values in excel table?

(0) Share

Report

Posted on by AnyeloSalinas3

I want to extract a specific values from a outlook email and put this values in a excel table.

I have the steps "when the email arrives" and the step in order to put "data in a excel table".

But I dont found an adequate ACTION bettewen this two steps, in order to obtain the values inside the outlook email

Flow Flow

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

fchopo 8,003 Moderator on at

Like (1)

Report

Hello @AnyeloSalinas3

Have a look at this thread: https://powerusers.microsoft.com/t5/Building-Flows/Read-email-content-from-body-of-the-email-extract-and-create/td-p/87093
As it shows how to extract content from the body of the email.

Hope it helps!
Ferran

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (1)

Report

Hi @AnyeloSalinas3 ,

Could you provide examples of the content contained in the Email body so that we could provide you with the appropriate expression to extract the data contained in the body?

If the email body has a fixed format, maybe you could refer to the following similar threads to extract data:

Extracting-text-from-email

Extract-text-from-body-of-an-email-and-create-new-rows-in-excel

Best Regards,

Was this reply helpful? Yes No
AnyeloSalinas3 4 on at

Like (0)

Report
Thank you I reuse these steps only in compose 1 and 2.
I already inserted information in my excel sheet but it returns only numerical values, I do not return the text
I guess those numerical values are the location of the fields?

Was this reply helpful? Yes No
ramya0205 6 on at

Like (0)

Report

HI can you help me with the below
i need a email tracker using power automate from outlook to excel.
The following rows to be filled like Email received date, subject, from, to, Replied to date and time.
for replied to date and time row should be filled only if the email is replied back
whenever a new email arries it should be updated in the excel like received date, subject, from , to.
only we started to receive more the excel should get automatically filled example- if we get 10 emails for today it should be filled in the excel. if i replied only 2 emails then the last row Replied date and time column should be filled with the exact time( in the outlook it mentioned) i replied else it should be null.
below are the attached one i created, from which i get the email received date, from to, subject.

image1.PNG

image 2.PNG

Was this reply helpful? Yes No