Question 52 of 976

Demonstrate the capabilities of Power Automate →hardMultiple ChoiceObjective-mapped

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.”

PL-900 Practice Question: Demonstrate the capabilities of Power Automate

This PL-900 practice question tests your understanding of demonstrate the capabilities of power automate. Read the scenario carefully and evaluate each option against the stated constraints before committing to an answer. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.

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?

Question 1hardmultiple choice

Full question →

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')"
        }
      ]
    }
  }
}

A
Triggers when a .csv file is created in the 'Incoming' folder.
Why wrong: Condition checks for .xlsx, not .csv.
B
Triggers when any file is created in the 'Incoming' folder.
Why wrong: Condition restricts to .xlsx files only.
C
Triggers when a file is modified in the 'Incoming' folder.
Why wrong: Trigger is 'WhenFileCreatedInFolder', not modified.
D
Triggers when a .xlsx file is created in the 'Incoming' folder.
Condition ensures only .xlsx files trigger the flow.

Full breakdown with real-world context →

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.

Option D is correct because the trigger is set to fire when a file is created in the 'Incoming' folder, but the condition filters to only proceed when the file extension is .xlsx. Option A is wrong because it does not check for any file. Option B is wrong because it does not update. Option C is wrong because it does not process CSV.

Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.

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.
Related concept
Read the scenario before looking for a memorised answer.

Common exam traps

Common exam trap: answer the scenario, not the keyword

Many certification questions include familiar terms but test a specific constraint. Read the exact wording before choosing an answer that is generally true but wrong for this case.

Detailed technical explanation

How to think about this question

This question should be treated as a scenario, not a definition check. Identify the problem, the constraint and the best action. Then compare each option against those facts.

KKey Concepts to Remember

Read the scenario before looking for a memorised answer.
Find the constraint that changes the correct option.
Eliminate answers that are true in general but not in this case.
Use explanations to understand the rule behind the answer.

TExam Day Tips

Underline the problem statement mentally.
Watch for words such as best, first, most likely and least administrative effort.
Review why wrong options are wrong, not only why the correct option is correct.

Key takeaway

Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.

Real-world example

How this comes up in practice

A cloud solutions architect for a retail company is evaluating services for a new workload. The correct answer here reflects best practice for the specific scenario described — not a general cloud recommendation. Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option. Cloud exam questions reward reading the constraint carefully: the same technology can be right or wrong depending on the use case.

What to study next

Got this wrong? Here's your next step.

Identify which PL-900 exam domain this question belongs to, then review the specific concept being tested. Practise related questions in that domain and focus on understanding why each wrong answer is tempting — not just why the correct answer is right.

Related PL-900 practice-question pages

Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.

Identify foundational components of Power Platform practice questions

Practise PL-900 questions linked to Identify foundational components of Power Platform.

Demonstrate capabilities of Power BI practice questions

Practise PL-900 questions linked to Demonstrate capabilities of Power BI.

Describe complementary Microsoft Power Platform solutions practice questions

Practise PL-900 questions linked to Describe complementary Microsoft Power Platform solutions.

Demonstrate the capabilities of Power Automate practice questions

Practise PL-900 questions linked to Demonstrate the capabilities of Power Automate.

Describe the business value of Microsoft Power Platform practice questions

Practise PL-900 questions linked to Describe the business value of Microsoft Power Platform.

Manage the Microsoft Power Platform environment practice questions

Practise PL-900 questions linked to Manage the Microsoft Power Platform environment.

Identify foundational components of Microsoft Power Platform practice questions

Practise PL-900 questions linked to Identify foundational components of Microsoft Power Platform.

Demonstrate the capabilities of Power BI practice questions

Practise PL-900 questions linked to Demonstrate the capabilities of Power BI.

Demonstrate the capabilities of Power Apps practice questions

Practise PL-900 questions linked to Demonstrate the capabilities of Power Apps.

Demonstrate the capabilities of Microsoft Copilot Studio practice questions

Practise PL-900 questions linked to Demonstrate the capabilities of Microsoft Copilot Studio.

Demonstrate the capabilities of Power Pages practice questions

Practise PL-900 questions linked to Demonstrate the capabilities of Power Pages.

PL-900 fundamentals practice questions

Practise PL-900 questions linked to PL-900 fundamentals.

Practice this exam

Start a free PL-900 practice session

Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.

10 questions 20 questions 30 questions 50 questions Timed 30

PL-900 practice-test guide →Study guide →Browse all practice tests

FAQ

Questions learners often ask

What does this PL-900 question test?

Demonstrate the capabilities of Power Automate — This question tests Demonstrate the capabilities of Power Automate — Read the scenario before looking for a memorised answer..

What is the correct answer to this question?

The correct answer is: Triggers when a .xlsx file is created in the 'Incoming' folder. — Option D is correct because the trigger is set to fire when a file is created in the 'Incoming' folder, but the condition filters to only proceed when the file extension is .xlsx. Option A is wrong because it does not check for any file. Option B is wrong because it does not update. Option C is wrong because it does not process CSV.

What should I do if I get this PL-900 question wrong?

What is the key concept behind this question?

Read the scenario before looking for a memorised answer.

About these practice questions

Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

Same concept, more angles

1 more ways 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: Option C is correct because the trigger fires when a new email arrives in the Inbox with 'Invoice' in the subject. Option A is wrong because 'fetchOnlyWithAttachment' is false. Option B is wrong because 'importance' is 'Any'. Option D is wrong because the trigger fires on new email, not on email modification.

Last reviewed: Jun 21, 2026

Question Discussion

Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.

Loading comments…

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.