Parse email content

[brownoNCYFL]

Hi,

I've been reading various guides, but i'm unable to extract an email address from the body of an email. The email comes in the same format each time - example below

<p>This email has been automatically generated by the contact message system as your preferences are set to receive an email copy. Please sign in to the system to see your message sent by:

Sent By: Chris Brown
Email Address: my.email@email.co.uk


This communication contains information which is confidential, which may be privileged, and which is for the exclusive use of the intended recipient(s).
</p>

I'm trying to extract the text after 'Email Address: ' but don't seem to be able to.

Any ideas?

Thanks 

[Expiscornovus]

Hi @brownoNCYFL,

If it is always the same format you can use a couple of split functions in an expression to extract that e-mail address.

Below is an example of such an expression:

split(split(outputs('Compose'), 'Email Address: ')[1], 'This communication contains information which is confidential')[0]

[brownoNCYFL]

Hi @Expiscornovus

Have just tried that on a Compose, but i'm getting the following error...

Unable to process template language expressions in action 'Compose_3' inputs at line '1' and column '23179': 'The template language function 'split' expects its first parameter to be of type string. The provided value is of type 'Object'. Please see https://aka.ms/logicexpressions#split for usage details.'.

[Expiscornovus]

Hi @brownoNCYFL,

What actions are you using in your setup, can you share a screenshot?

The code snippet I shared was just an example, it definitely needs to be changed before it works in your setup. 

[brownoNCYFL]

Sure, here's the setup...

Thanks,

[Expiscornovus]

Hi @brownoNCYFL,

You could use the outputs of the HTML to text action.

The expression would be:

split(split(outputs('Html_to_text')?['body'], 'Email Address: ')[1], 'This communication contains information which is confidential')[0]

[brownoNCYFL]

Thanks for your help again, I'm still getting an error though...

[Expiscornovus]

Hi @brownoNCYFL,

First of all I made a small typo in my previous post. I changed this in the expression from outputs('Html_to_text') to outputs('Html_to_text')?['body']

Secondly, can you expand that html to text action from your last flow run and check if the plain text content field contains the data you are expecting?

[brownoNCYFL]

Thanks again @Expiscornovus, I've tweaked it and attached the error below. 
Also added the html to text output

[Expiscornovus]

Hi @brownoNCYFL,

I think we are getting closer to the solution 😁

It looks like the first split function can't find 'Email Address: ' string. Maybe we need to try to only use 'Address: '.

Can you try this new expression:

split(split(outputs('Html_to_text')?['body'], 'Address: ')[1], 'This communication contains information which is confidential')[0]

[brownoNCYFL]

Thanks again @Expiscornovus.

That's worked sort of! It's got the email address at the start, but kept the footer there... How can we strip out the text after the email address to be just left with the email address?

[brownoNCYFL]

I have fixed it!

split(split(outputs('Html_to_text')?['body'], 'Address: ')[1], ' This')[0]

Thanks for all your help.