Send and E-mail to a Group of Office365Users

[elciofried]

Hello fellow devs,

I am trying to develop an app with Power Apps that has a form with a dropdown named "dropdown1" of SharePoint User with the fields:

- Title: name of the Person (String or Text)

- People: (Office365Users Person or Group)

and a button "Send E-mail" named "button1"

When I click on button "Send E-mail" i need to send a e-mail to ALL the people data is in the database.

For this I am using the OnSelect button action with a call to the Office365Outlook.SendEmailV2

The function SendEmailV2 parameters are SendEmailV2  (e-mail separate with ; , "E-mail subject", "E-mail body")

How to get all the e-mail, separate with ";" and put in the formula?

[BCBuizer]

Hi @elciofried ,

You can concatenate all values in a data source using the Concat() function: https://docs.microsoft.com/en-us/power-platform/power-fx/reference/function-concatenate

In your case it looks something like Concat(Testeelcio, Email, ";")

This works under the assumption that you are referring to Testeelcio as your database and it contains a column called Email that has the Email adresses of the users you want to send the mail to.

[phipps0218]

Use the Concat function. Something like this:

Please Accept as Solution if it solves your question. Or give this a Thumbs Up if it is helpful because this can help others.

LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
Subscribe to my YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218

[v-qiaqi-msft · Accepted solution]

Hi @elciofried,

Could you please tell me if you want to send email to all the selected users from the Dropdown1?

Could you please tell me where do you want to get all the email address, Dropdown1?

If you want to send email to all the users in your People field from your SPO list, you could write as below:

Office365Outlook.SendEmailV2(Concat(ListName.People,People.Email,";"),"Test","Hi Friday!")

This Concat() function will generate a string separated with ";" including all the email address from your SPO list.

[phipps0218]

@elciofried did my solution solve it for you?