cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Send personalized emails to each email address of a Sharepoint List

Hello,

 

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!

2 REPLIES 2
Highlighted
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:

 1.PNG

 

 

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.
Highlighted
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

     Regards,

 

And then another email to Justin

 

     Hello Justin Case

     You have 32 Items on your inventory

     Regards,

 

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

 

Thank you again for your support!

Henrik

Helpful resources

Announcements
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)