Good afternoon everybody! I am tasked with adding 3 filters to the gallery screen in a canvas app here at work. I'm using a collection as my data source (you guys gave me that idea... to avoid delegation issues). The gallery looks great, and the search box I added already is working great. I want to give my users the ability to filter the gallery using 3 dropdowns: Category, Group, and Audience. The current Items property on my gallery is:
Filter(Collection1,Category = CategoryDD.Selected.Result)
This works. When I preview the app, and make a selection in the Category dropdown, the items that have that particular category appear as expected. I need to add the same logic for the Group (GroupDD) and Audience (AudienceDD) dropdowns, but I don't know how to do it. I feel like there should be a way to do an "And", but maybe I'm barking up the wrong tree. I'd appreciate any feedback. Thanks guys!!
Hi @TMaith ,
Maybe you could try the following formula:
Filter(Collection1,Category =CategoryDD.Selected.Result,Group=GroupDD.Selected.Result,Audience =AudienceDD.Selected.Result)