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 II
Super User II

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
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,041)