I have a Combobox which is populated through a column in a SharePoint list called EventsList with multiselect on. The purpose of this combobox is to link one or multiple records in this SP list with a document in a seperate document library. The Combobox allows the user to select the EventNumber(s) and adds records to a Collection based on the SharePoint records. The code I am using for the OnChange is as follows;
I have a seperate Label with the following code; Concat(testCol,EventName,", ")
This works as intended displaying the list of EventNames. The problem I am having is that when you remove one of the selections from the Combobox, therefore triggering the OnChange, the Collect runs and adds a new record to testCol using the EventNumber that was just removed.
Is there a way to use an IF or something similar to check if you have added a selection to the combobox or removed one?
I have also tried doing this with the following ForAll;