cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Guillaume
Level: Powered On

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
Community Support Team

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

Guillaume
Level: Powered On

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

 

 

 

 

 

Meneghino
Level 10

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
Super User

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

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
Guillaume
Level: Powered On

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