PL-900 Demonstrate the capabilities of Power Automate — All Questions With Answers

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?

Question 21hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

Refer to the exhibit. A flow is triggered when an email with 'Invoice' in the subject arrives, and it saves the first attachment to a SharePoint document library. However, the flow fails with an error 'InvalidTemplate'. What is the most likely cause?

Exhibit

{
  "definition": {
    "triggers": {
      "When_a_new_email_arrives": {
        "type": "ApiConnection",
        "inputs": {
          "host": {
            "connectionName": "shared_office365",
            "operationId": "OnNewEmail",
            "apiId": "/providers/Microsoft.PowerApps/apis/shared_office365"
          },
          "parameters": {
            "folderId": "Inbox",
            "importance": "Any",
            "fetchOnlyWithAttachment": false,
            "includeAttachments": true,
            "subjectFilter": "Invoice"
          }
        }
      }
    },
    "actions": {
      "Create_file": {
        "type": "ApiConnection",
        "inputs": {
          "host": {
            "connectionName": "shared_sharepointonline",
            "operationId": "CreateFile",
            "apiId": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline"
          },
          "parameters": {
            "dataset": "https://contoso.sharepoint.com/sites/finance",
            "folderPath": "/Shared Documents/Invoices",
            "name": "@triggerOutputs()?['body/attachments'][0]['name']",
            "fileContent": "@triggerOutputs()?['body/attachments'][0]['contentBytes']"
          }
        },
        "runAfter": {}
      }
    }
  }
}

Question 22mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A company wants to automate the process of archiving completed sales orders from a SQL Server database to a SharePoint list every night. Which approach should they use?

Question 23easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You need to create a flow that sends an email notification when a new file is added to a OneDrive for Business folder. Which trigger should you use?

Question 24hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

Your Power Automate flow uses an HTTP action to call a REST API. The API returns a JSON array of objects. You need to process each object and create a record in a SQL Server database. Which actions should you use?

Question 25mediummulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which TWO scenarios are best suited for using Power Automate scheduled flows?

Question 26hardmulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which THREE actions are available in Power Automate to handle errors and exceptions?

Question 27easymulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which TWO connectors are available in Power Automate without a premium license?

Question 28easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You need to design a flow that runs when a new response is submitted in Microsoft Forms. The flow should send an email to the respondent with a summary of their answers. Which trigger should you use?

Question 29mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A company uses Power Automate to process incoming emails. Some emails need to be forwarded to a manager, while others need to be saved to SharePoint. The decision is based on the email subject. Which action should be used to implement the branching logic?

Question 30hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You are a Power Automate administrator for Contoso Corporation. The company uses Microsoft 365 E5 licenses. The sales team uses a SharePoint Online list named 'Leads' to track potential customers. The list has columns: Title (single line of text), Email (single line of text), Status (choice: New, Contacted, Qualified, Lost), and Score (number). The sales manager wants to automate the following process: When a new lead is added with Status = 'New' and Score > 50, an approval request should be sent to the manager. If approved, the lead Status should be updated to 'Contacted' and an email should be sent to the lead's email address. If rejected, the lead Status should be updated to 'Lost'. Additionally, if the lead is not approved within 7 days, the flow should automatically set Status to 'Lost'. The manager is often on leave, so the flow should also send a reminder to the manager every 2 days if the approval is pending. You need to design the flow using Power Automate. Which of the following designs best meets the requirements?

Question 31mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A company uses Power Automate to automate approval workflows for purchase orders. The flow should send an approval request to the manager of the requestor. When the manager approves, the flow should update a SharePoint list and send a confirmation email. However, the flow fails with an error 'Unable to find the manager for the specified user'. What is the most likely cause?

Question 32hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You are designing a Power Automate cloud flow that processes customer feedback from Microsoft Forms. The flow should send an email to the customer if their feedback rating is less than 3, and also post a message to a Microsoft Teams channel for all feedback. The flow works correctly for rating 2, but for rating 1 it sends two emails instead of one. What is the most likely cause?

Question 33easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

Your organization uses Power Automate to automatically create a task in Microsoft Planner when a new sales opportunity is closed in Dynamics 365. The flow triggers on a new opportunity but fails to create the task. You check the run history and see an error: 'Invalid template specification' in the 'Create a task' action. How should you resolve this?

Question 34easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A Power Automate flow sends an approval request to a user's manager. The flow uses the 'Get manager' action from the Office 365 Users connector. The flow runs successfully but the approval is never received by the manager. What is the most likely reason?

Question 35mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You have a Power Automate flow that monitors a SharePoint list for new items and then sends a custom email notification using the 'Send an email (V2)' action. The email includes an attachment from the SharePoint item. Some users report that the attachment is missing from the email. What should you check first?

Question 36hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A Power Automate flow uses a 'When a HTTP request is received' trigger. The flow is called by an external application. The flow runs successfully but the external application receives a '500 Internal Server Error' response. What is the most likely cause?

Question 37easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You are creating a Power Automate flow to copy files from a SharePoint document library to a OneDrive for Business folder. The flow triggers when a new file is created in SharePoint. After saving the flow, you get a warning that the flow uses a trigger that is not supported in the 'Solutions' context. What does this mean?

Question 38mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

