PL-900 Demonstrate the capabilities of Power Apps Practice Question
A manufacturing company uses Power Apps to manage inventory. The app includes a main screen that displays a gallery of inventory items, a detail screen for editing item properties, and a form screen for adding new items. The app uses a SharePoint list as the data source. Recently, users reported that when they edit an item on the detail screen and save, the changes do not appear in the gallery until they manually refresh the app. Additionally, some users occasionally encounter a 'Delegation warning' when filtering the gallery by item name. The app is shared with 200 users, and performance is becoming an issue. You need to resolve these issues. Which action should you take?
⚠ Common exam trap
Many candidates think delegation warnings are solved by increasing the data row limit (Option C) or by switching data sources (Option D), when in fact the root cause is the use of non-delegable queries on unindexed columns, which can be fixed by proper filtering and indexing.
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
✓
Modify the detail screen's Save button to use the Refresh() function on the gallery's data source after the form submission, and change the gallery's Items property to use a Filter query on an indexed SharePoint column to avoid delegation.
The Refresh() function after form submission ensures the gallery's data source is updated immediately, eliminating the need for manual refresh. Changing the gallery's Items property to use a Filter query on an indexed SharePoint column avoids delegation warnings by ensuring the query can be processed server-side, as SharePoint supports delegation only for indexed columns and certain operators.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Convert the model-driven app to a canvas app to gain more control over data refresh and delegation.
Why it's wrong here
The app is already a canvas app (based on the description); converting does not solve the issues.
- ✓
Modify the detail screen's Save button to use the Refresh() function on the gallery's data source after the form submission, and change the gallery's Items property to use a Filter query on an indexed SharePoint column to avoid delegation.
Why this is correct
Refresh() updates the gallery with the latest data, and using Filter on an indexed column allows delegation, removing the warning and improving performance.
- ✗
Increase the data row limit in Power Apps settings to 2000 to prevent delegation warnings.
Why it's wrong here
Increasing the data row limit does not remove delegation warnings; it only increases the number of records retrieved, and the warning persists if the filter cannot be delegated.
- ✗
Migrate the data source from SharePoint to Microsoft Dataverse to eliminate delegation warnings and improve performance.
Why it's wrong here
Migrating to Dataverse is a major change and not required; delegation warnings can be resolved by optimizing the query.
Visual reference
Go deeper
Related to this question
About these practice questions
One of 904 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 by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
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.