Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

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
Community Support

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.
Regular Visitor

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


New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!


Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!


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!


Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (8,190)