Which Power Automate Components Log Support Emails to Excel?
DRAG DROP
A company uses Microsoft Power Platform to manage support tickets.
Customers submit support requests by sending an email to a support email address.
All high-priority emails must be logged into a Microsoft Excel sheet for historical purposes.
You need to identify the components that are required for logging the emails in Excel.
Which components should you use? To answer, drag the appropriate components to the correct requirements. Each component may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Community Insight
Tested: distinguishing Power Automate triggers from actions and connectors. The trap is choosing Connector for the Excel write step, but writing data to Excel is performed by an Action provided by the Excel connector.
This PL-900 drag-and-drop question tests Power Automate components: trigger, action, and connector. The correct mapping logs high-priority support emails to Excel using a Trigger and two Actions.
Many learners select Connector for the third slot because they think connecting to Excel is the requirement. However, the connector only enables the action; the actual logging step is an Action (e.g., Excel 'Add a row into a table').
Community Discussion (14 comments)
Comments & Corrections
No comments yet — spotted an error or have a note? Share it below.
Expert Analysis
Why the Answer Is Correct
The scenario requires a flow that starts on a new support email, evaluates whether it is high priority, and then logs it to Excel. In Power Automate, the component that starts a flow is a Trigger, so the first requirement maps to Trigger. The priority evaluation is a logical step performed by an Action (such as a Condition). Writing the email details to Excel is also a task performed by an Action (e.g., the Excel "Add a row into a table" action). Therefore, the correct selection is Trigger, Action, Action.Why Other Candidate Answers Are Wrong
A common alternative is to place Connector in the third slot because the Excel connector is needed to access the Excel service. However, a connector is not a flow step; it is the underlying service connection that provides actions. The requirement "log the email to Excel" describes what the flow does, which is an Action, not the connection itself. As adamer noted, Microsoft Learn states: "To write data to an Excel spreadsheet, use the Write to Excel worksheet action." Choosing Connector would misidentify the component that performs the logging. Similarly, some might put Connector for the second slot, but checking priority is a built-in Action, not a connector.Community Comment Notes
The community is divided, but the highest-voted answer, posted by AZ_Guru_Wannabe, is "Trigger Action Action." ziggy1117 argues for "Trigger, action, connector" and states that "for #3, you need a connector first to excel before you can create an action," but this conflates the service connection with the flow step. adamer counters that the third should be Action, quoting Microsoft Learn: "To write data to an Excel spreadsheet, use the Write to Excel worksheet action." storziberica notes the confusion between desktop flows (where it is an action) and cloud flows (where the option is via a connector), but for a cloud flow the action is still the component that logs the data. Overall, the official documentation and the top community answer support Trigger, Action, Action.Official Reference
Exam Strategy
Memorize the three core Power Automate components: Trigger (starts the flow), Action (does the work), and Connector (provides access to a service). In drag-and-drop questions, map each requirement to the component that directly performs the task—writing to Excel is an Action, not a Connector. Remember a flow has only one Trigger but can have many Actions.
Frequently Asked Questions
Why is the third component an Action and not a Connector for logging to Excel?
The Excel connector enables access, but the step that writes the row is an Action. Microsoft Learn states to use the Write to Excel worksheet action.
Does checking high-priority email require a Connector or an Action?
It requires an Action, such as a Condition, because the flow must evaluate the email's priority as a logical step. A Connector is not the component performing the check.
Related Analysis
Practice All PL-900 Questions
Access 130 questions with complete answers and detailed explanations.
View Full PL-900 Practice Test →