Extracting number from email body (number in a table)

[edmundwtan]

Hello, this is a complicated one (for me). I get an email that has a table in the body of the email that contains a store number. I would like to extract this number out and put it in an excel file (add row function)

Table looks like this:

Period:	Period 13 Ended January 1/2022
Store #: Please input a four digit store number (eg. 0013)	1170
Associate Name:	John Smith
Associate Email:	xyz@xyz.com
DM Email:	abc@abc.net

The "1170" is what I'm trying to extract.

Alternatively, I can also do an "if contains... 1170"... add row condition. 

Email looks like this: as you can see not in a neat format. 

[v-jefferni · Accepted solution]

Hi @edmundwtan ,

Based on your need I made a demo flow for your reference:

My test email body:

The flow:

Expression:

split(outputs('Html_to_text')?['body'],outputs('Compose'))?[11]

Test result:

So you could test in Html to text step to find the row of the number you need.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[edmundwtan]

Wow that works perfectly. Thank you so much. 

Out of my own curiousity - what is the purpose of the compose (new line)?

[v-jefferni]

Hi @edmundwtan ,

It was just trying to get the newline character (like Char(10) or Char(13), Enter, whatever) in string to use in variable step.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[darkhorse12]

Hello,

I am New to Power Automate,

Can you please help me with,

Hello Xyz,

Your Receipt # 121232 is your order .

Task: When i receive mail, it should create file in one drive, with name #121232(it has multiple numbers), But we have to save file like this only,

can you please helm me.

Thank you