cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Send email to All users in Sharepoint list using PowerApps and Flows

Hi,

 

I'm new to PowerApps development.

 

Want to create a flow that can trigger an email to all the users stored in the Sharepoint list by clicking on the button in PowerApps.

 

can anyone please help?

 

Regards,

Mayank

 

 

5 REPLIES 5
Resident Rockstar
Resident Rockstar

Hi @gumgih ,

if your requirment is only sending mail then No need to use FLow,

you can use directly from PowerApp.

You can use the office365Outlook Connector to Send EMail.
See the connector reference  - 

VijayTailor_0-1602842019227.png

For Sending the EMail for All the users in the list then you can use code like below - 

VijayTailor_1-1602842337655.png

Thanks,
Vijay

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay



@VijayTailor Thanks for your response.

 

I have already tried something similar to this, but I have 2000+ items in Sharepoint lists with duplicate email IDs as attached in the previous screenshot, can I restrict the "To" address with "Distinct" function.

 

Currently Using:

Office365Outlook.SendEmailV2(Concat('DS11.11.02_Ace_Scheduler_Review','Manager Mail Id',";"),"Ace Job Scheduler","Test Email");

 

Thanks,

Mayank

Hi @gumgih ,

Thanks for Providing more Information.

See the Solution for your requirement below - 
Please Find attached Video Demo for your Requirement.

 

Thanks,

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay

@VijayTailor 

 

Thanks for your response, but still 1 issue like I have received 100+ email as my name is present 100 times in the SharePoint list, I want to filter the mail IDs and share a single email if there are duplicate entries in the list.

 

Attached is the screenshot for the same.

Hi @gumgih ,
Please have a look into below url,

Hope that will help to achieve your requirement.

https://powerusers.microsoft.com/t5/General-Power-Automate/microsoft-flow-get-all-items-with-distinc...

Thanks,
Please Let me know if still you are facing any issue.

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Solution Authors
Top Kudoed Authors
Users online (39,018)