PowerApps SharePoint list delegation filter
Power Apps Search Function Delegation Warning Workarounds
Search is one of the most requested app features, however, the Power Apps search function has one major limitation. It cannot find any results past the 2,000th row in a table due to delegation. So how do can we perform searches in Power Apps and help users find the information they need? In this article I will show you all known Power apps Search function delegation warning workarounds. Show
Introduction: The Car Inventory Search AppThe Car Inventory Search app is used by salespeople at a car dealership to determine which cars are currently in inventory. Make The Car Inventory Search AppCreate a new SharePoint list calledCar Sales Inventorywith the following columns:
Include this data in the list:
(3,000 rows)
Write A Search Function With A Delegation WarningWhen a user types their search terms into the search bar the gallery below updates to show only matching results.
Search Function Delegation Warning WorkaroundsThere are 3 delegation workarounds for the Search Function: 1. StartsWith Delegation Workaround For The Search FunctionWhile the Search function cannot be delegated in SharePoint the StartsWith function can. This means we can make a search bar that looks at the start of every word and shows all results in the gallery. The trade-off is any words found in the middle of a text column will not be returned when searching.
2. Search + Filter Delegation Workaround For The Search FunctionAnother workaround is to pre-filter the results on some criteria that will return less than 2,000 rows and then perform the search on that smaller chunk of data. The car inventory has 3,000 rows for cars which are located in 5 cities. We know that any city selected will return less that 2,000 rows so its OK to use this workaround.
3. Dataverse IN Operator Delegation Workaround For Search FunctionIf we require full search capabilities the final workaround is to change the datasource from SharePoint to Dataverse For Teams (which also does not require premium licensing). The IN operator can be delegated in Dataverse and can check the contents of a column for a matching text string. This feature is still in Preview so we must enable it by going to File > Advanced Settings > Upcoming Features > Preview.
Did You Enjoy This Article?Subscribe at the bottom of this page to have new articles sent directly to your inbox the moment I post them.
|