Demonstrate the capabilities of Power Automate →hardMultiple ChoiceObjective-mapped

Power Automate Trigger File Creation with Filter Extension: Step-by-Step

Exhibit

Refer to the exhibit. {
  "triggers": {
    "When_a_file_is_created_in_folder": {
      "type": "ApiConnection",
      "inputs": {
        "host": {
          "connectionName": "shared_sharepointonline",
          "operationId": "WhenFileCreatedInFolder"
        },
        "parameters": {
          "dataset": "https://contoso.sharepoint.com/sites/MySite",
          "table": "Shared Documents",
          "id": "/sites/MySite/Shared%20Documents/Incoming"
        },
        "authentication": "@parameters('$authentication')"
      },
      "conditions": [
        {
          "expression": "@equals(triggerOutputs()?['headers']?['x-ms-file-name-extension'], '.xlsx')"
        }
      ]
    }
  }
}

The exhibit shows a trigger definition for a Power Automate flow. What does this trigger do?

Quick Answer

The answer is D: the trigger fires when a .xlsx file is created in the 'Incoming' folder. This is correct because the trigger definition specifies a file creation event in the 'Incoming' folder, and the subsequent condition filters the trigger’s action to only proceed when the file extension equals .xlsx, meaning the flow will ignore any other file type created there. On the Microsoft Power Platform Fundamentals PL-900 exam, this scenario tests your ability to read a trigger definition and distinguish between the event itself and a filter condition applied to it—a common trap is confusing the trigger’s base event (any file creation) with the filtered result (only .xlsx). Remember that a filter extension narrows the trigger’s scope without changing the event type; think of it as a bouncer at a club who only lets in guests with a specific ticket. Memory tip: “Trigger the event, filter the file—.xlsx is the style.”

⚠ Common exam trap

Candidates may overlook the condition step that filters by file extension, assuming the trigger fires on any file creation without noticing the .xlsx filter.

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

✓

Triggers when a .xlsx file is created in the 'Incoming' folder.

The trigger is configured for file creation in the 'Incoming' folder with a condition that checks the file extension is .xlsx, so it only fires when an Excel file is created. Option A is wrong because the trigger filters for .xlsx files, not .csv files. Option B is wrong because the trigger does not fire for any file; it only fires for .xlsx files. Option C is wrong because the trigger is for file creation, not modification.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✗
Triggers when a .csv file is created in the 'Incoming' folder.
Why it's wrong here
Condition checks for .xlsx, not .csv.
✗
Triggers when any file is created in the 'Incoming' folder.
Why it's wrong here
Condition restricts to .xlsx files only.
✗
Triggers when a file is modified in the 'Incoming' folder.
Why it's wrong here
Trigger is 'WhenFileCreatedInFolder', not modified.
✓
Triggers when a .xlsx file is created in the 'Incoming' folder.
Why this is correct
Condition ensures only .xlsx files trigger the flow.

Go deeper

1 more way this is tested on PL-900

These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.

Variation 1. Refer to the exhibit. The JSON shows a trigger definition for a Power Automate flow. What will cause the flow to trigger?

medium

A.When an email with an attachment arrives
B.When a high-importance email arrives
C.When an email is modified in the Inbox
✓ D.When an email with 'Invoice' in the subject arrives in the Inbox

Why D: The trigger fires when a new email arrives in the Inbox with 'Invoice' in the subject. Option A is wrong because 'fetchOnlyWithAttachment' is set to false, so it will trigger even without attachments. Option B is wrong because 'importance' is set to 'Any', so it is not filtering by high importance. Option C is wrong because the trigger is on new email arrival, not on email modification.

Written by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

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.

Power Automate Trigger File Creation with Filter Extension: Step-by-Step

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question

1 more way this is tested on PL-900