Extract info from mail

[Mimi123]

Hi all,

I would like to extract the data from my email into variables so that I can store it in an excel sheet. Each mail has the same format. It could be that one or more items are empty

This is what I did until now:

1. When an email arrives (V3)
2. Html to text - with the body of the email V3 as content
3. Compose email to body text - with the body of the html to text
4. I initialised all my variables (VarDescription who’s a string, VarNumber who’s a integer, VarBool who’s a Boolean, etc)

when I run the flow, the output of my Html to text is as follow: 

Description : lorem ipsum 

number: 22 

etc 

Now I need to extract the data and store in the variable but none of the expression I used till now are working. I also need to save the data into an excel sheet.

Any suggestions ? 🙂

[VishnuReddy1997]

Hi @Mimi123 ,

Please follow these steps if you want to build your solution in cloud flow.

1.Initialize your variables: You’ve already done this step. Just make sure that the type of each variable matches the type of data you’re expecting (e.g., string for text, integer for numbers, etc.).
2.When an email arrives (V3): This is your trigger. You’ve set this up correctly.
3.Html to text: This action converts the body of the email from HTML to plain text. You’ve set this up correctly.
4.Compose email to body text: This action stores the output of the “Html to text” action. You’ve set this up correctly.
5.Parse the text: This is where you’ll extract the data from the email. You can use the split function to separate the text into different parts based on a delimiter (like a colon or a newline).

For example, if your email body is in the format “Description: lorem ipsum”, you can use the following expression to extract the description:

split(outputs('Compose_email_to_body_text'), ':')[1]

This will split the text at each colon and return the second part (the description). You can do this for each piece of data you want to extract.

6.Set variable: Use the “Set variable” action to store the extracted data in your variables. For example, you can set VarDescription to the result of the split function above.
7.Excel - Add a row into a table: Finally, you can use this action to add a new row to an Excel table with the data stored in your variables. You’ll need to specify the location of the Excel file and the name of the table, and then you can set each column to the corresponding variable.

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards

Vishnu Reddy

[Deenuji]

@Mimi123 

You want to achieve this in cloud flow or desktop flow?

[Mimi123]

Hi @VishnuReddy1997 

Thanks for your reply!

I followed all the steps and I see now the value of the variables. I remarked that the output of each variable contains always the name of the following column after the output that I don’t need to see.

E.g: how my output should be

• Description: Lorem ipsum
• Number: 22

This is what I get in the output:

• Description: Lorem ipsum    Number
• Number: 22          Code
• Code: 123, etc

When I’m trying to fill the excel sheet with the variables, the flow fails and it gives me the status 409. I think it’s because there is like 2 values stores is that possible?

[VishnuReddy1997]

Hi @Mimi123 ,

Please follow this link,you will get a better idea.

https://www.youtube.com/watch?v=uGB95lAze2E 

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards

Vishnu Reddy