PL-900 Demonstrate the capabilities of Power Apps Practice Question
A company is building a canvas app to track inventory. The app needs to display the current stock level from a SharePoint list and allow users to update quantities via a form. Which connector should be used to read and write data?
⚠ Common exam trap
PL-900 often tests the confusion between data sources and automation tools, leading candidates to pick Power Automate when direct data access is needed, or to overcomplicate by choosing Dataverse when the data is already in SharePoint.
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
✓
SharePoint connector
The SharePoint connector is the correct choice because it provides native, bidirectional access to SharePoint lists, which are the data source described in the scenario. It supports both reading current stock levels (via Get items) and writing updates (via Create item or Update item) directly from a canvas app. Since the inventory data already resides in a SharePoint list, this connector is the most direct and appropriate integration point. Other connectors either serve different services or are not designed for direct data manipulation in this context.
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 Automate connector
Why it's wrong here
The Power Automate connector triggers flows rather than exposing SharePoint list operations as a data source, so galleries and forms cannot bind to it. It is tempting because flows automate SharePoint updates, and it would be correct if the app only needed to kick off a background process, not read and write records directly.
- ✓
SharePoint connector
Why this is correct
The SharePoint connector provides native read and write operations against SharePoint lists, so it satisfies the requirement to display current stock levels and update quantities through a form. It authenticates via Microsoft Entra ID and exposes list items directly, avoiding custom API development.
- ✗
Microsoft Dataverse connector
Why it's wrong here
The inventory data lives in a SharePoint list, and Dataverse cannot read that list without first migrating the data into Dataverse tables. It is tempting because Dataverse offers stronger relational modelling, and it would be correct if the app were being built on Dataverse from the outset.
- ✗
Microsoft Teams connector
Why it's wrong here
The Teams connector surfaces channels, chats and messages, not SharePoint list rows, so it cannot supply stock levels or accept quantity updates. It is tempting because Teams is where users work, and it would be correct for posting notifications or adaptive cards into a channel rather than reading inventory records.
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 →
Same concept, more angles
1 more way this is tested on PL-900
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. A user built a canvas app that uses a SharePoint list. When they add the app to a Teams channel, some users cannot see the data. The app works fine when opened directly from Power Apps. What is the most likely cause?
medium- A.The users do not have Power Apps licenses assigned
- B.The app uses a deprecated connector
- ✓ C.The users do not have permissions to the underlying SharePoint list
- D.The SharePoint connector requires a Premium license in Teams
Why C: The most likely cause is that users do not have permissions to the underlying SharePoint list. When the app is accessed via Teams, the app runs in the context of the user, and SharePoint permissions are enforced. Even though the app works when opened directly from Power Apps (if the user has permissions), adding it to a Teams channel may expose users who lack access to the list. Option A is incorrect because licenses are per user and not specific to Teams; if users have Power Apps licenses, they can use the app. Option B is incorrect because the app works outside Teams, so the connector is not deprecated. Option D is incorrect because the SharePoint connector does not require a Premium license in Teams.
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.