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
Solved! Go to Solution.
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...
As it shows how to extract content from the body of the email.
Hope it helps!
Ferran
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,
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?



Check out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
13 | |
12 | |
9 | |
6 | |
4 |
User | Count |
---|---|
11 | |
10 | |
5 | |
4 | |
4 |