Hi all,
I'm having some trouble filtering a collection where the combobox allows multiple items to be selected. The key challenge here I think is that the data source.
The SP list contains data on rates that companies can offer roles for. Each row contains the company name, role name, and the cost of that role. The combobox uses the role column to filter which is text and there are 165 different roles within the list.
What I would like to happen is the user selects the roles they want to look recruit for and a collection is filtered as such that it only shows the companies that can deliver on ALL the roles selected. E.g., if I selected roles Business Analyst, Data Analyst, and Project Manager then my collection would show Company A, D, and F as they are the companies that can deliver on all the roles.
I have got it to work when selecting a single role as below:
ClearCollect(
colSuppliers,
Filter(
'Rate Card Comparison',
Role = Suppliercap_combo.Selected.Value || Suppliercap_combo.Selected.Value = Blank()
/*!(false in ForAll(
Suppliercap_combo.SelectedItems,
ThisRecord.Value in Role
)) */
)
);
There is also a few lines of code I have commented out but attempted to use to no success.
TIA
