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

[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

[fchopo]

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

[v-bacao-msft · Accepted 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:

Extracting-text-from-email

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

Best Regards,

[AnyeloSalinas3]

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?