Power Platform Community Forum Thread Details

Hi Ms Community, I need to create a powerapp that would bulk send a mail to specific companies from SharePoint lists.

so let’s say I have a SharePoint list 3 Companies:

1) Microsoft | The e-Mailadress of the company| Personification

2)Apple | The e-Mailadress of the company | Personification

3)Meta … …. (“Same stuff like above…”)

now I need to select lets say Apple and Microsoft from Powerapps, then automatically get their Emailadresses and be able to send the mail to both of them (individually. Can’t be CC) with a custom text/writing style and thumbnail. With a couple clicks of a button. All in powerapps ( with the data that is in SharePoint )

Categories:

Building Power Apps

Be careful about sending "bulk" emails. Some countries have anti-spam legislation or your email can get blacklisted by some services.

You can create an experience in your app that has a gallery with the List of possible recipients, plus a checkbox in the item template so a user can select the desired ones.

Then, you leverage the Outlook connector to send an email message:

With({aFilter: Filter(myGallery.AllItems, cbChoice.Value = true)},
 ForAll(aFilter As aRec,
 Office365Outlook.SendEmailV2(
 LookUp(mySPList, 'Company Name' = aRec.'Company Name', Email),
 "Subject line text",
 "Email body text, which can include HTML"
 )
 )
)

You'll need to adjust this code for the specific names of your List, columns, and controls in your app.

Hope that helps,

Bryan