how to send an email to multiple people selected form a gallery list in powerapps

(0) Share

Report

Posted on by JAY_dev

how to send an email to multiple people selected form a gallery list in PowerApps and not get this

i only want one email address to show there

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (0)

lr 26 on at

Like (0)

Report

Hi,
maybe you can use a ForAll function, to send a separate email to every selected user.
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-forall

Best regards

Was this reply helpful? Yes No
JAY_dev 8 on at

Like (0)

Report

Can i implement this in to a flow sorry i have used the ForAll before and i don't see how it will work, can you please explain a bit more

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (1)

Report
Hi @JAY_dev :
Do you want to collect the email addresses selected by the gallery and send messages to these email addresses?
I suggest that the Concat function connect the selected addresses with ";" so that you can send multiple emails at once.
I'v made a test for your reference:
1\My data source:

ClearCollect(TheMail,{mail:"XX@XXXXXX.com"},{mail:"bof@XXXXXXXX.com"},{mail:"46XXX71@qXXX.com"},{mail:"XXXng@XXXXXt.com"}) /*TheMail is my custom collection*/

2\Add a gellry
Items

TheMail

3\Add an arrow into this gallery
OnSelect

Collect(waitforsent,{mail:ThisItem.mail}) /*waitforsent is my custom collection*/

4\Add a lable(Used to show the result of the concat function, you can skip this step)
Text:

Concat(waitforsent,mail,";")

5\Add a button (you should add an office365outlook connection first)
OnSelect

Office365Outlook.SendEmailV2(Concat(waitforsent,mail,";"),"Subject","Body");Clear(waitforsent)

I think this link will help you a lot
Send an email (V2)
Best Regards,
Bof

Was this reply helpful? Yes No
JAY_dev 8 on at

Like (0)

Report

that looks good and all but i don't think it will help me with the 100+ email accounts i need to work with and more are going to be added for new clients and going back to change the code every time a client get added or removed seems a bit wasteful,

thanks for trying to help me sorry I'm so full of nonsense but i need this to be exact because it what my client asked for.
i did do the (concat) funtion to send multiple email wich works fine however i need it not to show the email all addresses i sent the email to.

i need this

not this

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (1)

Report
Hi @JAY_dev :
Because you mentioned "selected by gallery", I thought you need to select the required email addresses one by one in the gallery.
I am not sure if I have understood your needs now, can you help me point out my mistakes?
you have a list of email accounts
You show these emails in a gallery
You want to send mass emails to all email addresses in the gallery
If my understanding is correct, you can try this code:

Office365Outlook.SendEmailV2(Concat(Gallery10.AllItems,mail,";"),"Subject","Body");Clear(waitforsent)

Or

ForAll(Gallery10.AllItems,Office365Outlook.SendEmailV2(mail,"Subject","Body"))

Best Regards,
Bof

Was this reply helpful? Yes No
JAY_dev 8 on at

Like (0)

Report

sorry looks like i did not explain very well , in my app I am creating an html document and then im converting it to pdf format in a flow now what i need is to send emails to all the people associated with the document with out the being multiple email addresses in the (To:) area of the email see the images of my previous post , i need there to be only the email address of the person i am sending to

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @JAY_dev ：
Could you tell me where the email address is stored? How to get it?
Best Regards,
Bof

Was this reply helpful? Yes No
JAY_dev 8 on at

Like (0)

Report

in SharePoint lists witch I'm pulling to powerapps

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @JAY_dev :
Could you tell me:
Where are you stuck now? Are you currently unable to send mail to multiple people? Still can't get the email address? Still can't send a PDF?
If it is not possible to send an email to multiple people or to obtain an email address, the solution I gave directly should be available.If not,could you describe the details in detail?
Best Regards,
Bof

Was this reply helpful? Yes No