PL-900 Practice Question: Demonstrate the capabilities of Power Automate
A support team wants a Power Automate cloud flow that, when a new high-priority support ticket is created in a SharePoint list, notifies the on-call engineer in Microsoft Teams and logs the ticket ID to an Excel workbook stored in OneDrive for Business. The team needs the flow to run without user interaction. Which two actions or features does the flow require to meet these requirements? (Choose two.)
⚠ Common exam trap
The trap here is adding an approval action, which sounds like good governance but violates the explicit no-user-interaction requirement.
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
✓
A 'Post message in a chat or channel' action from the Microsoft Teams connector
Meeting the scenario requires one action to send the Teams notification and one action to append the ticket ID to the Excel table. Both are cloud connector actions that execute unattended, which aligns with the requirement for no user interaction and directly fulfills the notification and logging outcomes.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
An on-premises data gateway to reach the SharePoint list
Why it's wrong here
SharePoint Online list triggers and actions are cloud services reachable directly through the SharePoint connector without any gateway. A gateway is only needed for on-premises data sources, so it is unnecessary here and would add complexity without enabling the required Teams notification or Excel logging.
- ✓
A 'Post message in a chat or channel' action from the Microsoft Teams connector
Why this is correct
Notifying the on-call engineer in Microsoft Teams requires the Teams connector's messaging action, which can post an adaptive card or message to a channel or chat. Without this action the flow cannot deliver the notification, so it is one of the two required components for the described scenario.
- ✗
A scheduled Recurrence trigger set to run every minute
Why it's wrong here
A Recurrence trigger runs on a time schedule rather than in response to a new ticket, and it cannot inspect ticket priority at creation. The scenario needs event-driven execution when a high-priority item is created, so a polling schedule is the wrong trigger type and would not satisfy the automation goal.
- ✓
An 'Add a row into a table' action from the Excel Online (Business) connector
Why this is correct
Logging the ticket ID to an Excel workbook in OneDrive for Business requires the Excel Online (Business) connector's row-insertion action targeting the workbook and table. This action writes the record; without it, no log entry would be created, making it the second required component.
- ✗
A 'Start and wait for an approval' action to confirm ticket severity
Why it's wrong here
Approvals introduce a human interaction step that pauses the flow until someone responds. The scenario requires the flow to run without user interaction, so adding an approval contradicts the requirement and would delay notification and logging rather than enabling them.
Go deeper
Related to this question
About these practice questions
One of 701 original PL-900 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.