cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mojgan
Regular Visitor

Parse/Extract bad Email address from Undeliverable/Returned emails

I am trying to parse the body of an undeliverable/returned email and extract the bad email address.  
Undeliverable/returned emails come in different formats. The email address may be in different positions in the email body and preceded by different words or syntax. Therefore,  "Filter Array' or "Split by Colon" didn't help so far. They did help if I know the position or the preceding word.

 

In addition, when I use 'HTML to TEXT' function, in certain instances, it duplicates the email according to below example:

    'ABCD@ucu.edu'   to   'ABCD@ucu.eduABCD@ucu.edu'

Which makes it even harder to grab the email. 

 

Is there a way to accomplish this task? 

 

Here is my flow so far:

Mojgan_0-1660329712599.png

 

 

1 REPLY 1
VictorIvanidze
Community Champion
Community Champion

Hi @Mojgan,

 

- do not use HTMLToText. Parse HTML.

- find all email addresses by @(at), then check if there is something like "#550 5.1.0" before given address. 

--------------------------------------------------------------------------------------
Contact me if you are interested in custom Power Automate development.

Helpful resources

Announcements
Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,387)