Your organization uses Power Automate to automate the creation of support tickets in ServiceNow when a critical alert is triggered in Microsoft Sentinel. The flow uses the 'When a new alert is created' trigger from Sentinel. The flow runs but no tickets are created. You check the Sentinel log and see that alerts are being generated. What should you investigate first?

Question 39hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A Power Automate flow uses the 'Parse JSON' action to process incoming webhook data. The flow fails with the error 'Invalid JSON' when the webhook sends data. You review the sample payload used to generate the schema and notice the webhook sometimes includes additional optional fields. What is the most likely cause?

Question 40mediummulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which TWO actions can you take to improve the performance and reliability of a Power Automate cloud flow? (Choose 2)

Question 41hardmulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which THREE Power Automate features are available only in premium licenses? (Choose 3)

Question 42easymulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which TWO triggers are available for Power Automate flows that start from a Dataverse table? (Choose 2)

Question 43easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

Refer to the exhibit. You are designing a Power Automate flow that receives an HTTP request with a JSON body. You use the 'Parse JSON' action with the schema shown. The flow fails when the incoming JSON contains an 'items' array with a product object missing the 'quantity' field. What is the best way to fix this?

Exhibit

{
  "type": "object",
  "properties": {
    "customerName": {
      "type": "string"
    },
    "orderAmount": {
      "type": "number"
    },
    "items": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "productId": {
            "type": "string"
          },
          "quantity": {
            "type": "integer"
          }
        },
        "required": ["productId", "quantity"]
      }
    }
  },
  "required": ["customerName", "orderAmount"]
}

Question 44mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

Refer to the exhibit. A Power Automate flow definition is shown. The flow is supposed to trigger when a high-importance email with attachments arrives in the inbox, and then send a notification email to support. However, the flow does not trigger for emails that have attachments but are not marked as high importance. What is the most likely reason?

Exhibit

{
  "triggers": {
    "When_a_new_email_arrives": {
      "type": "ApiConnection",
      "inputs": {
        "host": {
          "connectionName": "shared_office365",
          "operationId": "OnNewEmail"
        },
        "parameters": {
          "folderPath": "Inbox",
          "importance": "High",
          "onlyWithAttachments": true
        }
      }
    }
  },
  "actions": {
    "Send_an_email": {
      "type": "ApiConnection",
      "inputs": {
        "host": {
          "connectionName": "shared_office365",
          "operationId": "SendEmail"
        },
        "parameters": {
          "to": "support@contoso.com",
          "subject": "High importance email received",
          "body": "Check your inbox for an important email."
        }
      }
    }
  }
}

Question 45hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

Refer to the exhibit. A Power Automate flow definition is shown. The flow is triggered by an HTTP request with a 'score' property. When the score is greater than 0.8, it sends an approval email to the manager. Otherwise, it logs the score to a SharePoint list. The flow runs but when a score of 0.9 is submitted, no email is sent and the SharePoint log is created. What is the most likely cause?

Exhibit

{
  "definition": {
    "$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#",
    "actions": {
      "Condition": {
        "type": "If",
        "expression": "@greater(triggerBody()?['score'], 0.8)",
        "actions": {
          "Send_approval_email": {
            "type": "ApiConnection",
            "inputs": {
              "host": {
                "connectionName": "shared_office365",
                "operationId": "SendEmail"
              },
              "parameters": {
                "to": "manager@contoso.com",
                "subject": "High score alert",
                "body": "Score is high."
              }
            },
            "runAfter": {}
          }
        },
        "else": {
          "actions": {
            "Log_to_SharePoint": {
              "type": "ApiConnection",
              "inputs": {
                "host": {
                  "connectionName": "shared_sharepointonline",
                  "operationId": "CreateItem"
                },
                "parameters": {
                  "dataset": "https://contoso.sharepoint.com/sites/Logs",
                  "table": "ScoreLog",
                  "item": {
                    "Score": "@triggerBody()?['score']"
                  }
                }
              },
              "runAfter": {}
            }
          }
        },
        "runAfter": {}
      }
    },
    "triggers": {
      "manual": {
        "type": "Request",
        "kind": "Http",
        "inputs": {
          "schema": {
            "type": "object",
            "properties": {
              "score": {
                "type": "number"
              }
            },
            "required": ["score"]
          }
        }
      }
    }
  }
}

Question 46easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You need to automatically send an email notification when a new file is added to a SharePoint document library. Which trigger should you use in a Power Automate cloud flow?

Question 47mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A Power Automate flow fails with the error 'GatewayTimeout'. The flow uses an on-premises data gateway to connect to a SQL Server database. What is the most likely cause?

Question 48hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You are designing a Power Automate flow that processes approvals for expense reports. If an expense exceeds $5,000, the flow must require approval from both the manager and the finance director. If the expense is between $1,000 and $5,000, only manager approval is needed. For expenses under $1,000, no approval is required. Which control structures should you use?

Question 49easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

Refer to the exhibit. The JSON snippet shows a Power Automate action definition. Which action is this?

Exhibit

Refer to the exhibit.
{ "type": "OpenApiConnection", "inputs": { "host": { "connectionName": "shared_office365", "operationId": "SendEmail" }, "parameters": { "emailMessage": { "To": "user@contoso.com", "Subject": "Approval Required", "Body": "Please approve the request." } }, "authentication": "@parameters('$authentication')" } }

