send emails to mails present in Dropdown of Gallery

[Hemasai1999]

Hi,

I have one app where I need to send mails with respect to selected dropdowns in gallery.

Like above picture I have different person names in gallery, example I have 3 names in gallery dropdowns for multiple times, I need to send mail to 3 names only once.

I have stored all mails in one label to send mail, but it is sending multiple mails to single person.

I have written this formula to send emails to multiple persons - 

(ForAll(Gallery9.AllItems, Office365Outlook.SendEmailV2(Label184.Text,"You have been assigned as a Trainer","Hi <br><br>You have been identified as a facilitator for <br> Training Request: " &Gallery14_1.Selected.TrainingProgram& "<br><br>Please find the details below<br> Training Start Date: " &Gallery14_1.Selected.StartDate& "<br>Training End Date: " &Gallery14_1.Selected.EndDate& "<br><br>Regards,<br>Powerapps Team"));)

what should I do in order to send one email at a time to different person's

Any suggestion would be helpful

[zmansuri]

In the To section instead of writing label name. you can write this:

Concat(ComboBox1.SelectedItems,Email,";")

[Hemasai1999]

HI @zmansuri ,

thanks for reply,

But when I try with formula that you have suggested it is taking only one person email, i.e mail is triggering to only one person , where as mail should trigger to two persons as selected in gallery.

Any suggestion would be helpful

[zmansuri]

Take a label. Set it's text property to: Whatever your "To" part is in the email section.

your result should be email id's separated by semicolon

abc@gmail.com;def@gmail.com;xyz@gmail.com

anything else will not work

[WarrenBelz]

Hi @Hemasai1999 ,

If you want one email to multiple people, then @zmansuri 's response is correct. You might also consider send the mail to yourself with a bcc to all the other people (so they cannot see all the email addresses). If you want separate emails

ForAll(
   Gallery9.AllItems As aSend, 
   Office365Outlook.SendEmailV2(
      aSend.ComboBox2.Selected.'EmailID',
      "You have been assigned as a Trainer",
      "Hi <br><br>You have been identified as a facilitator for <br> Training Request: " & 
      Gallery14_1.Selected.TrainingProgram & 
      "<br><br>Please find the details below<br>Training Start Date: " & 
      Gallery14_1.Selected.StartDate & 
      "<br>Training End Date: Gallery14_1.Selected.EndDate & 
      "<br><br>Regards,<br>Powerapps Team"
   )
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[WarrenBelz]

Hi @Hemasai1999 ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[Hemasai1999]

HI ,

Thanks for your time.

On clicking the update button, email has to be sent to the assigned trainers from the gallery. Now as shown in this screenshot, I have 3 trainers assigned. Now the email should include start date, end date and time mentioned in the gallery

( for 1) PreethiAdavelli - 9/2/2021, 9/3/2021, Start Time : 9:00 AM End Time : 18:00PM

2) KolaMounika - 9/6/2021, 9/7/2021, Start Time : 9:00 AM End Time : 18:00PM

3) KunaRamya - 9/8/2021 , 9/9/2021, 9/10/2021, 9/11/2021, 9/12/2021, 9/13/2021 Start Time : 9:00 AM End Time : 18:00PM ).

So how can I send email to these assigned trainers with particular Start Date, End Date, Start Time and End Time.

[WarrenBelz]

@Hemasai1999 ,

Has your posted query (send emails to mails present in Dropdown of Gallery) been solved? 

[Hemasai1999]

No,

Still I am not able to send mails for different mails present in dropdown of gallery.

[WarrenBelz]

@Hemasai1999 ,

What was the result of the code I posted (error - if so what was it or did it not produce the result desired)