cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
AndyFitz
Frequent Visitor

BUG - multi selection in combo box for e-mails

Good Afternoon

 

i have created an app where the user can enter free text, and some attachments, then select multiple people to e-mail using a combo box (comboBox6) for selection. It has a connection to Outlook and to the spreadsheet containing the e-mail addresses. It was woking very well, untill friday 1st June when the multi send stopped working. you can still select who to send it to, however the actual e-mail only sends to the last peoson on the list, not all selected. No code was changed. it just stopped working for all users. I have checked everything in the app and there are no errors. Ive Deleted and re-added the combo box, deteted and re-connected the spreadsheet. nothing seems to be fixing the problem. the code in the 'send e-mail' button is as followss (and worked perfectly up until the 1st June):

 

Office365.SendEmail(ComboBox6.Selected.'e-mail address',"SiteNotesApp "&"Notification "&" "&DatePicker1,Concatenate("Site: ","<br>")&'Site Name Lable D/E'&Concatenate("<br><br>","Job No: ","<br>")&'Job No. Lable D/E'&Concatenate("<br><br>","Note Type: ","<br>")&'Note Type Lable D/E'&Concatenate("<br><br>","Detail: ","<br>")&'Main Body Text D/E',{Attachments:ClearCollect(Colattach,{Name:"QuickSnap.jpg",ContentBytes:'QuickSnaps Image D/E'.Image,'@odata.type':""},{Name:"PhotoUpload.jpg",ContentBytes:'UploadedImage D/E'.Image,'@odata.type':""}),IsHtml:true})

 

i belive this could be a bug within powerapps rather than the app i have built, purley because it stopped working without any change from my end. 

 

Any help/info to resolve this would be great.

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft
Microsoft

Re: BUG - multi selection in combo box for e-mails

Hello AndyFitz,

 

I cannot explain the reason your application stopped working recently, but I do see an issue in your formula that sends emails. The issue is that you use "ComboBox6.Selected" which contains only the last selected item and is usually used in a "single-select". Try using "ComboBox6.SelectedItems" instead. That property contains all the selected items. Please note that the "SelectedItems" property is a table (while Selected is a record type) so you may also need to use "Concat" function in order to convert your table to a list of comma-separated values. Please see this for more details: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-concatenate

View solution in original post

2 REPLIES 2
Microsoft
Microsoft

Re: BUG - multi selection in combo box for e-mails

Hello AndyFitz,

 

I cannot explain the reason your application stopped working recently, but I do see an issue in your formula that sends emails. The issue is that you use "ComboBox6.Selected" which contains only the last selected item and is usually used in a "single-select". Try using "ComboBox6.SelectedItems" instead. That property contains all the selected items. Please note that the "SelectedItems" property is a table (while Selected is a record type) so you may also need to use "Concat" function in order to convert your table to a list of comma-separated values. Please see this for more details: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-concatenate

View solution in original post

AndyFitz
Frequent Visitor

Re: BUG - multi selection in combo box for e-mails

HI dinusc

 

Thank you for the quick response. This has solved the issue! thank you!

 

no idea why this worked before up until friday, but thank you for the fix! 

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (7,692)