Two Dropdown filters with ability to use "All" to see no filter RRS feed

  • Question

  • I have an app I am creating that allows you to look up vendors in different regions and by different categories (hardware, hotel, etc.). Where I am stuck is how could you make it where the user can look up "View All Regions" in combination with a specific region and vice versa?

    Any help is appreciated!

    SortByColumns(If(Dropdown1.Selected.Value="View All Categories" && Dropdown2.Selected.Value="View All Regions", Source1, Filter(Source1, Dropdown1.Selected.Value in Category.Value && Dropdown2.Selected.Value in Region.Value)),"Modified", If(SortDescending1, Ascending, Descending))

    Wednesday, May 16, 2018 11:59 AM