Power Automate: Extract recipients from email

Like (0) Share

Report

Posted on 15 Oct 2023 19:05:20 by Markus924

Hi all,

I'm working on a Power Automate flow that saves all recipients (items in TO line only) as individual items in a SharePoint List. I've found numerous tutorials how to extract data from the mail body but none for the TO line in mail header.

Example: A new mail arrives in my inbox that has 3 recipients:

Upon completion of the flow I have 3 new entries in a SharePoint list with the names of the 3 mailadresses.

I'm ok with the first 2 parts of the flow (when new e-mail arrives, get e-mail) but struggle then.

Who can help? Much appreciated!

Bildschirmfoto 20...

I have the same question (0)

All responses (5)

Answers (1)

trice602 14,638 Super User 2025 Season 2 on 16 Oct 2023 at 18:26:29

Like (0)

Report

Re: Power Automate: Extract recipients from email

Hi @Markus924 ,

Very nice! Have a great day over there!

Was this reply helpful? Yes No
Markus924 12 on 16 Oct 2023 at 18:02:30

Like (1)

Report

Re: Power Automate: Extract recipients from email

Thanks, @trice602, this works perfectly well!

Was this reply helpful? Yes No
trice602 14,638 Super User 2025 Season 2 on 15 Oct 2023 at 19:39:36

Like (0)

Report

Re: Power Automate: Extract recipients from email

Hi @Markus924 ,

Also note, you don't need "Get Emails (V3)" action because the data you are working with is all contained in the trigger output. Please also consider marking this reply as a solution also.

Was this reply helpful? Yes No
Verified answer

trice602 14,638 Super User 2025 Season 2 on 15 Oct 2023 at 19:36:30

Like (0)

Report

Re: Power Automate: Extract recipients from email

Hi @Markus924 ,

I was able to take multiple email addresses from the To: field and create individual items in my SP List. Here's the flow:

My 2nd compose uses the split() expression:

split(outputs('Compose_2'),';')

Next I initialize an array variable.

Lastly,

For each email address in my array, I create an item.

Was this reply helpful? Yes No
Markus924 12 on 15 Oct 2023 at 19:07:21

Like (1)

Report

Re: Power Automate: Extract recipients from email

UPDATE: I've experimented with dynamic content 'To' and export this to an item but it leads to duplicate entries and it does not work with mails where there is more than 1 recipient.

Was this reply helpful? Yes No