Answered

Send and E-mail to a Group of Office365Users

(0) Share

Report

Posted on by 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?

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

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.
MVP-Phipps 3,521 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

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
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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.
MVP-Phipps 3,521 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@elciofried did my solution solve it for you?