Courseiva

PL-900 · topic practice

Demonstrate the capabilities of Power Automate practice questions

Practise Microsoft Power Platform Fundamentals PL-900 Demonstrate the capabilities of Power Automate practice questions — original exam-style scenarios with answer choices, explanations, and analysis of common mistakes.

Courseiva uses original exam-style practice questions designed for learning and revision. The goal is to understand the concepts, recognise exam patterns, and improve through explanations — not memorise copied exam dumps.

Reviewed byJohnson Ajibi· MSc IT Security
20 questionsDomain: Demonstrate the capabilities of Power Automate
Practice 10 questionsBrowse domain →

What the exam tests

What to know about Demonstrate the capabilities of Power Automate

Demonstrate the capabilities of Power Automate questions test whether you can apply the concept in context, not just recognise a definition.

How the topic appears in realistic exam-style scenarios.

Which detail in the question changes the correct answer.

How to eliminate plausible but wrong options.

How to connect the question back to the wider exam objective.

Watch out for

Common Demonstrate the capabilities of Power Automate exam traps

  • ▸Answering from memory before reading the full scenario.
  • ▸Missing a constraint such as cost, availability, security, scope or command context.
  • ▸Choosing a broad answer when the question asks for the most specific fix.
  • ▸Ignoring why the wrong options are tempting.

Practice set

Demonstrate the capabilities of Power Automate questions

20 questions · select your answer, then reveal the explanation

Question 1easymultiple choice
Read the full Demonstrate the capabilities of Power Automate explanation →

A company wants to automate sending a welcome email to new employees after they are added to a SharePoint list. Which type of trigger should be used in the Power Automate flow?

Question 2mediummultiple choice
Read the full Demonstrate the capabilities of Power Automate explanation →

You have a Power Automate flow that sends an email notification when a new file is added to a SharePoint document library. Users report that emails are not being sent for some files. What is the most likely cause?

Question 3hardmultiple choice
Read the full Demonstrate the capabilities of Power Automate explanation →

You are designing a Power Automate flow to approve expense reports. The flow must allow managers to approve or reject directly from the email notification without signing in. Which action should you use?

Question 4mediummultiple choice
Read the full Demonstrate the capabilities of Power Automate explanation →

A flow fails with the error: 'GatewayTimeout'. The flow connects to an on-premises SQL Server via a data gateway. What is the most likely cause?

Question 5hardmultiple choice
Read the full Demonstrate the capabilities of Power Automate explanation →

You need to design a Power Automate flow that processes orders from a CSV file in SharePoint. The flow should read each row and create a record in a SQL database. If a row contains invalid data, the flow should continue with the next row. Which configuration should you use?

Question 6easymulti select
Read the full Demonstrate the capabilities of Power Automate explanation →

Which TWO components are required to create a Power Automate flow that sends an email when a new item is added to a SharePoint list? (Choose two.)

Question 7mediummulti select
Read the full Demonstrate the capabilities of Power Automate explanation →

Which THREE are valid options for handling errors in a Power Automate flow? (Choose three.)

Question 8mediummultiple choice
Read the full Demonstrate the capabilities of Power Automate explanation →

A Power Automate flow uses the trigger configuration shown. Users report that the flow does not start when a new order is added with Status = 'Pending'. What is the most likely cause?

Exhibit

Refer to the exhibit.
{
  "triggers": {
    "When_an_item_is_created_or_modified": {
      "inputs": {
        "dataset": "https://contoso.sharepoint.com/sites/sales",
        "table": "Orders",
        "triggerConditions": "@equals(triggerOutputs()?['body/Status'], 'New')"
      }
    }
  }
}
Question 9hardmultiple choice
Read the full Demonstrate the capabilities of Power Automate explanation →

You review a failed flow run with the log shown. The flow is supposed to send an email when a SharePoint item is created. What is the most likely issue?

Exhibit

Refer to the exhibit.
Flow run log:
Action: Send an email (V2)
Status: Failed
Error: 'The mail server could not be reached. Check your connection and try again.'
Trigger: When an item is created (SharePoint)
Scope: SendNotification
Question 10hardmultiple choice
Read the full Demonstrate the capabilities of Power Automate explanation →

