Demonstrate the capabilities of Power Apps →easyMultiple ChoiceObjective-mapped

PL-900 Demonstrate the capabilities of Power Apps Practice Question

Exhibit

{
  "name": "Filter",
  "parameters": [
    {
      "name": "source",
      "type": "table",
      "description": "The data source to filter"
    },
    {
      "name": "formula",
      "type": "boolean",
      "description": "A boolean expression to evaluate for each record"
    }
  ],
  "returnType": "table"
}

Refer to the exhibit. The JSON describes a Power Apps function. Which call to this function will return a table of records where the 'Status' column equals 'Active'?

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

✓

Filter(Accounts, Status = 'Active')

The Filter function in Power Apps takes the data source as the first argument and a formula as the second argument. Option B correctly uses Filter(Accounts, Status = 'Active'). Option A is incorrect because 'Active' alone is not a valid formula. Option C has the arguments reversed. Option D has the formula as the first argument and the source as the second, which is invalid.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✗
Filter(Accounts, 'Active')
Why it's wrong here
Second parameter must be a boolean expression, not a string.
✓
Filter(Accounts, Status = 'Active')
Why this is correct
Correct syntax: source then boolean formula.
✗
Filter('Active', Accounts)
Why it's wrong here
First parameter must be a table.
✗
Filter(Status = 'Active', Accounts)
Why it's wrong here
Parameters are in wrong order.

Go deeper

PL-900 Demonstrate the capabilities of Power Apps Practice Question

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question