Introduction Filtering and searching data in a Power Apps gallery is a common requirement for building user-friendly business apps. This post shows how to combine a dropdown filter (with an ‘All’ option) and a search box to create a flexible, responsive gallery experience. Scenario Suppose you have a collection called colFolderMapping with a field named Database and a gallery displaying items. You want users to: Select a database from a dropdown (or ‘All’ to show everything) Search for items by title using a search box See results update instantly in the gallery PowerFx Formula Here’s the formula for the gallery’s Items property: