MS-900 Describe Microsoft 365 apps and services Practice Question
A sales team uses SharePoint Online to store contract templates. When a new contract is added to a specific library, a notification should be sent to a Microsoft Teams channel with a direct link to the document. Additionally, the contract owner must receive a custom approval request via email before the document is shared externally. Which Microsoft 365 services must be combined to achieve this?
⚠ Common exam trap
Test-takers frequently assume Microsoft Teams alone can handle notifications and approvals, but Teams lacks native workflow automation for SharePoint events, requiring Power Automate as the orchestration layer.
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
✓
Microsoft Power Automate and Microsoft Teams
Microsoft Power Automate can trigger a flow when a new contract is added to a SharePoint Online library, sending a notification with a direct link to a Microsoft Teams channel. Additionally, Power Automate can initiate a custom approval request via email to the contract owner before external sharing is allowed. This combination directly addresses both requirements without needing additional services.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Microsoft Power Automate and Microsoft Teams
Why this is correct
Power Automate is the correct choice because its SharePoint connector includes event-driven triggers such as "When a file is created or modified" in a document library. You can then use Teams actions to post a notification or adaptive card to a specific channel, and optionally add an email step. This provides exactly the automated contract-template workflow the sales team needs, with no custom code required.
- ✗
Microsoft Teams and Microsoft Power Apps
Why it's wrong here
Power Apps is designed for building custom canvas or model-driven apps that interact with data sources such as SharePoint lists, but it is not a workflow automation service. A Power Apps app requires a user to open it and manually trigger logic, so it cannot independently monitor a SharePoint library for new files or proactively push a Teams notification. Therefore, pairing Teams with Power Apps fails to deliver the event-driven process described.
- ✗
Microsoft Forms and Microsoft Teams
Why it's wrong here
Microsoft Forms is a survey and data-collection tool that captures user input, not a system that watches a document library for file activity. While a form can write responses to a SharePoint list, it has no trigger for file creation or modification, nor can it execute actions like posting to a Teams channel without an external flow. Thus Forms and Teams cannot fulfill the contract-template notification scenario.
- ✗
Microsoft Power BI and Microsoft Teams
Why it's wrong here
Power BI is an analytics and visualization platform that can surface dashboards and reports in Teams, but it lacks the ability to react to file events in SharePoint. Even though Power BI has data-driven alerts, those alerts only fire on metric thresholds and cannot send a Teams message when a contract template is uploaded. Consequently, Power BI and Teams do not provide the file-triggered workflow automation required here.
Go deeper
Related to this question
Learn chapter
Power Apps: Low-Code Application Development
Key term
Microsoft Teams
Microsoft Teams is a collaboration platform that integrates chat, video meetings, file storage, and application integration into a single workspace, primarily used within the Microsoft 365 ecosystem.
Key term
SharePoint Online
SharePoint Online is a cloud-based collaboration platform from Microsoft that lets teams create, store, organize, and share content securely from anywhere.
About these practice questions
This MS-900 question is part of Courseiva's 794-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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 MS-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 MS-900 exam.