Send Email to multiple addresses from a listbox

[PaulB1]

I have a form with a LISTBOX. The listbox contains the names of people who have worked on a project and who need to be informed about any new safety issue on site.

The LISTBOX is dervived from a SQLSERVER View from which I select those that need to receive an email with the new safety details. So I wish to select the employees and together with the Authoriser send an email to only the selected people.

Any suggestions?

[v-yuxima-msft · Accepted solution]

Hi @PaulB1 ,

What is the data source in your sql?

And what is your formula expression for enad email?

Could you please make sure the ones your select in your O365 account firstly?

Do you add O 365 outlook as datasource?

I test as next:

Data Souce:

App test:

Add one dropdown and then,Dropdown1.OnSelect:Distinct('[dbo].[Table_20190409Email]',Email)

Add one button control and Button2.OnSelect:Office365.SendEmail(Dropdown1.Selected.Result,"Send email from PowerApps","Item: hello")

Then check the result:

If you want to send more users at onece , you can choose to use ComboBox control, then the Button.OnSelect:Office365.SendEmail(Concat(ComboBox1.SelectedItems,Result&","),"Send email from PowerApps","Item: hello")    (ComboBox1 is my test ComboBox control's name, you can change it to yours.)

More information:

connection-office365-outlook

Hope this could be helpful.

Best Regards.

Yumia

[TopShelf-MSFT]

Hi @PaulB1 can you review the above reply and update the thread?

@TopShelf-MSFT