You’re offline. This is a read only version of the page.
4
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
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.
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?
Share
Report
All responses (
Answers (
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:
Extract-text-from-body-of-an-email-and-create-new-rows-in-excel
Best Regards,
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
#1
WarrenBelz
146,618
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,957
Most Valuable Professional
