Answered

Power Automate: Extract recipients from email

(0) Share

Report

Posted on 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 2023-10-15 um 21.02.15.png

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Markus924 12 on at

Like (1)

Report
Copy link

Link copied!

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
Verified answer

trice602 16,244 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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
trice602 16,244 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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
Markus924 12 on at

Like (1)

Report
Copy link

Link copied!

Thanks, @trice602, this works perfectly well!

Was this reply helpful? Yes No
trice602 16,244 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Markus924 ,

Very nice! Have a great day over there!

Was this reply helpful? Yes No