cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jasmin_Sch
Helper IV
Helper IV

Filter Gallery with checkbox

Hi everyone!

Currently I filter my gallery by setting the items property to this:

 

Filter('3400 ILLU Arbeitspakete Mastersheet'; Cluster.Value = 'Dropdown Auswahl Cluster'.Selected.Result && Objekt.Value = 'Dropdown Auswahl Objekt'.Selected.Result)

 

 

Beside that I inserted a checkbox in my screen. Everytime the user clicks the checkbox I want to add a another filter to my gallery: Status.Value=”Archiv” (Status is as well a choice column, and one value of the choices is “Archiv”). The filter disappears of course after the user unchecks the checkbox.

 

Is there a way to achieve this?

 

Thank you!

1 REPLY 1
iAm_ManCat
Super User
Super User

Hi,

 

Yes this can be done 🙂

 

If(
   CheckBoxName.Value,

   Filter(
          '3400 ILLU Arbeitspakete Mastersheet'; 
           Cluster.Value = 'Dropdown Auswahl Cluster'.Selected.Result
        && Objekt.Value = 'Dropdown Auswahl Objekt'.Selected.Result
        && Status.Value = ”Archiv” 
   ),

   Filter(
          '3400 ILLU Arbeitspakete Mastersheet'; 
           Cluster.Value = 'Dropdown Auswahl Cluster'.Selected.Result
        && Objekt.Value = 'Dropdown Auswahl Objekt'.Selected.Result
   )

)

 

There are of course many ways to do this, however this is how I would do it easily - check for the status of the checkbox before the filter is actioned, so put all of the above in your items property and change the name to match your checkbox control name.

 

If you have any issues when implementing the above please feel free to ask for help,

 

Cheers,

Sancho

@iAm_ManCat


Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you!


Thanks!
You and everyone else in the community make it the awesome and welcoming place it is, keep your questions coming and make sure to 'like' anything that makes you 'Appy
Sancho Harker, MVP


Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,622)