Question 50mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A Power Automate flow runs on a schedule and exports data from Microsoft Dataverse to a CSV file in SharePoint. Recently, the flow has been taking longer than expected and sometimes times out. Which approach should you take to improve performance?

Question 51hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

Your organization uses Power Automate to automate approval workflows for purchase orders. The compliance team requires that all approvals be auditable and that the flow logs include the identity of the user who initiated the approval. Which feature should you use?

Question 52easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You need to create a Power Automate flow that sends a personalized welcome email to new users when they are added to Microsoft Entra ID. Which trigger should you select?

Question 53mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A Power Automate flow that processes incoming emails and creates tasks in Microsoft To Do is not triggering for some emails. The flow uses the 'When a new email arrives' trigger with a filter on the subject containing 'Task'. What is the most likely reason some emails are missed?

Question 54hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

Refer to the exhibit. The Power Automate flow definition includes a manual trigger expecting employeeId and amount. If an expense amount is $6,000, what will happen?

Exhibit

Refer to the exhibit.
{
  "definition": {
    "triggers": {
      "manual": {
        "type": "Request",
        "kind": "Http",
        "inputs": {
          "schema": {
            "type": "object",
            "properties": {
              "employeeId": {
                "type": "string"
              },
              "amount": {
                "type": "number"
              }
            },
            "required": ["employeeId","amount"]
          }
        }
      }
    },
    "actions": {
      "Condition": {
        "type": "If",
        "expression": "@greater(triggerBody()?['amount'], 5000)",
        "actions": {
          "Send_approval": {
            "type": "OpenApiConnection",
            "inputs": {
              "host": {
                "connectionName": "shared_approvals",
                "operationId": "StartAndWaitForAnApproval"
              },
              "parameters": {
                "approvalType": "FirstToRespond",
                "assignedTo": "manager@contoso.com",
                "details": "Expense over $5000"
              }
            }
          }
        },
        "else": {
          "actions": {
            "Send_email": {
              "type": "OpenApiConnection",
              "inputs": {
                "host": {
                  "connectionName": "shared_office365",
                  "operationId": "SendEmail"
                },
                "parameters": {
                  "To": "employee@contoso.com",
                  "Subject": "Expense Approved",
                  "Body": "Your expense is approved."
                }
              }
            }
          }
        }
      }
    }
  }
}

Question 55easymulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which TWO actions are valid Power Automate flow actions? (Select TWO.)

Question 56mediummulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which THREE are valid trigger types in Power Automate? (Select THREE.)

Question 57hardmulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which TWO are best practices for designing Power Automate flows in a production environment? (Select TWO.)

Question 58easymulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which THREE components are part of a Power Automate cloud flow? (Select THREE.)

Question 59mediummulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which TWO are valid ways to share a Power Automate flow? (Select TWO.)

Question 60hardmulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which THREE are valid connectors in Power Automate? (Select THREE.)

Question 61easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A company wants to automatically send an email notification when a new file is added to a SharePoint document library. Which type of trigger should be used in Power Automate?

Question 62mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A sales team uses Power Automate to create a lead in Dynamics 365 Sales when a new row is added to a Google Sheets spreadsheet. The flow fails with a 'Forbidden' error. What is the most likely cause?

Question 63hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

An organization has a Power Automate flow that runs on a schedule and processes sensitive data. The compliance team requires that the flow cannot be triggered manually and must use a managed identity for authentication. Which feature should be used to meet these requirements?

Question 64easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A user wants to create a flow that automatically copies attachments from incoming Outlook emails to a OneDrive folder. Which trigger and action should be used?

Question 65mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A flow uses an approval step to notify managers when a purchase request exceeds $10,000. The approval action times out after 7 days. The business requires that if no response is received within 3 days, the request should be automatically approved. What should be added to the flow?

Question 66easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A company wants to integrate Power Automate with Microsoft Teams so that when a new task is assigned in Planner, a message is posted in a Teams channel. Which connector should be used?

Question 67mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A Power Automate flow processes hundreds of items daily. The flow sometimes fails due to service unavailability. Which feature should be used to automatically retry the failed action?

Question 68mediummulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which TWO of the following are valid trigger types in Power Automate? (Select TWO.)

Question 69hardmulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which THREE of the following are valid ways to handle errors in a Power Automate flow? (Select THREE.)

Question 70easymulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which TWO of the following are types of connectors available in Power Automate? (Select TWO.)

Question 71easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A user wants to create a flow that runs when a specific button is clicked in a mobile app. Which type of flow should be used?

Question 72mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A flow uses a 'When an item is created' trigger for a SharePoint list. The flow needs to access the item's title and the user who created it. Which dynamic values should be used?

Question 73mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A company uses Power Automate to automate approval workflows. An employee reports that an approval request sent to their manager is not being delivered. The manager is listed in Microsoft Entra ID with the correct email address. What is the most likely cause?

Question 74hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A Power Automate flow processes incoming emails from a shared mailbox. Recently, some emails are being missed. You suspect the flow is hitting a service protection limit. Which action should you take to diagnose the issue?

Question 75easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You need to create a Power Automate flow that runs every Monday at 9 AM to update a SharePoint list. Which trigger should you use?

Question 76hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

