I am trying to add a basic checkbox filter onto my gallery but I can't seem to get them working together, only seperately.
The options within the gallery are: Car, Home, Car and Home.
What I want is when you select the Car checkbox, that it shows the Car and Car and Home options. SImilarly when you select the Home checkbox it shows you Home and Car and Home. When both are selected I want every option from my document library to show.
Below is my code and screenshots of what I'm getting. You can clearly see in screenshot 1 that when both checkboxes are ticked, none of the Home options are showing (red text).
SortByColumns(If(CarCheckbox.Value=true, Filter('TRU Only Documents',CarCheckbox.Text in Product.Value),HomeCheckbox.Value=true, Filter('TRU Only Documents',HomeCheckbox.Text in Product.Value)),
SortByColumns(If(CarCheckbox.Value=true && HomeCheckbox.Value=false, Filter('TRU Only Documents',CarCheckbox.Text in Product.Value),HomeCheckbox.Value=true && CarCheckbox.Value=false, Filter('TRU Only Documents',HomeCheckbox.Text in Product.Value),CarCheckbox.Value=true && HomeCheckbox.Value=true,'TRU Only Documents'),
Community Support Team _ Mona Li If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.