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
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (1,591)