PL-900 Demonstrate the capabilities of Power Apps Practice Question
A company is building a canvas app to track sales leads. The app must display a count of leads grouped by status (New, Contacted, Qualified, Closed). Which data source and visualization control should the app maker use to meet this requirement?
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
✓
Add a Gallery control with Items = GroupBy(Leads, Status), then add a Label showing CountRows(ThisItem.AllItems).
Using a Gallery control with GroupBy(Leads, Status) groups the leads by status, and adding a Label with CountRows(ThisItem.AllItems) displays the count for each group, meeting the requirement to display counts per status. Option A is incorrect because a Data table control with GroupBy and CountRows in a column does not inherently group and aggregate correctly; the CountRows function would need to be applied per group, which is more complex. Option C is incorrect because a Form control is for data entry, not aggregating and displaying grouped counts. Option D is incorrect because a Pie chart control can show proportions but requires an aggregated data source; directly connecting to a SharePoint list without grouping may not display counts correctly, and the description of 'Values as Count of Status' is ambiguous and not directly supported by the chart control without pre-aggregation.
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 Data table control and set the Items property to GroupBy(Leads, Status) and use CountRows in a column.
Why it's wrong here
Data table does not support grouping natively; GroupBy returns a table of groups that cannot be directly displayed in a data table.
- ✓
Add a Gallery control with Items = GroupBy(Leads, Status), then add a Label showing CountRows(ThisItem.AllItems).
Why this is correct
GroupBy groups records by Status, and CountRows(ThisItem.AllItems) counts records in each group.
- ✗
Add a Form control bound to the Leads list and use the Status field to filter records.
Why it's wrong here
A form is for data entry/edit, not for aggregated display.
- ✗
Add a Pie chart control connected to the SharePoint list, configure the Legend field as Status and Values as Count of Status.
Why it's wrong here
A pie chart shows proportions, not exact counts per status.
Go deeper
Related to this question
About these practice questions
This PL-900 question is part of Courseiva's 904-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 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.