MS-900 Describe Microsoft 365 apps and services Practice Question
A marketing manager wants to create a mobile-friendly app that field sales representatives can use to submit expense reports with photos of receipts. The app should automatically save the data to a SharePoint list and send an email notification to the manager. Which two Microsoft 365 technologies should the developer use to build this solution? (Choose two.)
⚠ Common exam trap
A common mix-up: candidates confuse SharePoint as a development tool for building apps, when in reality it is only a data storage service, while Power Apps and Power Automate are the actual low-code development and automation technologies required.
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 Apps
Microsoft Power Apps is correct because it enables rapid development of mobile-friendly apps with minimal code, allowing field sales representatives to capture expense data and receipt photos directly from their devices. It integrates seamlessly with SharePoint lists for data storage, making it the ideal low-code platform for this custom business app.
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 Apps
Why this is correct
Power Apps is the low-code platform purpose-built for creating custom mobile-friendly apps. You can design a canvas app with a responsive layout, add screens for capturing receipt photos and numeric data, and bind those controls directly to a SharePoint list through the SharePoint connector. This gives the marketing manager a real app interface without writing traditional code, making it the correct tool for the app-building requirement.
- ✓
Microsoft Power Automate
Why this is correct
Power Automate is correct as the companion workflow service in this scenario, because it can watch the SharePoint list and react to new items automatically. When a receipt record or attachment is added, a cloud flow can trigger and send an email notification to the marketing manager, or even post a message to a Teams channel. Power Automate does not create the user interface, but it provides the automation layer that fulfills the notification requirement, especially when triggered from a Power Apps button.
- ✗
Microsoft SharePoint
Why it's wrong here
SharePoint is the wrong choice for building the app because it is a collaboration and document-management platform, not an application-development environment. It can serve as the backend data storage by holding receipt entries in a list or library, but it cannot define the mobile form layout, provide camera controls, or enforce the user experience the manager needs. Without Power Apps to construct the app, SharePoint alone only stores data and cannot deliver a custom mobile-friendly interface.
- ✗
Microsoft Power BI
Why it's wrong here
Power BI is a data visualization and business intelligence tool, so it is incorrect for creating an app or automating a workflow. It can connect to the SharePoint list later to build dashboards that summarize receipts or spending trends, and its mobile app only lets users view and interact with published reports. It has no mechanism for capturing user input through a custom mobile form or for sending an email when a new list item is created, so it fails both the app-creation and automation requirements.
Go deeper
Related to this question
Learn chapter
Microsoft Access and Power Apps Comparison
Key term
Power Apps
Power Apps is a low-code platform from Microsoft that allows users to build custom business applications without needing traditional programming skills.
Key term
Microsoft 365
Microsoft 365 is a subscription-based cloud service from Microsoft that combines productivity tools like Office apps with security, device management, and online storage.
About these practice questions
Courseiva writes every MS-900 question from scratch — 794 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 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.