HELP NEED TO EXTRACT TEXT FROM HTML EMAIL

(0) Share

Report

Posted on by sbruk89

157

Hi,

Im struggling to be able to extract text from an email that is in a weird HTML format from Openreach

Basically anything that appears after any word that is underlined blue, i want to extract the text that is underlined red. Due to the formating of the email it bunches words together etc

Any help would be greatly appreciated!

Categories:

Building flows

I have the same question (0)

All responses (13)

Answers (1)

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report

Re: ** HELP ** NEED TO EXTRACT TEXT FROM HTML EMAIL

Hi @sbruk89

You could try using xapth() function that can extract the data from well-formed xml or html text. You can refer the below link:
How to extract value from XML using Power Automate flow (tomriha.com)

I could try if it possible for you to share the html of email text 🙂 (pls mask the sensitive info).

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report

Re: ** HELP ** NEED TO EXTRACT TEXT FROM HTML EMAIL

Hi @sbruk89

I have designed a sample flow to parse the html that extracts the values using xapth() function. I hope it will help you in extracting the required values from the email body 🙂

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Parsehtmlusingxpa...

Was this reply helpful? Yes No
sbruk89 157 on at

Like (0)

Report

Re: ** HELP ** NEED TO EXTRACT TEXT FROM HTML EMAIL

Hi Manish,

Thank you so much that seems to work perfectly, although I require a small tweak. For B End Interface Type and B End Power, I don't need require the output to state "B End" or "- B End" as the compose already tells me what it is 😁

Was this reply helpful? Yes No
sbruk89 157 on at

Like (0)

Report

Re: ** HELP ** NEED TO EXTRACT TEXT FROM HTML EMAIL

sorry @ManishSolanki ,

Also noticed that the bandwidth is missing on the flow as well

Was this reply helpful? Yes No
sbruk89 157 on at

Like (0)

Report

Re: ** HELP ** NEED TO EXTRACT TEXT FROM HTML EMAIL

also, I only require the part of MDF ID :

So in this section i only require NINTH

Was this reply helpful? Yes No
Verified answer

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report
Re: ** HELP ** NEED TO EXTRACT TEXT FROM HTML EMAIL

Hi @sbruk89.

Here is the updated version of the flow. It will extract the bandwidth & trim 'MDF ID' field text. I have manually changed some value by appending "b end" to test the flow as those fields are also present in 'A end' section.

Pls replace "Manually trigger a flow" trigger action with when an email arrives and pass the html of email body so that flow will extract fields values for all received emails.

Add some filters in above action so that flow will trigger for the relevant email only else it will trigger for all incoming emails.

Expression used in above screenshot:

@{triggerOutputs()?['body']?['body']}

You can just copy & paste this expression in compose textbox.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Parsehtmlusingxpa...

Was this reply helpful? Yes No
sbruk89 157 on at

Like (0)

Report

Re: ** HELP ** NEED TO EXTRACT TEXT FROM HTML EMAIL

Hi @ManishSolanki ,

Thanks for the additional updates, truly appreciated.

However, I forwarded an email onto myself to trigger the email which is fine which has a different Customer Order ID: xxx-ENTA-1677 however it still pulls through the xxx-FLXG-104

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report

Re: ** HELP ** NEED TO EXTRACT TEXT FROM HTML EMAIL

Hi @sbruk89

Pls share the screenshots of your flow.

Thanks

Was this reply helpful? Yes No
sbruk89 157 on at

Like (0)

Report

Re: ** HELP ** NEED TO EXTRACT TEXT FROM HTML EMAIL

Hi @ManishSolanki ,

I added in that compose (Compose 4) you suggested. Which shows the correct reference xxx-ENTA-1677

However, when you get to action "Compose" it still has XXX-FLXG-104

I assume it has something to do with xxx-FLXG-104 being in the text of "Compose"

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report
Re: ** HELP ** NEED TO EXTRACT TEXT FROM HTML EMAIL

Hi @sbruk89

Pls replace static text in topmost Compose action with dynamic email body in html format. You can use the below expression in that Compose action to get the html text of the arrived email:

@{triggerOutputs()?['body']?['body']}

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No