Refer to the exhibit. A developer created an approval flow using Power Automate. The flow is triggered manually but the approval email never sends. What is the most likely cause?

Exhibit

Refer to the exhibit.
```json
{
  "definition": {
    "$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#",
    "actions": {
      "Send_approval_email": {
        "type": "ApiConnection",
        "inputs": {
          "host": {
            "connectionName": "shared_office365",
            "operationId": "SendEmail"
          },
          "parameters": {
            "To": "manager@contoso.com",
            "Subject": "Please approve expense report",
            "Body": "Approval request for expense report #1234"
          },
          "authentication": "@parameters('$authentication')"
        }
      },
      "Condition": {
        "type": "If",
        "expression": "@equals(triggerBody()?['status'], 'Approved')",
        "actions": {
          "Update_SharePoint": {
            "type": "ApiConnection",
            "inputs": {
              "host": {
                "connectionName": "shared_sharepointonline",
                "operationId": "UpdateItem"
              },
              "parameters": {
                "dataset": "https://contoso.sharepoint.com/sites/Expense",
                "table": "ExpenseReports",
                "id": 1234,
                "item": {
                  "Status": "Approved"
                }
              }
            }
          }
        }
      }
    },
    "triggers": {
      "manual": {
        "type": "Request",
        "kind": "Http",
        "inputs": {
          "schema": {}
        }
      }
    }
  }
}

Question 77mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A Power Automate flow uses an approval action. The approver can choose 'Approve', 'Reject', or 'Reassign'. The flow needs to send a different email based on the approver's choice. Which action should be used after the approval?

Question 78easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You have a Power Automate flow that copies files from OneDrive for Business to a SharePoint document library. The flow runs successfully but the files are not appearing in SharePoint. What should you check first?

Question 79mediummulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which TWO actions can be used to add conditional logic in a Power Automate flow?

Question 80hardmulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which THREE components are part of a Power Automate cloud flow?

Question 81mediummulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which TWO are valid trigger types in Power Automate?

Question 82hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

Refer to the exhibit. A Power Automate flow is triggered when an item is created in a SharePoint list. However, the flow runs for every new item, even those with Status other than 'New'. What is the issue?

Exhibit

Refer to the exhibit.
```json
{
  "definition": {
    "$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#",
    "triggers": {
      "When_an_item_is_created": {
        "type": "ApiConnection",
        "inputs": {
          "host": {
            "connectionName": "shared_sharepointonline",
            "operationId": "OnNewItem"
          },
          "parameters": {
            "dataset": "https://contoso.sharepoint.com/sites/Sales",
            "table": "Leads",
            "triggerCondition": "@equals(triggerBody()?['Status'], 'New')"
          }
        }
      }
    },
    "actions": {
      "Send_email": {
        "type": "ApiConnection",
        "inputs": {
          "host": {
            "connectionName": "shared_office365",
            "operationId": "SendEmail"
          },
          "parameters": {
            "To": "sales@contoso.com",
            "Subject": "New Lead Created",
            "Body": "A new lead has been created."
          }
        }
      }
    }
  }
}

Question 83easymultiple choice

Read the full NAT/PAT explanation →

You need to create a flow that sends a push notification to a user's mobile device when a high-priority email arrives in their inbox. Which trigger and action combination should you use?

Question 84mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A Power Automate flow uses the 'Apply to each' action to process items from a SharePoint list. The flow is running slowly. What is the most effective way to improve performance?

Question 85hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A company has a Power Automate flow that uses a premium connector (e.g., SQL Server). Several users report that the flow fails with a '401 Unauthorized' error. The flow uses a service principal for authentication. What is the most likely cause?

Question 86easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You want to automate a business process that requires human interaction for approval. Which type of Power Automate flow should you use?

Question 87mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A Power Automate flow is triggered when a new file is added to a SharePoint document library. The flow should then copy the file to a different library. However, the flow fails when the file name contains a colon (:). What is the most likely reason?

Question 88mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A company uses Power Automate to automate invoice processing. When a new email with an Excel attachment arrives in a shared mailbox, the flow should parse the attachment and create a record in Dataverse. However, the flow fails intermittently. Upon review, the flow uses the 'When a new email arrives' trigger with the 'Include Attachments' option set to 'No'. What is the most likely cause of the failure?

Question 89hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You need to design a Power Automate flow that sends an approval request to a manager when an employee submits a leave request in SharePoint. The flow should check if the manager is on leave and, if so, escalate to the next-level manager. What is the best approach to implement this escalation logic?

Question 90easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

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

Question 91mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

Your company has a Power Automate flow that copies files from SharePoint to OneDrive for Business. Recently, some files have not been copied due to permission errors. You need to ensure the flow runs with the appropriate permissions. What should you do?

Question 92hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You are troubleshooting a Power Automate flow that uses an HTTP action to call a REST API. The flow fails with a '429 Too Many Requests' error. The API has a rate limit of 100 requests per minute. Which strategy should you implement to handle this error gracefully?

Question 93easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A business analyst wants to create a Power Automate flow that runs every Monday at 9 AM to generate a report. Which trigger should they use?

Question 94mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You have a Power Automate flow that sends a notification to a Teams channel when a high-priority ticket is created in Dynamics 365. The flow works correctly for most tickets, but occasionally a ticket is missed. Upon checking the flow runs, you see that some runs show 'Skipped' status. What is the most likely cause?

