PL-900 Demonstrate the capabilities of Power Apps Practice Question
Exhibit
Refer to the exhibit. Filter(array1, Status = "Active")
Refer to the exhibit. A Power Apps canvas app uses the Filter function as shown. What does this expression do?
⚠ Common exam trap
Many exam-takers confuse Filter with First or Search, mistakenly thinking Filter returns a single record or performs a text search, when in fact it returns all records matching an exact column condition.
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
✓
Returns all records from array1 where Status is 'Active'
The Filter function in Power Apps returns a table of records that meet the specified condition. In this expression, Filter(array1, Status = "Active") evaluates each record in array1 and includes only those where the Status column equals 'Active'. This is correct because Filter always returns all matching records, not just the first one.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Returns the first record from array1 with Status 'Active'
Why it's wrong here
Filter returns all matching records as a table, not the first record; First would return a single record. It is tempting because Filter does narrow by Status, and it would be correct when the requirement is specifically to retrieve the initial matching row rather than the full matching set.
- ✗
Sorts array1 by Status in ascending order
Why it's wrong here
Filter selects rows meeting a condition; it does not reorder output, and no sort argument exists in the expression. It is tempting because the Status column appears in the formula, and SortByColumns would be correct when the requirement is to order records by a column.
- ✓
Returns all records from array1 where Status is 'Active'
Why this is correct
The Filter function evaluates each record in array1 against the predicate Status = "Active", returning only matching rows. This satisfies the stem's requirement to identify the expression's behaviour: a row-level filter on the Status column, excluding records with any other status value.
- ✗
Searches array1 for the text 'Active' in any column
Why it's wrong here
Filter evaluates the named column Status against the literal 'Active'; it does not scan every column for text. It is tempting because both are table-shaping functions, and Search would be correct when the requirement is to match a term across multiple columns.
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 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.