Send Mail (Power Apps button) to multiple people

[Dn_wemn]

Hi,

in a Power BI report in which a Power App is also integrated, I'd like to select multiple mail addresses and click on the Send-Mail-Button of Power Apps.

So far, it works when I send mail to only one mail address (receiver). It's because currently my format text in the Power Apps development is:

Mail.SendEmail(
     First( [@PowerBIIntegration].Data ).Receiver_Mail,

... )

So I guess instead of First(... I need to use something else.

I was trying to adapt it for sending to multiple users by using "FirstN", but it doesn't work in the formular bar.

How can I adapt this?

Thanks

Many regards

[jesse_sql]

Hi @Dn_wemn , have you tried using the ForAll-function to loop through the e-mails? This might help:
ForAll function in Power Apps - Power Platform | Microsoft Learn

[Dn_wemn]

@jesse_sql  Hi, I tried using ForAll, but it hasn't worked.

After loading the SQL table "Appointment_Comment_helper" in Add Data, basically this is what I tried:

Field SR_Mail is from this table.

I might need to add a formula after the table expression, but I have no idea how to proceed.

[victorcp · Accepted solution]

Hi,

you can use ForAll to solve your problem, but we can create another one if you have to send it to many users, so I suggest if the message is the same, send one email to all of them like this:

Mail.SendEmail(
     Concat( [@PowerBIIntegration].Data, Receiver_Mail, ";"),

... )

But if you really need to send each one an email you have to do this:

ForAll([@PowerBIIntegration].Data,
Mail.SendEmail(
     Receiver_Mail,

... )
)

I hope it helps 🙂

Any doubts please let me know

[Dn_wemn]

Thank you very much. It works with Concat.

Tried it before, but had mistake with syntax. Now all good 🙂