Question 95hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

Your organization uses Power Automate to synchronize data between Salesforce and Dataverse. The flow runs successfully for most records, but some records fail with a 'duplicate record' error in Dataverse. You need to prevent duplicate records from being created. What should you do?

Question 96easymulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which TWO of the following are valid trigger types in Power Automate?

Question 97mediummulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which THREE of the following are features of Power Automate that help manage and monitor flows?

Question 98hardmulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

You need to design a Power Automate cloud flow that processes incoming emails and creates tasks in Microsoft To Do. The flow should only run for emails from specific senders. Which TWO actions should you use?

Question 99mediummulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which THREE of the following are valid connectors in Power Automate?

Question 100mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You are reviewing a Power Automate flow definition. The exhibit shows an action definition. What is the action doing?

Exhibit

Refer to the exhibit. {
  "type": "OpenApiConnection",
  "inputs": {
    "host": {
      "connectionName": "shared_office365",
      "operationId": "SendEmailV2"
    },
    "parameters": {
      "emailMessage/To": "user@contoso.com",
      "emailMessage/Subject": "Test",
      "emailMessage/Body": "<p>Test email</p>"
    },
    "authentication": "@parameters('$authentication')"
  },
  "runAfter": {}
}

Question 101hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

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

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

Question 102easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

The exhibit shows an action in a Power Automate flow. What does this action accomplish?

Exhibit

Refer to the exhibit. {
  "type": "ApiConnection",
  "inputs": {
    "host": {
      "connectionName": "shared_teams",
      "operationId": "PostMessageToChannel"
    },
    "parameters": {
      "team": "Marketing",
      "channel": "General",
      "message": "New lead created: @{triggerOutputs()?['body/name']}"
    },
    "authentication": "@parameters('$authentication')"
  },
  "runAfter": {}
}

Question 103mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A company uses Power Automate to send approval emails when a new employee is added to Microsoft Entra ID. The approval flow fails intermittently with a '403 Forbidden' error. What is the most likely cause?

Question 104easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You need to design a Power Automate flow that triggers when a specific file is added to a SharePoint document library. Which trigger should you use?

Question 105hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A Power Automate flow sends an email to a manager when a leave request is submitted in Microsoft Forms. The flow frequently fails because the manager's mailbox is full. Which approach best handles this error?

Question 106easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You create a Power Automate flow that runs when a new tweet matches a keyword. What type of trigger does this use?

Question 107mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A Power Automate flow uses a 'When an item is created' trigger on a SharePoint list. After moving the list to a different site, the flow no longer triggers. What is the most likely reason?

Question 108hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A Power Automate flow processes sensitive employee data and must be run only by HR managers. Which is the best way to restrict access?

Question 109easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You need to design a Power Automate flow that sends a welcome email to a new user immediately after their account is created in Microsoft Entra ID. Which trigger should you use?

Question 110mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A Power Automate flow runs daily to copy data from a SQL Server database to a SharePoint list. The flow fails with a 'GatewayTimeout' error. What is the most likely cause?

Question 111hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You create a Power Automate flow that uses AI Builder to process invoices. The flow needs to extract text from PDFs and store it in Dataverse. What is the recommended approach?

Question 112mediummulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which TWO actions can be used to implement error handling in a Power Automate flow?

Question 113hardmulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which THREE components are required to create an automated approval process using Power Automate and Microsoft Teams?

Question 114easymulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which TWO are valid trigger types in Power Automate?

Question 115mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

Refer to the exhibit. The Power Automate flow trigger is configured to run when a new email arrives. What will trigger this flow?

Exhibit

{
  "triggers": {
    "When_a_new_email_arrives": {
      "inputs": {
        "host": {
          "connectionName": "shared_office365",
          "operationId": "OnNewEmail"
        },
        "parameters": {
          "includeAttachments": false,
          "folderPath": "Inbox",
          "importance": "Any",
          "onlyWithAttachments": false,
          "subjectFilter": "Invoice"
        }
      },
      "splitOn": "@triggerOutputs()?['body/value']",
      "type": "ApiConnection"
    }
  }
}

Question 116hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

Refer to the exhibit. This Power Automate flow is triggered manually via HTTP request. The action 'Send_approval_email' sends an email. What is a potential issue with this flow design?

Exhibit

{
  "definition": {
    "$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#",
    "actions": {
      "Send_approval_email": {
        "type": "ApiConnection",
        "inputs": {
          "host": {
            "connectionName": "shared_office365",
            "operationId": "SendEmail"
          },
          "parameters": {
            "to": "manager@contoso.com",
            "subject": "Approve request",
            "body": "Please approve."
          },
          "authentication": "@parameters('$authentication')"
        },
        "runAfter": {}
      }
    },
    "triggers": {
      "manual": {
        "type": "Request",
        "kind": "Http",
        "inputs": {
          "schema": {}
        }
      }
    }
  }
}

Question 117mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

Refer to the exhibit. The flow is scheduled to run daily at 8:00 AM. However, it has not been running for the past week. What is the most likely cause?

Exhibit

