PL-900 Demonstrate the capabilities of Power Apps Practice Question
A company has a canvas app that uses a SharePoint list as its data source. The list contains 8,000 items. Users report that the app's gallery only shows the first 100 items when they scroll. The app's gallery Items property is set to Filter(Expenses, Status = "Pending"). What should the maker do to ensure all pending items are displayed?
⚠ Common exam trap
The trap here is assuming that increasing the data row limit or SharePoint threshold will solve the issue, when the real problem is delegation and the query must be rewritten to be delegable.
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
✓
Change the gallery Items property to use the Filter function with a delegable condition and ensure the data source supports delegation.
When a canvas app uses a non-delegable query against a large data source, Power Apps retrieves only a limited number of records (default 100, configurable up to 2000). The proper fix is to use a delegable query, such as filtering on a column that the SharePoint connector can delegate, so that the data source processes the filter and returns all matching records. This ensures all pending items are shown.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Set the gallery's LoadingSpinnerColor property to a visible color to indicate more items are loading.
Why it's wrong here
Changing the loading spinner color only affects the visual indicator and does not change how many records are retrieved. The underlying delegation problem remains, so users would still see only the first 100 items. This is a cosmetic change, not a functional fix for the data retrieval limit.
- ✗
Increase the app's data row limit setting from 100 to 8000 in the advanced settings.
Why it's wrong here
The data row limit setting in Power Apps controls the maximum number of records returned for non-delegable queries, but it has a maximum value of 2000. Setting it to 8000 is not possible, and even at 2000 it would not retrieve all 8000 items if the query is not delegable. This does not solve the root cause.
- ✓
Change the gallery Items property to use the Filter function with a delegable condition and ensure the data source supports delegation.
Why this is correct
The issue is that the Filter function on the Status column may not be delegable with the SharePoint connector, causing Power Apps to retrieve only the first 100 records. By using a delegable condition and confirming the connector supports delegation for that operation, the app can retrieve all matching items from the 8,000-item list.
- ✗
Increase the SharePoint list view threshold in the SharePoint admin center.
Why it's wrong here
The SharePoint list view threshold is a server-side limit that affects views and queries, but changing it does not address the Power Apps delegation limit. The gallery would still be limited by the connector's delegation capabilities, so this action does not solve the problem and may impact SharePoint performance.
Go deeper
Related to this question
About these practice questions
Courseiva writes every PL-900 question from scratch — 701 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or 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.