Unanswered

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

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

Vijay Tailor 2,961 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous ,

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 -
For Sending the EMail for All the users in the list then you can use code like below -
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
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@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
Vijay Tailor 2,961 on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @Anonymous ,

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

SendEmail Using F...
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@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.
Vijay Tailor 2,961 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,
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-distinct-Assigned-to-User-and/td-p/113348

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