Introduction Dropdown controls are essential for filtering and navigation in Power Apps. A common requirement is to display only distinct values from a data source (like a SharePoint list) and include a default ‘All’ option for easy selection. This post shows how to build a Power Apps dropdown with unique values and a default ‘All’ using PowerFx. Scenario Suppose you have a SharePoint list called FolderMappingDetails with a column named Database.

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: