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

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (5,905)