You are a Power Platform administrator for a large enterprise. You have created a Power Automate cloud flow that sends an approval email to the manager whenever a new employee is added to the HR system. The flow uses a SharePoint list as the trigger and a Common Data Service (CDS) connector to update the employee record. Recently, the flow has been failing intermittently with the error: 'The request failed due to a network error. The server returned an error: GatewayTimeout'. You check the flow run history and see that the error occurs on the CDS update action. The SharePoint trigger and approval actions complete successfully. The flow runs with a concurrency setting of 10. The CDS environment is in another region. You need to resolve the timeout issue. What should you do?

Question 11easymulti select
Read the full Demonstrate the capabilities of Power Automate explanation →

Which TWO scenarios are suitable for using a scheduled cloud flow in Power Automate?

Question 12mediummultiple choice
Read the full Demonstrate the capabilities of Power Automate explanation →

Refer to the exhibit. The flow fails to send the email. What is the most likely cause?

Exhibit

Refer to the exhibit.

{
  "trigger": {
    "type": "Recurrence",
    "recurrence": {
      "frequency": "Day",
      "interval": 1
    }
  },
  "actions": {
    "Get_items": {
      "type": "OpenApiConnection",
      "inputs": {
        "host": {
          "connectionName": "shared_commondataserviceforapps",
          "operationId": "GetItems"
        },
        "parameters": {
          "entityName": "opportunities",
          "$filter": "statecode eq 0"
        }
      }
    },
    "Send_email": {
      "type": "OpenApiConnection",
      "inputs": {
        "host": {
          "connectionName": "shared_office365",
          "operationId": "SendEmail"
        },
        "parameters": {
          "To": "manager@contoso.com",
          "Subject": "Open Opportunities Report",
          "Body": "Please review the attached report."
        }
      },
      "runAfter": {
        "Get_items": ["Succeeded"]
      }
    }
  },
  "description": "Send daily report of open opportunities to manager."
}
Question 13hardmultiple choice
Read the full Demonstrate the capabilities of Power Automate explanation →

You are a Power Automate developer for a large retail company. The company uses a SharePoint Online list named 'SalesOrders' to track orders. Each order has a Status column (choice: New, Processing, Shipped, Delivered). When an order is updated to 'Shipped', a flow should send an email with tracking info to the customer. Additionally, if the order amount exceeds $10,000, a manager must approve the shipment before the email is sent. You create a flow with a trigger 'When an item is modified' and add a condition to check if Status equals 'Shipped'. Inside the condition, you add an approval action. The flow currently sends the approval to the manager for all orders, even those under $10,000. You need to modify the flow so that orders under $10,000 skip the approval and directly send the email. What should you do?

Question 14mediumdrag order
Read the full Demonstrate the capabilities of Power Automate explanation →

Drag and drop the steps to create a Power BI report from a Dataverse table in the correct order.

Drag steps to the numbered slots on the right, or tap a step then tap a slot.

Steps
Order
1Step 1
2Step 2
3Step 3
4Step 4
5Step 5
Question 15mediummatching
Read the full Demonstrate the capabilities of Power Automate explanation →

Match each Power Apps license type to its description.

Drag a concept onto its matching description — or click a concept then click the description.

Concepts
Matches

License for one app per user

License for unlimited apps per user

License for one flow (legacy)

Includes Power Apps rights

Access to run apps without additional cost

Question 16mediummultiple choice
Read the full Demonstrate the capabilities of Power Automate explanation →

Your organization uses Power Automate to automate approval workflows in SharePoint. When a user creates a new item in a SharePoint list, an approval request should be sent to their manager. However, some approvals are not being triggered. What is the most likely cause?

Question 17easymultiple choice
Read the full Demonstrate the capabilities of Power Automate explanation →

A company wants to automate sending a welcome email to new users added to Microsoft Entra ID. Which Power Automate trigger should they use?

Question 18hardmultiple choice
Read the full Demonstrate the capabilities of Power Automate explanation →

Refer to the exhibit. You have a Power Automate flow that sends an approval email and then checks if the email was sent successfully. If successful, it updates a SharePoint item status to 'Approved'. Otherwise, it sends a rejection email. However, the flow always updates the SharePoint item to 'Approved' even when the approval email fails. What is the likely issue?

