Filter based on multiple checkboxes

[JHS2020]

Hi

I have an app, where I have 10 checkboxes I need to filter the information on. It result in a lot of combinations, as multiple check boxes could be selected at once. How do I solve this, as the gallery will not display more code after 50, as it states Limitation for Nested Function 

[rubin_boer]

hi @JHS2020 

I'm sure there are a few ways to do this, I will share one.

Result 

Method

• Add gallery for checkboxes Items = ["Option A", "Option B", etc ] or something similar
  • ForAll(Sequence(10,1),{name: "Option " & Char(Value + 64)}) // as an example 
• Add checkbox to gallery and add all the selected checkboxes to a string variable options
  • OnSelect = UpdateContext({options:Concat(Filter(Gallery16.AllItems,yourCheckBox.Value),name,",")})
• add another filter to display the selected item
• set Items = Filter(yourDataSource, yourfilterColumn in yourVariableFromOptionGallery)
  • Filter(ForAll(Sequence(100,1),{option: "Option " & Char(RandBetween(64,74)), name: "some name ... " & Value}),option in options) //from the example

That should do it

Hope it helps,

R

[JHS2020]

How is your data column in sharepoint. I am trying to get this to work

• Filter(ForAll(Sequence(100,1),{option: "Option " & Char(RandBetween(64,74)), name: "some name ... " & Value}),option in options) //from the example

However I cannot seem to get it to work, as my options is made by a choice column?

[JHS2020]

I have added this, but it does not seem to work

ForAll(Categories,{name: Title}) // on the gallery

UpdateContext({MySharePointList:Concat(Filter(option.AllItems,Checkbox13.Value),Title1.Text)}) //For the checkbox

Filter(MySharePointList, Title1 in Category1) // Items on the gallery

[rubin_boer]

hi @JHS2020 

in your case:

Selection Gallery (galSelect)

• Items = Categories 
• Add Checkbox (chkSelect) and its Text = ThisItem.Title
  • UpdateContext({options:Concat(Filter(galSelect.AllItems,chkSelect.Value),ThisItem.Title,",")})

Display Gallery

• Items = Filter(Categories, Title in options)
• add label Text = ThisItem.Title

Please try this.

[JHS2020]

Is it not possible to use one sharepoint list to filter the selection gallery and the display gallery should be another sharepoint list? 

[JHS2020]

It is like it is not working with the variables as it takes the latest check again