Post

Power Apps: Diagnose incomplete search results step by step

Diesen Beitrag auf Deutsch lesen

A step-by-step method to find why a Power Apps search screen skips valid records, covering delegation, row limits, connector support, filters and user access.

Original article from November 14, 2026: Power Apps: Diagnose Incomplete Search Results for Business Users, by Softchief, on Softchief Technologies. Read the original

This is our own summary, not a republication or full translation.

Schematic view of the steps described by Softchief Technologies, not a screenshot.

TL;DR

When a Power Apps search screen skips a valid record, delegation is a prime suspect: a nondelegable query processes at most the data row limit, 500 by default, and raising it to 10,000 does not make the query reliable. Compare the missing record with a working one, check which fields the formula searches, test filter logic, then retest under the affected user's account.

Why it matters

  • Makers: Start from one reported missing record, inspect the Items formula for delegation warnings, and match the query pattern to your connector before changing anything.
  • Admins/IT: Confirm which environment and data source the app reads and review row-level access rules, since an admin may see records the user cannot.
  • Leadership/Business: Ask users to report one concrete missing record with their exact search text so makers can verify the fix under the same account.

Frequently asked questions

Why does my Power Apps search not find a record that exists?

Usually delegation, formula logic, stale data or the user's access rules. Start with one missing record and trace it through the source, the formula and the screen.

What is the default data row limit for non-delegable queries in Power Apps?

500 records by default. The app setting can be raised up to 10,000, but the source warns a higher limit does not make an unsupported query reliable.

Which search functions are delegable for SharePoint and SQL Server in Power Apps?

Microsoft guidance cited in the post lists StartsWith for SharePoint text fields and both Search and StartsWith for SQL Server text, so check the delegation table per connector.

Summary by KMUpower, licensed under CC BY 4.0 . Rights to the original article remain with its author.