Forum Discussion
How to send email to all persons in SP List via MS Flow
Below is a simple flow that might get you started. First step is getting the rows from your list with a Sharepoint "Get Items", keep in mind "Filter Query" in get items can help you choose just a subset here's a link for help building those queries https://docs.microsoft.com/en-us/odata/concepts/queryoptions-overview.
Next click "Add an action" below your "get items" and choose "Send an Email". You'll notice I circled "add dynamic content" which offers me the "Email" column from my "Get Items" List. When you choose the "Email" column it automatically wraps the "Send Email" in an "apply to each" loop.
Then just configure your send email with the content you want, you can use the dynamic content in the other fields to spice it up or just have it send the same email to everyone, I hope this helps!
Below is a simple flow that might get you started. First step is getting the rows from your list with a Sharepoint "Get Items", keep in mind "Filter Query" in get items can help you choose just a subset here's a link for help building those queries https://docs.microsoft.com/en-us/odata/concepts/queryoptions-overview.
Next click "Add an action" below your "get items" and choose "Send an Email". You'll notice I circled "add dynamic content" which offers me the "Email" column from my "Get Items" List. When you choose the "Email" column it automatically wraps the "Send Email" in an "apply to each" loop.
Then just configure your send email with the content you want, you can use the dynamic content in the other fields to spice it up or just have it send the same email to everyone, I hope this helps!
LouDreamer One thing to bear in mind is that if your list of email recipients is more than 100 then in the settings of the get items action you need to turn on the pagination toggle and increase the threshold to a number higher than the the number of recipients.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
