Hi,
I've been looking through other posts about this subject but have not been able to solve my issue.
I have a SharePoint List with a LookUp column named 'Tags', that is mapped to another SharePoint List that contains the actual tags (this is for an app to tag employees within our company with certain capabilities). I also added the tags 'Title' as a separate column:
Tags list in Sharepoint:
Now when I use a combobox with all the different tag values to filter my employees, I cannot get multiple values to work correctly.
I can get one tag in my gallery filter to work correctly, like so:
Filter('Employees list', Value(TextInput4.Text) in Tags.Id)
But cannot get multiple tags to filter my gallery succesfully. Here's some stuff I tried:
Filter on gallery:
Filter('Employees list', ComboBox.SelectedItems.ID in Tags)
Creating a collection as a datasource for my gallery:
Clear(FilteredOnTagsCollection);
ForAll(
ComboBox.SelectedItems,
Collect(
FilteredOnTagsCollection,
Filter(
'Employees list',
ThisRecord.ID in ShowColumns(
Tags,
"Id"
)
)
)
)
(this actually does something, but when searching with only one tag I do see employees in the results that do not have that tag)
Is this even possible? How can i filter on a multiple LookUp column using a combobox?
Cheers
Reinder
