09-25-2017 12:43 PM
I have a Gallery I want to filter. I want to display all elements whose categoryID are in a list of values, defined as a collection.
My collection "Categories" is : 1,2,3,4,5
I tried something like : Filter(Gallery, categoryID in Categories) but it doesn't work .
All the examples I could find with "in" operator only work with one value, not with a list (eg: "1" in categoryID)
Can anyone help on this, this would be so bad not to be able to do this !!
09-26-2017 03:03 AM
Would you please share a screenshot of the formula that you used to create the "Categories" collection?
Any error messages showing out with the formula you used?
I just tried that formula from my side, and it works.
The formula I used to create the collection is as below:
In addition, you may also take a try with the formula below:
Filter(Gallery, categoryID in Categories.value)
09-26-2017 05:53 AM
thanks for the reply. I used your way to define the following collection : Collect(SelectedCategories; ["1";"2";"3";"4";"5";"6";"7";"8"])
But sill I have the following error (translation from French) : Suggestion, a part of the formula can't be evaluated from distance. The right side of the operator "in" is not a column name
09-26-2017 06:47 AM
You need to add the column name, probably. Please try this:
Filter(ServiceCatalogue, CategoryID in SelectedCategories.Value)
Also, you have an extra ; at the end of the formula
09-26-2017 07:12 AM - edited 09-26-2017 07:27 AM
Form your picture it seems you have an extra ; at the end which is causing the error. Try to remove it and see if it works