cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Submit form to multiple combo box emails

Hello, 

 

I have created a form that needs to be submitted to one or multiple emails. Depending on whats needed. 

 

I created a combo box that Search Users within my outlook. This works perfectly. I am allowed to select one or multiple people at a time. 

 

The issue comes when I select multiple people at a time, only the first name entered will receive the email. Why is this happening?

 

This is the code I am using on my button: Office365Outlook.SendEmail('name-ComboBox'.Selected.Mail, "Subject Line Here", "Body Copy: " & ThisItem.'Link to item')

 

Thank you in advanced! 

2 ACCEPTED SOLUTIONS

Accepted Solutions
EricLott
Resident Rockstar
Resident Rockstar

Instead of referencing 'name-ComboBox'.Selected.Mail, you'll need to concat the selected items into one string. See below:

 

Concat('name-ComboBox'.SelectedItems.Mail,Mail,";")

View solution in original post

Looks like you're missing a comma after the Concat() function.

View solution in original post

4 REPLIES 4
EricLott
Resident Rockstar
Resident Rockstar

Instead of referencing 'name-ComboBox'.Selected.Mail, you'll need to concat the selected items into one string. See below:

 

Concat('name-ComboBox'.SelectedItems.Mail,Mail,";")
Anonymous
Not applicable

Hello!

 

Thank you for such a fast response! 

 

This actual broke the rest of my code 😞 (Please see attachment)

Looks like you're missing a comma after the Concat() function.

Anonymous
Not applicable

Thank you so much for your help with this!! 

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (1,681)