Unanswered

Parse email content

(0) Share

Report

Posted on by 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

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (0)

Sort by

Expiscornovus 33,851 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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]

Was this reply helpful? Yes No
brownoNCYFL 14 on at

Like (0)

Report
Copy link

Link copied!

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.'.

Was this reply helpful? Yes No
Expiscornovus 33,851 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
brownoNCYFL 14 on at

Like (0)

Report
Copy link

Link copied!

Sure, here's the setup...

Thanks,

Was this reply helpful? Yes No
Expiscornovus 33,851 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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]

Was this reply helpful? Yes No
brownoNCYFL 14 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Expiscornovus 33,851 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
brownoNCYFL 14 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Expiscornovus 33,851 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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]

Was this reply helpful? Yes No
brownoNCYFL 14 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No