Tracking Undeliverable Emails

Hello,

I am building a flow to keep track of undeliverable email addresses in an Excel spreadsheet. The goal is to remove them from our mailing list. When there is an issue with an address because it no longer exists or was entered wrong, the email delivery service of the intended recipient will send a message to our shared inbox (with something along the lines of [EXTERNAL] Undeliverable email).

Sometimes this will come back with the faulty address in the From line and trigger the flow to populate the spreadsheet, but other times it will have an Outlook item in the message that contains the incorrect email address and the undeliverable email will be from a separate address (like mailer-daemon@gmail.com) which is what gets populated into the spreadsheet.

I have tried running the flow to extract the contents of the attachment and those to the spreadsheet, but it comes up blank because it is an "Outlook item" and technically not an attachment. Are there any other ways that I can get the information from the attachment into the spreadsheet?

Categories:

Business Process Flows

Quick Links

Leaderboard > Power Automate