PL-900 Practice Question: Demonstrate the capabilities of Power Automate
You are a business analyst at a logistics company. The operations team uses a Microsoft Excel workbook stored in OneDrive for Business to track daily shipment statuses. They want an email notification sent automatically whenever a shipment's status is updated to 'Delayed' in that workbook. You need to build a Power Automate cloud flow that triggers only on that specific change. Which trigger should you use?
⚠ Common exam trap
The trap here is assuming any OneDrive file-change trigger can detect edits inside an Excel workbook, when only the Excel Online (Business) row-level trigger provides the table row values needed for conditional logic.
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
✓
When a row is added, modified or deleted – Excel Online (Business)
The Excel Online (Business) connector includes a trigger that watches a table inside a workbook for row additions, modifications, or deletions. Because the operations team edits an existing row's status, this trigger detects the change and surfaces the updated row values. That allows the flow to check whether the new status equals 'Delayed' and then send the email. File-level triggers cannot inspect row content, and SharePoint triggers apply to a different data store.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
When a file is modified (properties only) – OneDrive for Business
Why it's wrong here
This trigger detects changes to file metadata, such as when the file itself is modified, but it does not provide row-level details from within the Excel table. It cannot tell you which shipment status changed or to what value, making it impossible to conditionally send an email only when the status becomes 'Delayed'. A row-level Excel trigger is needed instead.
- ✓
When a row is added, modified or deleted – Excel Online (Business)
Why this is correct
This Excel Online (Business) trigger monitors a table in a workbook stored in OneDrive for Business or SharePoint. It fires when a row in the specified table is added, modified, or deleted. Since the shipment status is updated in an existing row, this trigger detects the change and can pass the updated row values to subsequent actions, enabling the conditional email notification.
- ✗
When an item is created – SharePoint
Why it's wrong here
This trigger is specific to SharePoint lists and fires when a new list item is created. The shipment data resides in an Excel workbook, not a SharePoint list, so this trigger cannot monitor it. Even if the workbook were stored in a SharePoint document library, the trigger would not detect cell edits. It is the wrong connector and the wrong event type for this requirement.
- ✗
When a file is created (properties only) – OneDrive for Business
Why it's wrong here
This trigger fires when a new file is added to a OneDrive folder, not when an existing Excel row is modified. In this scenario, the workbook already exists and the team edits a cell value, so no new file is created. Using this trigger would never fire for status updates, leaving the operations team without notifications. A different trigger designed for table row changes is required.
Go deeper
Related to this question
About these practice questions
This PL-900 question is part of Courseiva's 701-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 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.