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
LookUp returns a single record.
- ✗
Sorts array1 by Status in ascending order
Why it's wrong here
Sort is a different function.
- ✓
Returns all records from array1 where Status is 'Active'
Why this is correct
Filter returns matching records.
- ✗
Searches array1 for the text 'Active' in any column
Why it's wrong here
Search function is for substring matching.
Go deeper
Related to this question
About these practice questions
Courseiva writes every PL-900 question from scratch — 904 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.