SOLVED

How to send email to all persons in SP List via MS Flow

%3CLINGO-SUB%20id%3D%22lingo-sub-2679764%22%20slang%3D%22en-US%22%3EHow%20to%20send%20email%20to%20all%20persons%20in%20SP%20List%20via%20MS%20Flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2679764%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20an%20question%20about%20sending%20an%20email%20to%20multiple%20people%20in%20our%20organization.%3C%2FP%3E%3CP%3EI've%20tried%20to%20find%20similar%20topic%2C%20which%20can%20help%20me%2C%20but%20unfortunately%20didn't%20find%20anything%20or%20the%20right%20one.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20request%20is%20the%20following%3A%3C%2FP%3E%3CP%3EWe%20have%20an%20Employees%20Sharepoint%20List%20on%20which%20we%20have%20Person%20selected%20%2B%20another%20main%20data%20related%20to%20every%20employee.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20I%20can%20set%20an%20email%20notification%20which%20can%20send%20email%20to%20all%20Employees%20described%20in%20this%20specific%20list%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2679764%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2683483%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20send%20email%20to%20all%20persons%20in%20SP%20List%20via%20MS%20Flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2683483%22%20slang%3D%22en-US%22%3E%3CP%3EBelow%20is%20a%20simple%20flow%20that%20might%20get%20you%20started.%20First%20step%20is%20getting%20the%20rows%20from%20your%20list%20with%20a%20Sharepoint%20%22%3CEM%3EGet%20Items%3C%2FEM%3E%22%2C%20keep%20in%20mind%20%22Filter%20Query%22%20in%20get%20items%20can%20help%20you%20choose%20just%20a%20subset%20here's%20a%20link%20for%20help%20building%20those%20queries%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fodata%2Fconcepts%2Fqueryoptions-overview%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EQuery%20options%20overview%20-%20OData%20%7C%20Microsoft%20Docs%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENext%20click%20%22%3CEM%3EAdd%20an%20action%3C%2FEM%3E%22%20below%20your%20%22%3CEM%3Eget%20items%3C%2FEM%3E%22%20and%20choose%20%22%3CEM%3ESend%20an%20Email%3C%2FEM%3E%22.%20You'll%20notice%20I%20circled%20%22%3CEM%3Eadd%20dynamic%20content%3C%2FEM%3E%22%20which%20offers%20me%20the%20%22%3CEM%3EEmail%3C%2FEM%3E%22%20column%20from%20my%20%22%3CEM%3EGet%20Items%3C%2FEM%3E%22%20List.%20When%20you%20choose%20the%20%22%3CEM%3EEmail%3C%2FEM%3E%22%20column%20it%20automatically%20wraps%20the%20%22%3CEM%3ESend%20Email%3C%2FEM%3E%22%20in%20an%20%22%3CEM%3Eapply%20to%20each%3C%2FEM%3E%22%20loop.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22LouDreamer_0-1629898670418.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F305654iF09E7D69CD8876DA%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22LouDreamer_0-1629898670418.png%22%20alt%3D%22LouDreamer_0-1629898670418.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20just%20configure%20your%20send%20email%20with%20the%20content%20you%20want%2C%20you%20can%20use%20the%20dynamic%20content%20in%20the%20other%20fields%20to%20spice%20it%20up%20or%20just%20have%20it%20send%20the%20same%20email%20to%20everyone%2C%20I%20hope%20this%20helps!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2687937%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20send%20email%20to%20all%20persons%20in%20SP%20List%20via%20MS%20Flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2687937%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1137275%22%20target%3D%22_blank%22%3E%40LouDreamer%3C%2FA%3E%26nbsp%3BOne%20thing%20to%20bear%20in%20mind%20is%20that%20if%20your%20list%20of%20email%20recipients%20is%20more%20than%20100%20then%20in%20the%20settings%20of%20the%20get%20items%20action%20you%20need%20to%20turn%20on%20the%20pagination%20toggle%20and%20increase%20the%20threshold%20to%20a%20number%20higher%20than%20the%20the%20number%20of%20recipients.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

 

I have an question about sending an email to multiple people in our organization.

I've tried to find similar topic, which can help me, but unfortunately didn't find anything or the right one.

 

My request is the following:

We have an Employees Sharepoint List on which we have Person selected + another main data related to every employee.

 

How I can set an email notification which can send email to all Employees described in this specific list?

2 Replies
best response confirmed by BoyanDimov (Occasional Visitor)
Solution

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 Query options overview - OData | Microsoft Docs.

 

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.

LouDreamer_0-1629898670418.png

 

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