PL-900 Demonstrate the capabilities of Power Apps Practice Question
A maker is building a canvas app that connects to a SharePoint list containing 20,000 items. Users report that a gallery showing filtered results displays only part of the expected records, and some filters seem to be ignored. The maker wants the app to return accurate results for the filtered queries. What should the maker do?
⚠ Common exam trap
The trap here is assuming that raising the data row limit fixes missing results, when the real problem is that non-delegable queries are processed locally against only a subset of records.
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
✓
Rework the queries to use delegable functions and operators supported by the SharePoint connector
Delegation is the mechanism that lets Power Apps push filtering, sorting, and other operations to the data source instead of processing them locally on a limited set of records. When a function or operator is not delegable for SharePoint, results can be incomplete or filters ignored. Rewriting queries with delegable functions ensures the data source returns the correct filtered set, which resolves the reported symptoms.
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 ClearCollect function that loads all 20,000 items into a collection when the app starts
Why it's wrong here
Loading all items into a collection at startup can be slow and memory-intensive, and the initial collection population may itself be subject to the same retrieval limit. It does not fix the delegation problem for the source query and can create a poor user experience. The gallery would still depend on how the collection was populated, so accuracy is not guaranteed.
- ✓
Rework the queries to use delegable functions and operators supported by the SharePoint connector
Why this is correct
When a query cannot be delegated, Power Apps processes only a limited set of records locally, which can cause missing results and ignored filters. SharePoint supports delegation for certain functions and operators, so rewriting filters to use those delegable constructs allows the data source to perform the filtering and return the complete, accurate result set for the gallery.
- ✗
Set the app's data row limit to the maximum value and leave the existing filters unchanged
Why it's wrong here
Increasing the data row limit raises the number of records retrieved for local processing, but it does not make non-delegable filters work correctly and can degrade performance. The underlying issue is that the data source is not executing the query, so simply retrieving more rows does not guarantee accurate or complete filtered results and may worsen loading times.
- ✗
Replace the SharePoint list with an Excel workbook stored in OneDrive
Why it's wrong here
Moving the data to an Excel workbook does not solve delegation; Excel as a data source has its own delegation limitations and is generally less capable than SharePoint for large datasets. The gallery could still return incomplete results, and the migration would add effort without addressing the root cause of non-delegable queries.
Visual reference
Go deeper
Related to this question
About these practice questions
This PL-900 question is part of Courseiva's 701-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. 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.