PL-900 Demonstrate the capabilities of Power Apps Practice Question
A business analyst wants to create an app that uses a SharePoint list as its data source. They need to include conditional formatting to highlight overdue tasks. Which type of app should they use?
⚠ Common exam trap
PL-900 often tests the distinction between canvas and model-driven apps, where candidates might think model-driven apps support conditional formatting or that Power BI can be used for app creation.
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
✓
Canvas app
A canvas app is the correct choice because it allows full control over the user interface and supports conditional formatting using Power Apps formulas. The business analyst can connect to a SharePoint list and use functions like If and Color to highlight overdue tasks based on due dates. Canvas apps are ideal for custom designs and data-driven formatting.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Power Virtual Agents chatbot
Why it's wrong here
Power Virtual Agents builds conversational bots, which cannot render a SharePoint list with conditional row formatting. It is tempting when automation or chat is desired, but canvas apps bind directly to SharePoint and support conditional formatting rules on controls.
- ✗
Model-driven app
Why it's wrong here
Model-driven apps require Dataverse tables, not SharePoint lists as their primary data source, and their forms offer limited conditional formatting. It is tempting for structured data, but canvas apps connect natively to SharePoint and allow formula-driven formatting of individual controls.
- ✓
Canvas app
Why this is correct
Canvas apps give the maker direct control over each control's properties, so conditional formatting such as highlighting overdue tasks uses formulas on the gallery's colour properties. Model-driven apps render forms from metadata and cannot express this per-record styling requirement.
- ✗
Power BI report
Why it's wrong here
Power BI reports visualise and analyse data but are read-only; users cannot edit SharePoint list items or apply app-style conditional formatting to input controls. It is tempting for highlighting overdue items, but a canvas app is required for interactive list editing with conditional formatting.
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 and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Microsoft exam blueprint
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.