Reply
Highlighted
Level: Powered On
Posts: 28
Registered: ‎09-25-2017

Filter a Gallery based on a values belonging to a collection

Hello,

 

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 !!

 

Regards

 

Guillaume

Community Support Team
Posts: 4,058
Registered: ‎09-20-2016

Re: Filter a Gallery based on a values belonging to a collection

Hi @Guillaume,

 

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:

Collect(Categories,["1234","235","346"])

In addition, you may also take a try with the formula below:

Filter(Gallery, categoryID in Categories.value)

Image reference:

85.PNG

 

Regards,

Michael

Level: Powered On
Posts: 28
Registered: ‎09-25-2017

Re: Filter a Gallery based on a values belonging to a collection

Hello Michael,

 

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

 

 

ErrorPA.jpg

 

 

 

 

 

Level 10
Posts: 1,979
Registered: ‎11-07-2016

Re: Filter a Gallery based on a values belonging to a collection

Hi @Guillaume

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

Super User
Posts: 439
Registered: ‎04-27-2017

Re: Filter a Gallery based on a values belonging to a collection

[ Edited ]

Hi @Guillaume

 

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

-------------------------------------------------------------
Consider up voting the idea to make SQL Connector Secure
Level: Powered On
Posts: 28
Registered: ‎09-25-2017

Re: Filter a Gallery based on a values belonging to a collection

Hello @Meneghino,

 

thanks for spotting this, now I remember I'd already tried this (with "Value"). Doesn't work either :

 

 

ErrorPA-2.jpg