{
  "properties": {
    "displayName": "Daily Report Flow",
    "state": "Started",
    "definition": {
      "triggers": {
        "Recurrence": {
          "recurrence": {
            "frequency": "Day",
            "interval": 1,
            "schedule": {
              "hours": [8],
              "minutes": [0]
            }
          },
          "type": "Recurrence"
        }
      },
      "actions": {
        "Get_items": {
          "type": "ApiConnection",
          "inputs": {
            "host": {
              "connectionName": "shared_sharepointonline",
              "operationId": "GetItems"
            },
            "parameters": {
              "dataset": "https://contoso.sharepoint.com/sites/Reports",
              "table": "DailyReport",
              "filterQuery": "Status eq 'Pending'"
            }
          }
        }
      }
    }
  }
}

Question 118mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A company uses Power Automate to automate invoice processing. The flow must send an email with the invoice PDF as an attachment to the manager for approval. However, the approval step is failing with an error. What is the most likely cause?

Question 119hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A Power Automate flow triggers when a new item is added to a SharePoint list. The flow uses a 'Send an HTTP request to SharePoint' action to update a related item in another list. The flow runs but the update does not occur. What is the most likely cause?

Question 120easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A user reports that a scheduled flow runs but does not send notifications as expected. The flow is set to run every hour. Which action should the user take first to diagnose the issue?

Question 121mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A company has a Power Automate flow that posts a message to Microsoft Teams when a new lead is created in Dynamics 365. The flow uses the 'Post a message' action. Some users report they do not receive the message in Teams. What should the administrator check first?

Question 122hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A Power Automate flow uses the 'Apply to each' control to process a list of items. The flow runs but only processes the first 10 items. What is the most likely reason?

Question 123mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A company uses Power Automate to monitor a SharePoint document library for new files and then copy them to an Azure Blob Storage container. The flow runs successfully for PDF files but fails for large video files. What is the most likely cause?

Question 124easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A user wants to create a flow that automatically sends a thank-you email when a customer fills out a Microsoft Forms survey. Which trigger should the user select?

Question 125hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A Power Automate flow uses an 'Apply to each' loop to iterate over a large dataset. The flow is running slowly and sometimes times out. Which approach should the administrator recommend to improve performance?

Question 126easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A company wants to automate the process of moving files from a local network drive to SharePoint Online. Which Power Automate feature should they use?

Question 127mediummulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which TWO actions can be performed using Power Automate? (Select TWO.)

Question 128hardmulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which THREE conditions are required for a Power Automate flow to use the 'When an email arrives' trigger for a shared mailbox? (Select THREE.)

Question 129mediummulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which TWO are valid trigger types in Power Automate? (Select TWO.)

Question 130hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

Refer to the exhibit. A Power Automate flow is defined with a manual trigger expecting an email property. When the flow is run, it fails with an error that the email address cannot be empty. What is the most likely cause?

Exhibit

{
  "definition": {
    "triggers": {
      "manual": {
        "type": "Request",
        "kind": "Http",
        "inputs": {
          "schema": {
            "properties": {
              "email": {
                "type": "string"
              }
            },
            "required": [
              "email"
            ]
          }
        }
      }
    },
    "actions": {
      "Send_an_email": {
        "runAfter": {},
        "type": "ApiConnection",
        "inputs": {
          "host": {
            "connectionName": "shared_office365"
          },
          "apiVersion": "1.0",
          "method": "post",
          "path": "/v1.0/mail/me/sendMail",
          "body": {
            "Message": {
              "Subject": "Hello",
              "Body": {
                "ContentType": "Text",
                "Content": "Test"
              },
              "ToRecipients": [
                {
                  "EmailAddress": {
                    "Address": "@triggerBody()?['email']"
                  }
                }
              ]
            }
          }
        }
      }
    }
  }
}

Question 131mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

Refer to the exhibit. A Power Automate flow uses the 'When a new email arrives' trigger with a filter for emails that have attachments. The trigger sometimes fires even when the incoming email has no attachment. What is the most likely reason?

Exhibit

{
  "definition": {
    "triggers": {
      "When_a_new_email_arrives": {
        "type": "ApiConnection",
        "inputs": {
          "host": {
            "connectionName": "shared_office365"
          },
          "apiVersion": "1.0",
          "method": "get",
          "path": "/v1.0/mail/mailFolders/Inbox/messages",
          "queries": {
            "$filter": "hasAttachments eq true",
            "$top": 1
          }
        }
      }
    }
  }
}

Question 132easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

Refer to the exhibit. A Power Automate flow triggers when an item is created in a SharePoint list. The flow does not trigger for items created immediately after the flow is enabled. What is the most likely cause?

Exhibit

{
  "definition": {
    "triggers": {
      "When_an_item_is_created": {
        "type": "ApiConnection",
        "inputs": {
          "host": {
            "connectionName": "shared_sharepointonline"
          },
          "apiVersion": "1.0",
          "method": "get",
          "path": "/v1.0/sites/{site-id}/lists/{list-id}/items",
          "queries": {
            "$filter": "createdDateTime ge @{utcNow()}"
          }
        }
      }
    }
  }
}

Question 133easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A company uses Power Automate to automate approval workflows for expense reports. When an expense report exceeds $5,000, the flow should send an email to the manager and then wait for approval before processing payment. Which type of trigger should be used to start the flow when a new expense report is submitted?