Exhibit

{
  "definition": {
    "triggers": {
      "manual": {
        "type": "Request",
        "kind": "Http",
        "inputs": {
          "schema": {
            "properties": {
              "email": {
                "type": "string"
              }
            },
            "required": [
              "email"
            ]
          }
        }
      }
    },
    "actions": {
      "Send_approval_email": {
        "type": "ApiConnection",
        "inputs": {
          "host": {
            "connectionName": "shared_office365",
            "operationId": "SendEmail",
            "apiId": "/providers/Microsoft.PowerApps/apis/shared_office365"
          },
          "parameters": {
            "email/To": "@triggerBody()?['email']",
            "email/Subject": "Approval Required",
            "email/Body": "Please approve this request."
          },
          "authentication": "@parameters('$authentication')"
        },
        "runAfter": {}
      },
      "Condition": {
        "type": "If",
        "expression": {
          "equals": [
            "@body('Send_approval_email')?['status']",
            "Succeeded"
          ]
        },
        "actions": {
          "Update_item": {
            "type": "ApiConnection",
            "inputs": {
              "host": {
                "connectionName": "shared_sharepointonline",
                "operationId": "UpdateItem",
                "apiId": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline"
              },
              "parameters": {
                "dataset": "https://contoso.sharepoint.com/sites/marketing",
                "table": "Approvals",
                "id": 1,
                "item/Status": "Approved"
              }
            },
            "runAfter": {}
          }
        },
        "else": {
          "actions": {
            "Send_rejection_email": {
              "type": "ApiConnection",
              "inputs": {
                "host": {
                  "connectionName": "shared_office365",
                  "operationId": "SendEmail",
                  "apiId": "/providers/Microsoft.PowerApps/apis/shared_office365"
                },
                "parameters": {
                  "email/To": "requestor@contoso.com",
                  "email/Subject": "Request Rejected",
                  "email/Body": "Your request has been rejected."
                }
              },
              "runAfter": {}
            }
          }
        }
      }
    }
  }
}
Question 19mediummultiple choice
Read the full Demonstrate the capabilities of Power Automate explanation →

A manufacturing company uses Power Automate to monitor equipment sensors. When a temperature sensor exceeds a threshold, a flow sends an alert to the maintenance team. However, duplicate alerts are being sent for the same event. What should the flow developer implement to prevent duplicates?

Question 20easymultiple choice
Read the full Demonstrate the capabilities of Power Automate explanation →

You need to create a flow that runs every hour and checks if any new files have been added to a SharePoint document library. Which trigger type should you use?

Continue with 20-question session →

Free account

Track your progress over time

Create a free account to save your results and see which topics improve across sessions.

Sign up freeLog in

Focused Demonstrate the capabilities of Power Automate sessions

Start a Demonstrate the capabilities of Power Automate only practice session

Every question in these sessions is drawn from the Demonstrate the capabilities of Power Automate domain — nothing else.

10 questions20 questions30 questions50 questions
Browse all Demonstrate the capabilities of Power Automate questions →Mixed PL-900 session

Related practice questions

Related PL-900 topic practice pages

Move into related areas when this topic feels solid.

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.

Frequently asked questions

What does the PL-900 exam test about Demonstrate the capabilities of Power Automate?
Demonstrate the capabilities of Power Automate questions test whether you can apply the concept in context, not just recognise a definition.
How should I use these practice questions?
Select your answer before revealing the explanation. Then read why each option is right or wrong — this active recall approach builds retention far faster than re-reading notes.
Can I practise just Demonstrate the capabilities of Power Automate questions in a focused session?
Yes — the session launcher on this page draws every question from the Demonstrate the capabilities of Power Automate domain. Use a 10-question session first to gauge your baseline, then move to 20 or 30 once the weak spots are clear.
Where can I practise other PL-900 topics?
Use the topic links above to move to related areas, or go back to the PL-900 question bank to see all topics.
Are these real exam questions or dumps?
These are original practice questions written to test the same concepts the PL-900 exam covers. They are not copied from any real exam or dump site.