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!