Answered

Send Mail (Power Apps button) to multiple people

(0) Share

Report

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

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

jesse_sql 30 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Dn_wemn 15 on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
Verified answer

victorcp 2,350 Moderator on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Dn_wemn 15 on at

Like (1)

Report
Copy link

Link copied!

Thank you very much. It works with Concat.
Tried it before, but had mistake with syntax. Now all good 🙂

Was this reply helpful? Yes No