Question 134mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You are troubleshooting a Power Automate flow that uses the 'Send an email' action. The flow runs successfully, but recipients report not receiving the email. What is the most likely cause?

Question 135hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A Power Automate flow is designed to copy files from OneDrive for Business to a SharePoint document library. Some files fail to copy because the file name contains special characters. Which action should be added to the flow to handle this?

Question 136easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You need to create a Power Automate flow that sends a daily digest email to the sales team summarizing new leads from the previous day. The flow should run automatically every morning at 8 AM. Which type of trigger should you use?

Question 137mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A Power Automate flow uses the 'HTTP' action to call an external API. The flow fails intermittently with a 429 (Too Many Requests) error. What is the best practice to handle this?

Question 138hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

Your organization uses Power Automate to automate onboarding processes. The flow creates a user in Microsoft Entra ID, assigns licenses, and sends a welcome email. Recently, the flow failed because the 'Create user' action returned 'PrivilegedOperationNotAllowed'. What is the most likely cause?

Question 139easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You want to design a Power Automate flow that triggers when a customer submits a support ticket in a Microsoft Dataverse table. Which trigger should you use?

Question 140mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A Power Automate flow that sends approval requests is being used by multiple teams. The flow uses the 'Start and wait for an approval' action. The approver reports that they are not receiving the approval request email. What should you check first?

Question 141hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You are designing a Power Automate flow that processes orders. The flow must wait for a manager's approval if the order amount exceeds $10,000. If the approval is rejected, the flow should notify the salesperson and stop processing. Which actions should be used?

Question 142mediummulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which TWO actions can be used to implement error handling in a Power Automate flow? (Choose two.)

Question 143hardmulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which THREE are valid connectors in Power Automate? (Choose three.)

Question 144easymulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which TWO of the following are types of triggers available in Power Automate? (Choose two.)

Question 145mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

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

Exhibit

{
  "triggers": {
    "When_a_new_email_arrives": {
      "inputs": {
        "host": {
          "connectionName": "shared_office365",
          "operationId": "OnNewEmail"
        },
        "parameters": {
          "folderPath": "Inbox",
          "importance": "Any",
          "fetchOnlyWithAttachment": false,
          "includeAttachments": true,
          "subjectFilter": "Invoice"
        }
      }
    }
  }
}

Question 146hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You are a Power Platform administrator at Contoso Ltd. The company uses a Power Automate flow that monitors a SharePoint list for new items. When a new item is added, the flow retrieves data from an external CRM system via an HTTP request, then updates a second SharePoint list. Recently, the flow has been failing with a '400 Bad Request' error from the HTTP action. The CRM API endpoint and authentication are correct. The flow works for some items but fails for others. You need to identify the root cause and fix the flow. What should you do?

Question 147mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

Your organization uses Power Automate to send a welcome email to new employees. The flow is triggered when a new row is added to a Dataverse table named 'NewEmployees'. The flow retrieves the manager's email from a related table and sends an email via Outlook. Managers are reporting that they receive the welcome email but it contains placeholder text instead of the employee's name. The flow runs successfully. What is the most likely cause?

Question 148mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A company has a SharePoint Online list that tracks project tasks. The business requires that when a task is marked as 'Complete', an approval request is sent to the project manager, and the task status is updated to 'Approved' only after the manager approves. The approval process must include a reminder after 2 days if no response. Which Power Automate feature should you use to implement this?

Question 149hardmultiple choice

Read the full NAT/PAT explanation →

You are designing a Power Automate flow that processes sensitive employee data from Dataverse. The flow must run in a secure environment and be triggered by changes to a table that supports auditing. The company policy requires that all flows handling sensitive data use managed identities for authentication and execute within a dedicated environment with data loss prevention (DLP) policies applied. Which combination of features should you use?

Question 150easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A sales team uses a Power Automate flow that creates a contact in Dynamics 365 Sales whenever a new lead is added to a Salesforce system. The flow has been running successfully for months, but recently it started failing with an authentication error. What is the most likely cause?

Question 151mediummultiple choice

Read the full NAT/PAT explanation →

You need to create a flow that automates the onboarding process for new employees. When a new employee record is added to a Human Resources (HR) system in Dataverse, the flow should: (1) send a welcome email, (2) create user accounts in Microsoft Entra ID, and (3) assign licenses. The flow must run with high reliability and should not fail if one of the actions fails. Which flow design pattern should you use?

Question 152hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A company uses Power Automate to send push notifications to mobile devices via the Microsoft Power Platform notification action. The flow is triggered when a high-priority support ticket is created in Dynamics 365. Recently, some users reported not receiving notifications. The flow runs successfully without errors. What is the most likely cause of the issue?

Question 153easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You are building a Power Automate flow that automatically creates a calendar event in Outlook when a customer booking is confirmed in a third-party system. The flow uses a trigger that polls the third-party system every 5 minutes. Which type of trigger is this?

Question 154mediummultiple choice

Read the full NAT/PAT explanation →

A hospital uses a Power Automate flow to send appointment reminders via SMS and email. The flow is triggered when a new appointment is created in the patient management system. The IT department wants to ensure that the flow complies with HIPAA regulations, which require that patient health information (PHI) is encrypted both in transit and at rest. Which Power Automate capability should be enabled?

