InfoPath Dev

Hello All! My organization is currently using a combo of InfoPath 2013 & SharePoint 2016 (I know... very dated and soon to be unsupported, but all I have to work with unfortunately). I've been building forms for a while and have been able to work around many of the numerous quirks of InfoPath; however, I've hit a wall with one of the latest requirements. I have a SharePoint 2016 list where each item is an individual project. From there, I have built an "Impacted Teams" field where users will use the InfoPath form to indicate the teams involved with the project. My issue lies in the fact that I have about 50 different teams that can be selected, so adding them all to a single Multi-Selection List Box creates a list that is long and difficult for users to navigate. My ideal solution would be to have numerous Multi-Selection Lists Boxes that are all bound to my single field and then filter down each control so that each one only displays the teams from one department. I have been able to get this far, but since the controls are bound to the same field, if I select an option from one control, it will automatically display that as a selected option in all of the other controls below all of the filtered options. Is there any way I can prevent the controls from displaying the options that were selected in the other filtered controls? In the past, I had to create 20+ separate fields/columns for each department to store their team impacts, but it would be much more ideal to capture all in a single field. Example attached to help visualize the problem I'm encountering. If this isn't possible, is there an alternative solution to insert text header rows between the checkboxes in the Multi-Selection List box to break up the different departments? Thanks so much! Logan

Ick. So I quickly can reproduce the issue you experience in a sample form. One thought I had was to turn the multi-select into a repeating table with a dropdown and conditional formatting to show / hide the correct items in the correct area, but look at this GIF, you'll see I ran into challenges with the "blank" option.

Hi Hilary, Thanks so much for taking a look! This looks like it could be a solid workaround. I'll give it a try and see if the business prefers it over my other solution, which would be to append the Department name to each available team option and then sort them alphabetically in one long multi-select list box. From your knowledge, is there any way to insert non-selectable text options in a multi-select list to help break up the different teams among Departments in one long list? P.S. I truly appreciate all of the contributions you've made to this community over the years. Your name came up often whenever searching the internet for answers as I was learning InfoPath, and the information you shared was invaluable for overcoming some of the challenges that I encountered.

Hi, Logan - glad I could be of help. I don't know of any way to add non-selectable text (i.e. a subheading sort of thing) to a multi-select I'm afraid - that would have been a nice workaround!