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

Noting undelivered emails in Excel list

I am using an Excel Sheet to send emails. I am using four columns - NameDateEmail and Delivery

The Delivery column should have a value 'error' if the email bounces back. 

I am using two flows - one that is triggered manually to send all the emails and another flow which is using "get email" as the trigger and using a condition if the Subject contains Undeliverable. 

I need to get the email address of the intended recipient from the email body.

I thought I should use HTML-to-text first and then find the text after mailto:, but that wont work because there are other email addresses mentioned on the undeliverable email.

 

How do I get the email address of the entity from an email that bounced back using Flow?

3 REPLIES 3
ChristianAbata
Super User
Super User

hi @bilal_amir  I tested myself sending a message to a bad mail and then in a flow I use the trigger when a new email arrives, and then use the fild to in a compose and this is the destinatary mail what you need

 

to.PNG

 

to has my bad email, taht bounce with undelivery mail.



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

@ChristianAbata 

 

My "To" section has my email address (since the bounced email report is being sent to me). The wrong email address is in the body of the email

@bilal_amir  could you paste here your body seccion I could find a way to get that mail 😉



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,730)