A remote source can contain more rows than the app downloads for a nondelegable expression. The limit applies before the local filter, so the gallery can show only a few results and still omit a late matching record. A fast screen or a small visible count does not prove completeness.
This course models a conservative SharePoint-style and Dataverse-style profile. Supported equality and prefix filters run over all supplied source rows; unsupported expressions use the configured source prefix first. Microsoft’s current English documentation lists a default500 and configurable maximum10000, but tenant rollout and connector support still need checking. The local fixture uses a smaller cap to make the failure visible with original records.