Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Send personalized emails to each email address of a Sharepoint List



Im trying to create a flow like so:


1. Get email addresses from a Sharepoint List

2. Send Email template to each address in list found in point 1

3. Each email will be personalized based on the reciever from data from another Sharepoit List.


Point 1 and 2 are pretty clear to me and should pose no problem (Get Items, Apply to Each, Etc...), but im facing some issues on figuring out how to do the personalized email part.


Basically the objective is that each person recieves sort of personalized NewsLetter with some data about themselves from another sharepoint list.


I've been trying to find out how to do this, but so far I've been quite unlucky in finding a soltution. If somedoby with more expericence in MS Flows can at least let me know if this is possible, in case im wasting my time with an impossible task 🙂 


Thank you in advance!

Community Support Team
Community Support Team

Re: Send personalized emails to each email address of a Sharepoint List

Hi @HenrikV,


How do you want to personalize the email? Do you want to insert the corresponding info of the receiver in the email body? Or do you want the email body have different format based on the receiver?


Not sure if the following configuration will meet your request:




Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Level: Powered On

Re: Send personalized emails to each email address of a Sharepoint List

Thank you for your reply @v-yamao-msft,

It actually answers a couple of my doubts, but:


Lets say I have a List in Sharepoint as follows:


Name              |   Total Items

John Doe        |     25

Justin Case    |      32


So this flow will send an email to both, like so:


     Hello John Doe

     You have 25 Items on your inventory



And then another email to Justin


     Hello Justin Case

     You have 32 Items on your inventory



How can I get the flow to get that data from another list based on the Owner Email?


Thank you again for your support!


Helpful resources


Power Platform Online Conference

Speakers, submit your sessions now! Call for speakers ends Feb. 10!


New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!


Microsoft Learn

Learn how to build the business apps that you need.


Power Platform World Tour

Find out where you can attend!


Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,721)