PL-900 Demonstrate the capabilities of Power Apps Practice Question
A maker builds a canvas app that reads from a SharePoint list containing 50,000 rows. Users report the gallery shows only a subset of records and search results are incomplete. The maker needs the app to return complete results for filter and search operations. What should the maker do?
⚠ Common exam trap
The trap here is believing the data row limit setting removes the delegation cap, when that setting only affects local processing and cannot exceed 2000.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Rewrite queries to use only delegable functions and operators for SharePoint
Delegation is the mechanism that lets Power Apps hand processing to the data source. SharePoint supports a specific set of delegable functions and operators. When a query uses only those, all matching rows are processed server-side regardless of list size. When it uses a non-delegable expression, processing happens on the device and is limited, which explains the partial gallery and incomplete search results.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Add a second SharePoint data source pointing to the same list
Why it's wrong here
Adding the same list twice does not change delegation behavior; each connection still applies the same limits and delegable-operation rules. The app would simply have duplicate connections with identical constraints. This cannot make filter and search results complete, so the underlying delegation problem remains.
- ✗
Increase the app's data row limit setting to the maximum value
Why it's wrong here
The data row limit setting only raises the cap for local, non-delegable processing, and it tops out at 2000. It never makes a non-delegable query return all 50,000 rows. Raising it can also degrade performance because more records are pulled to the device, so it is not the correct fix.
- ✗
Enable the SharePoint list's versioning settings
Why it's wrong here
Versioning controls how many historical versions of each list item are retained; it has no effect on how many rows a canvas app query retrieves. Turning it on or off does not change the delegation limit or make filter and search operations complete. It addresses audit history, not query completeness.
- ✓
Rewrite queries to use only delegable functions and operators for SharePoint
Why this is correct
When a query is delegable, Power Apps pushes the operation to SharePoint and processes all rows server-side. Non-delegable expressions are evaluated locally and capped at the delegation limit, so only a subset returns. Restricting Filter, Search, and Sort to SharePoint-delegable constructs makes results complete across the 50,000 rows.
Go deeper
Related to this question
About these practice questions
One of 701 original PL-900 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Microsoft exam blueprint
This PL-900 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PL-900 exam.