How to get unique items from collection in different combo box in CanvasApp if combo box collection contains same list.
High level resolution steps
- Here I’m taking example where I have collection of sales person name in three different combo
boxes. I want to enter sales person name but when I select 1st sales person name in 1st combo box, that name should not be shown in 2nd and 3rd comb box and vice versa.
Detailed resolution steps
Step 1: I have added 3 combo boxes and in that combo boxes all the sales person names are available.
Step 2: As you can see the previous image all combo box having same collection. I should not be getting the name in sales person 2nd which I have selected in sales person 1st . For that on OnStart of the app or on OnSelect property of any combo box we have to set three variables.
| OnSelect property of ComboBox11:- Set(varSelected1, ComboBox11.Selected); Set(varSelected2, ComboBox22.Selected); Set(varSelected3, ComboBox33.Selected); |
Step 3: After setting the variables, now in ComboBox22 item property we need to filter out the data
that is available in ComboBox11 and ComboBox33. And same code for ComboBox33 to filter out the ComboBox11 and ComboBox22.
| Item property of ComboBox22: Filter(salesper, Name<>varSelected1.Name && Name<>varSelected3.Name) |
| Item property of ComboBox33: Filter(salesper, Name<>varSelected1.Name && Name<>varSelected2.Name) |
Output:
In the below list as we can see in Sales Person1 “Sujay” name is not available in sales person 2 and sales person 3 list same way for Sales peeron2 and Sales person3.
