My Power App search works in testing but misses SharePoint records when the list grows

Power Apps search works in testing but misses SharePoint records once lists exceed the local row limit. Nondelegable formulas process only a subset of data locally, so galleries return incomplete results for real users.