Extract text from Body of an email in Flow

[mark-carlisle]

I want to extract information from the body of an email and populate fields in a SharePoint. An extract of the email is follows;

Details

------------------------------------------------------------

Account Number 99999999

Contact Name Mr A N Other

Email example@domain.com

Telephone 0123456789

Incident Reference XXXXX-XXXXX

I'm using the expression;

substring(body('Html_to_text'),lastIndexOf(body('Html_to_text'),'Account Number '),8)

Which is just populating the SharePoint field with 'Account ' whereas I actually want it to populate with '99999999'. I've tried a few different things to try and add on a value to the lastindexof value but I'm running into various errors.

Any suggestions would be appreciated.

Thanks

[Jrivera1]

Good morning, I need help extracting text from the body of an email in Flow and populate fields in SharePoint.  The data we need is the Agent's Name.  We are currently using Flow to generate request tickets in SharePoint.  can anyone help with this?  An extract of the email is below:

Agent's Name: Donna Keena

Date of Request: 06/11/2019

Property Address: 17 Park Street, BELLEVILLE, NJ 07109 US

Type of Property: House

Underground hazards present: None Known

If Yes, Type of hazard?:

Sign Type: Sign Panel Only (No Post)

Location to Install Sign: See Special Instructions

Special Instructions: Please remove sign post.

(Sent via Special Properties Christie's)

[Anonymous]

Hi @Jrivera1 I have had the same challenge and managed it bu using Flow in this way:

I created a flow where i used the HTML to text action, and took the content of the mailbody in there. Then i created an expression like this:

substring(body('html_to_text'),add(lastIndexOf(body('html_to_text'),'Link:'),32),4)

I needed a link in the mail, and knew taht it always after the word "Link". The it was just a matter of counting (32 and 4) and voila, i got the link i needed. I think this is nearly the same. Make the expression return anything between "Agents name" and "Date of Request" and i think you can get what you need.

/Frank

[Anonymous]

Hi, i use this for extract specyfic text line from body of email and it works,

  substring(body('html_to_text'),add(lastIndexOf(body('html_to_text'),'monitorowania:'),15),20)

But i also have a problem. Text has random lenght from 10 to 20 letters.

How cut it on first blank space after text that i extracting?

[Ronny]

U can use the (indexOf(the text after extract text)-indexOf(extract text)) as your lenght in the substing function

[MarekZ1]

You mean something like this?

substring(body('html_to_text'),add(lastIndexOf(body('html_to_text'),'monitorowania:'),15), (indexOf(‘ Plan’)-indexOf(lastIndexOf(body('html_to_text'),'monitorowania:'),15)))

if i want extract

UE878389107YP

from this

monitorowania: UE878389107YP 
Plan

Im beginner and learn myself when i see real working samples ☹

[MarekZ1]

working

last(split(first(split(body('html_to_text'),'test2')),'test1'))

 extract 2345 where string is 'test12345test2'

[Sgarmonsway]

I'm not sure if anyone here is still around and can help me. I have emails that arrive with a block of text like this;

Billing Address

Billy Bob

22 Apple Road

Christchurch, 1234

New Zealand

I'm trying to create an expression to get just the name from this block of text e.g. "Billy Bob". My issue is that A) the names will contain different amounts of letter each time. B) that the name always comes after the word "Billing Address" but before the street address which will be a different address each time.

[b_benn1983]

Hello - the body of my email is set up a little differently. Instead of having the field and values go left to right, my values are listed below each field. I get 6 rows of data, across 3 column fields as seen below as an example. I would like each row to insert a new row into excel if possible. I think I would have to do the "Add a row into a table" in my flow for each of these rows below, which is fine I am just getting stuck on how to get the top row of values AS, 57, 57 into a row in excel.

File	Recv'd	Matched
AS	57	57
CR	12	12
HT	17	13
IN	41	41
PS	41	41
XU	285	285