How to extract Email address in the body of an email to be put into a SharePoint List?

[xy2]

Hello,

I would like to extract the email addresses from an Undeliverables email specifically so that I can compare them with an existing SharePoint list I have to remove the addresses using Power Automate.

Attached is an example of the Undeliverable email, I just want to retrieve the email address written in the body.

Appreciate any inputs 🙂

[Shuvam-rpa · Accepted solution]

Hello @xy2 ,

To extract the email address from the body of email, you have to create one automated cloud flow with the connector When a new email arrives (V3) and after that create one compose action and paste the expression in compose triggerOutputs()?['body']['toRecipients'] to capture the email address. I'm attaching some screenshot for your reference. 

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

[xy2]

Hi @Shuvam-rpa , thanks for your response.

I've tested the flow you provided but it outputs my email address instead of the one I want to retrieve.

For context: The image attached is an automated email I receive that mentions email addresses that my mail did not reach. I would like to retrieve that email address in the email instead of mine.

[Shuvam-rpa]

Could you please send me the screenshot.

As in my testing i have received the failed recipient address . please check the below screenshot.

[xy2]

Working with company emails so I censored those.

The output I received from this flow is the email address colored in blue; the shared mailbox where I receive emails regarding undelivered addresses.

Please let me know if I missed out anything 🤔

[Shuvam-rpa]

Kindly check, i have done testing on the shared mailbox also and i got the desired output.

[xy2]

Thank you but it still does not work for me 😢

Are there any other alternatives to this?

[Shuvam-rpa]

We can connect on anydesk , so i can check the issue you're facing.

[xy2]

Hello, the flow ran by itself today and it managed to retrieve the new undeliverable email address! There might have been some backend issues on my side yesterday.

Thank you for your help, have a great day 😀 

[frankbaca]

Hello! I have a similar need to extract an email address from the body of a received email and the formula isn't working for me, can you take a look?

This is the email I receive:

Thanks!

[frankbaca]

For anyone wanting a follow-up to this topic:

I figured this out using an expression I found on another solution but first I had to add the text Email Address: before the email address in the screenshot above and for the flow I added a step HTML to text. Then this expression worked for me: trim(first(split(last(split(body('Html_to_text'),'Email Address:')),'Certification:')))

Cheers!

[RaviAchhwa]

Hi @Shuvam-rpa /@frankbaca,

I am looking to track Original email when there is any bounce back arrives. Able to see Undeliverable email in Dynamics and original email is attached with that, but how can we track that original Email record in Dynamics ?

Requirement is if email bounce back as undelivered, we need to create Postal Activity(Custom entity- to be send to mail house).

Note- there is no unique id on email subject and there are options that same customer will get multiple email with same subject. So how to identify which email failed.

Thanks in advance

[HurricaneVince]

Thank you for this!!  This was exactly what I needed to be able to do and that expression worked like a charm.