Answered

Send email to multiple addresses

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I would like to send ONE email to myself and bcc users if their email box is checked (please see attached). So far I have created a button which sends individual emails but this is becoming a pain (too many emails being sent) so I need to tweak it but can't work out how.

Please could someone advise how I go about this? This is what I have currently:

Clear(Coll1); Clear(colDistinct)

Collect(Coll1,Filter(Gallery1_1.AllItems, Checkbox2_1.Value=true));

Collect(colDistinct, Distinct(Coll1,'Email Address'));

ForAll(

colDistinct,

Office365Outlook.SendEmailV2(

User().Email, “subject”, “email text”,

{ Bcc: ThisRecord.Value }));

Many thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous,

Could you give the following adjustment a try - we can also remove the collections via this code:

Office365Outlook.SendEmailV2( User().Email, “subject”, “email text”, { Bcc: Concat( Filter(Gallery1_1.AllItems, Checkbox2_1.Value=true), 'Email Address', ";" ) } )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

You're a star! Thanks so much for the swift response! Works perfectly 🙂

Was this reply helpful? Yes No