Question 155hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A company has a Power Automate flow that processes incoming emails and creates tasks in Microsoft Planner. The flow includes a 'Parse JSON' action to extract information from the email body. The flow has been working correctly, but after a recent update to the email template, the flow fails with a 'BadRequest' error at the 'Parse JSON' action. What is the most likely cause?

Question 156easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

A marketing team uses a Power Automate flow that posts a message to Microsoft Teams when a new lead is added to a SharePoint list. The flow runs successfully, but the message is not appearing in the expected Teams channel. What is the first thing you should check?

Question 157mediummulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which TWO of the following are valid trigger types that can start a Power Automate flow?

Question 158hardmulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which THREE of the following are best practices for creating maintainable Power Automate flows?

Question 159mediummulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which TWO of the following are capabilities of Power Automate that help with monitoring and troubleshooting flows?

Question 160hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

Contoso Ltd. has a Power Automate flow that runs daily at 8:00 AM to synchronize customer data from an on-premises SQL Server database to Dataverse. The flow uses an on-premises data gateway to connect to the SQL Server. Recently, the flow started failing with the error: 'Unable to connect to the gateway. The gateway is offline.' The IT administrator confirms that the gateway service is running on the on-premises server, and the server has internet connectivity. You need to resolve the issue. What should you do?

Question 161mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

Fabrikam Inc. uses Power Automate to automate expense report approvals. The flow is triggered when an expense report is submitted in a SharePoint list. The flow then sends an approval request to the expense approver via the Approvals connector. If approved, the flow updates the SharePoint list status to 'Approved' and sends a confirmation email to the submitter. If rejected, it updates the status to 'Rejected' and sends a rejection email. Currently, the flow works for single approvers, but the business now requires that if the expense amount exceeds $5,000, the approval must be sent to a senior manager instead of the regular manager. You need to modify the flow to meet this requirement with minimal maintenance. What should you do?

Question 162easymultiple choice

Read the full NAT/PAT explanation →

A non-profit organization uses Power Automate to automatically send thank-you emails to donors after they make a donation through a third-party payment gateway. The flow is triggered when a new row is added to a Dataverse table named 'Donations'. The flow then uses the 'Send an email (V2)' action to send the email. The flow has been working for months, but today donors started complaining that they are not receiving the thank-you emails. The flow run history shows that the flow runs successfully and the 'Send an email' action shows 'Succeeded'. What is the most likely cause of the issue?

Question 163easymulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which TWO capabilities are provided by Power Automate flows?

Question 164mediummulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which THREE actions can a Power Automate flow perform using AI Builder?

Question 165hardmulti select

Read the full Demonstrate the capabilities of Power Automate explanation →

Which TWO types of triggers can be used in a Power Automate cloud flow?

Question 166easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You are a business analyst at a manufacturing company. You need to create a flow that automatically saves email attachments from a specific sender to a SharePoint document library. The flow should trigger when a new email arrives in your mailbox. What should you use?

Question 167mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

Your organization uses Microsoft Teams for collaboration. You want to create a flow that sends a welcome message to a new member when they are added to a specific team. The flow should be triggered automatically without manual intervention. Which type of flow should you create?

Question 168hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You are a Power Automate administrator. A user reports that a cloud flow stopped working after you updated the environment's data loss prevention (DLP) policy. The flow uses the SharePoint and Outlook connectors. The new DLP policy only allows these connectors in the 'Business' group, but the flow was previously working. What is the most likely cause of the failure?

Question 169mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You need to create a flow that runs on the first day of every month and sends a summary email of all new SharePoint list items added in the previous month. The email should be sent to the sales team. Which type of flow should you create?

Question 170hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

Your company uses Power Automate to handle approvals for purchase orders. You need to create a flow that triggers when an item is added to a SharePoint list, checks if the amount exceeds $10,000, and if so, sends an approval request to the finance manager. If approved, the item status should be updated to 'Approved'. Which type of flow should you use?

Question 171easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You are creating a flow that should run only when a button is pressed in a mobile app. The flow will send an email to a manager with the current location of the user. Which type of flow should you create?

Question 172mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

Your organization uses Power Automate to integrate with Microsoft 365 services. You need to create a flow that automatically creates a contact in Outlook when a new lead is added to Dynamics 365. The flow should run immediately when the lead is created. Which connector should you use as the trigger?

Question 173hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You have a Power Automate flow that uses a Dataverse connector to update a record when an approval is completed. The flow previously worked but now fails with an error 'Connection not found'. You verify that the connection to Dataverse still exists and the user has appropriate permissions. What is the most likely cause?

Question 174easymultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You need to create a flow that runs every hour to check a SharePoint list for items with a 'Due Date' that has passed and sends a reminder email to the assigned person. Which type of flow should you create?

Question 175mediummultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

You are building a flow to automate the process of copying files from one SharePoint document library to another when a file is added. The flow should also send an email notification to a team. You have created the flow, but it is not triggering when a new file is added. What should you check first?

Question 176hardmultiple choice

Read the full Demonstrate the capabilities of Power Automate explanation →

Your company has a Power Automate flow that processes orders from a third-party system via an HTTP request trigger. Recently, the flow started failing with a '400 Bad Request' error. You verify that the request payload format matches the expected JSON schema. What is the most likely cause?