Hi,
I have a Sharepoint list that has 'Multiple lines of text' columns (example table below)
PersonTable
| Person | Age | Likes | Dislikes |
| A | 1 | This person likes chocolate, strawberry and vanilla ice cream | This person dislikes the cold, and pigeons. |
| B | 2 | This person likes vanilla and pistachio ice cream. | This person dislikes the cold and the dark. |
| C | 3 | This person likes strawberry and vanilla ice cream | This person dislikes pigeons. |
I have a gallery displaying the data from this table.
I also have a multi-select combo box which I will use to filter the gallery. The combo box options are populated via a separate list. (example below)
Options: Vanilla, Chocolate, Strawberry, pistachio.
I would like to select multiple items from the combo box and return rows that match ALL of the selected values.
Example case:
I select Vanilla from the combo box and all rows are returned because they all contain vanilla in their 'Likes' column. I then select strawberry and the gallery returns person A and person C as their "Likes" column contains both Vanilla and Strawberry. Person B is not returned as their 'Likes' column does contain vanilla but not strawberry.
I have managed to filter the gallery based on a single value from a combo box but not where it needs to match all values.
That function looks like this:
Filter(PersonTable, ComboBox.Selected.Value in Likes)
I have tried:
Filter(PersonTable, ComboBox.SelectedItems in Likes)
But that returns the following error:
Invalid argument type. Cannot use Table values in this context.
Any suggestions?
