Introduction When building Power Apps with SharePoint lists, you may encounter delegation warnings especially when using the Search function on large datasets. This post explains why delegation matters, how it affects your app, and practical workarounds to enable effective searching. The Delegation Problem By default, if you create an app using the built-in template connected to a SharePoint list, the gallery’s Items property might be set to: Search([@FolderMappingDetails], SearchInput1.Text, Title, Title) This triggers a delegation warning because the Search function is not fully delegable to SharePoint.

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: