Knowledge + Practice

CCNA Demonstrate the capabilities of Power Automate Questions

73 of 148 questions · Page 2/2 · Demonstrate the capabilities of Power Automate · Answers revealed

Practice these questions Domain overview All questions

76

Multi-Selecteasy

Which TWO capabilities are provided by Power Automate flows?

Select 2 answers

A.Automate tasks in cloud services like SharePoint and Outlook

B.Design relational databases for analytics

C.Manage user permissions in Microsoft Entra ID

D.Create desktop-based automation for legacy systems

E.Build custom user interfaces for mobile apps

AnswersA, D

Cloud flows automate cloud services.

Why this answer

Power Automate includes cloud flows for automating cloud services and desktop flows for legacy/desktop automation. Business process flows are part of model-driven apps, not Power Automate flows. Approval flows are a type of flow, but the question asks for capabilities, not types.

Practice this question →

77

MCQeasy

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?

A.When a user is removed

B.When a group is added

C.When a user is updated

D.When a user is added

AnswerD

This trigger fires when a new user is created.

Why this answer

'When a user is added' triggers when a new user is created. Option A is wrong because it triggers when a user is deleted, not created. Option B is wrong because it triggers when a group is added, not a user.

Option C is wrong because it triggers when a user is updated, not created.

Practice this question →

78

MCQeasy

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?

A.Instant cloud flow

B.Scheduled cloud flow

C.Automated cloud flow

D.Desktop flow

AnswerA

Instant flows can be triggered from a button or app.

Why this answer

An instant cloud flow can be triggered from a button or app. Automated flows trigger on events. Scheduled flows run on schedule.

Desktop flows are for desktop automation.

Practice this question →

79

MCQeasy

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?

A.When a file is deleted

B.When a file is modified

C.When a file is created

D.When a file is created or modified

AnswerC

Correct. This trigger fires when a new file is created in the SharePoint document library.

Why this answer

The 'When a file is created' trigger is designed to start a flow when a new file appears in a SharePoint library. Option A is wrong because 'When a file is deleted' triggers on file removal, not creation. Option B is wrong because 'When a file is modified' triggers on updates, not new files.

Option D is wrong because 'When a file is created or modified' includes modification events, which are not required for the specified requirement.

Practice this question →

80

MCQhard

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?

A.Configure duplicate detection rules in Dataverse and use the 'Create a new record' action with duplicate detection enabled.

B.Use the 'Compose' action to check for duplicates before creation.

C.Use the 'Update a record' action instead of 'Create a new record' to update existing records.

D.Use the 'Delete a record' action before creating a new one.

AnswerA

Configuring duplicate detection rules in Dataverse and using the 'Create a new record' action with duplicate detection enabled will prevent duplicates.

Why this answer

Configuring duplicate detection rules in Dataverse and using the 'Create a new record' action with duplicate detection enabled will prevent duplicates. Option B is wrong because the 'Compose' action is used to create variables and does not check for duplicates. Option C is wrong because using 'Update a record' requires an existing record; it does not prevent creation of duplicates.

Option D is wrong because using 'Delete a record' before creating a new one is not a standard method to handle duplicate detection and may cause data loss.

Practice this question →

81

MCQhard

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?

A.The generated schema does not account for all possible fields.

B.The flow is trying to parse the JSON before receiving it.

C.The webhook is not sending a valid JSON payload.

D.The JSON contains a nested object that is not defined.

AnswerA

Extra fields cause schema mismatch.

Why this answer

The 'Parse JSON' action uses a schema generated from a sample payload. If the sample did not include optional fields that the webhook sometimes sends, those fields are not defined in the schema, causing the action to fail with 'Invalid JSON'. Option B is incorrect because the flow receives the data before parsing; the issue is with the schema, not timing.

Option C is incorrect because the webhook is sending valid JSON—the error occurs only when the JSON contains fields not in the schema. Option D is incorrect because a missing nested object would cause a different error related to missing property, not 'Invalid JSON'.

Practice this question →

82

Multi-Selectmedium

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

Select 2 answers

A.The 'When a flow is completed' trigger

B.Automatic email notifications when a flow fails

C.Analytics in the Power Platform admin center

D.Run history for each flow execution

E.The 'Configure run after' setting

AnswersC, D

Correct. Analytics in the Power Platform admin center provide dashboards and reports on flow usage, performance, and errors, enabling monitoring and troubleshooting at an administrative level.

Why this answer

The correct answers are C and D. Run history provides detailed information about each flow execution, including inputs, outputs, and errors, allowing users to troubleshoot issues. Analytics in the Power Platform admin center offer insights into flow usage, performance, and error trends.

Option A is incorrect because the 'When a flow is completed' trigger is used to start another flow upon completion, not for monitoring or troubleshooting. Option B is incorrect because automatic email notifications on failure are not a built-in monitoring capability; they can be configured as part of a flow, but they are not a platform-level monitoring feature. Option E is incorrect because the 'Configure run after' setting controls what happens after a previous action fails, skips, or succeeds; it is a configuration for flow logic, not a monitoring/troubleshooting capability.

Practice this question →

83

Multi-Selecteasy

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

Select 2 answers

A.Recurrence triggers

B.Automated triggers

C.Scheduled triggers

D.Instant triggers

E.Manual triggers

AnswersB, C

Correct: These fire based on events like new email.

Why this answer

Options B and C are correct. Automated triggers are event-based and fire when something specific happens, such as receiving an email or a new file being created. Scheduled triggers run at a specific time or on a recurring schedule.

Option A (Recurrence) is a specific type of scheduled trigger, not a primary type. Options D (Instant) and E (Manual) are often considered subtypes of manual triggers, not primary types.

Practice this question →

84

MCQhard

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?

A.The SharePoint trigger did not fire

B.The email connector is not properly configured or the SMTP server is down

C.The scope 'SendNotification' failed due to a missing variable

D.The SharePoint list permissions are incorrect

AnswerB

Correct. The error indicates a connectivity issue with the mail server.

Why this answer

The flow log shows a failure in the 'Send an email' action, not the trigger. Since the trigger (SharePoint 'When an item is created') successfully initiated the flow, the issue lies with the email connector. The most likely cause is that the email connector (e.g., Office 365 Outlook, SMTP) is misconfigured—such as incorrect SMTP server, port, authentication, or the SMTP server being unreachable—preventing the email from being sent.

Exam trap

The trap here is that candidates assume a failed flow run always means the trigger didn't fire, but the log clearly shows the trigger succeeded and the failure is in an action, so the issue is with the downstream connector configuration.

How to eliminate wrong answers

Option A is wrong because the flow log shows the trigger fired (the flow ran), so the SharePoint trigger did fire. Option C is wrong because the scope 'SendNotification' failed due to an email sending error, not a missing variable; a missing variable would cause a different error (e.g., 'variable not found') and the log indicates a connector failure. Option D is wrong because incorrect SharePoint list permissions would prevent the trigger from firing or the flow from reading the item, but the flow ran and reached the email action, so permissions are sufficient.

Practice this question →

85

MCQmedium

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?

A.Change the flow owner to a user with full permissions to both SharePoint and OneDrive.

B.Use a service principal with appropriate permissions and configure the flow to use it.

C.Disable the 'Enhanced mode' in the SharePoint connector.

D.Configure the flow to run using the account of the user who triggers it.

AnswerB

A service principal provides consistent, elevated permissions.

Why this answer

A service principal (or managed identity) provides a consistent identity with dedicated permissions, ensuring the flow can access both SharePoint and OneDrive without relying on a user's permissions. Option A is incorrect because changing the flow owner does not guarantee that the new owner's permissions match the required access. Option C is incorrect because 'Enhanced mode' is not related to permissions; it affects connector capabilities.

Option D is incorrect because running the flow as the triggering user would only use that user's permissions, which may be insufficient and inconsistent.

Practice this question →

86

MCQmedium

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?

A.Business process flow

B.Desktop flow

C.Scheduled cloud flow

D.Automated cloud flow

AnswerC

Scheduled flows run on a recurring schedule.

Why this answer

A scheduled cloud flow can run on a recurring schedule (e.g., first day of month) and includes actions to query SharePoint and send email. Automated flows trigger on events, not schedules. Desktop flows are for desktop automation.

Business process flows guide users through stages.

Practice this question →

87

MCQeasy

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?

A.When an item is created

B.Power Apps button

C.Schedule - Recurrence

D.When a new email arrives

AnswerC

Recurrence trigger allows you to set a schedule.

Why this answer

The correct trigger for a flow that runs on a schedule (every Monday at 9 AM) is the 'Schedule - Recurrence' trigger. Option A ('When an item is created') is an event-based trigger that runs when an item is added to a list, not on a schedule. Option B ('Power Apps button') is a manual trigger that requires user interaction.

Option D ('When a new email arrives') is an event-based trigger that runs when an email arrives. Therefore, only option C meets the requirement.

Practice this question →

88

MCQeasy

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

A.When a new email arrives

B.When a row is added, modified or deleted in Dataverse

C.When a user is added to Azure AD

D.When a file is created in SharePoint

AnswerC

This trigger activates when a new user is created in Microsoft Entra ID.

Why this answer

'When a user is added to Azure AD' (now Microsoft Entra ID) triggers on new user creation. Option A is wrong because it triggers on email arrival. Option B is wrong because it triggers on Dataverse record changes.

Option D is wrong because it triggers on file creation in SharePoint.

Practice this question →

89

Multi-Selecthard

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

Select 3 answers

A.Action

B.Connector

C.Business process flow

D.Power Apps

E.Trigger

AnswersA, B, E

Actions are steps in the flow.

Why this answer

(Action), Option B (Connector), and Option E (Trigger) are the three core components of a Power Automate cloud flow. Actions are the steps performed, triggers start the flow, and connectors provide integration with services. Option C (Business process flow) is a type of model-driven app component, not a cloud flow component.

Option D (Power Apps) is a separate application platform.

Practice this question →

90

MCQmedium

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

A.The filter condition 'statecode eq 0' is invalid

B.The recurrence trigger is incorrectly configured

C.The connections to Dataverse and Office 365 are not established

D.The email action does not include the list of opportunities in the body

AnswerD

The email body is static text; it should include dynamic content from Get_items.

Why this answer

The flow's email action is configured to send a static email body without including the dynamic content from the 'List rows' action. Even if the trigger and filter are correct, the email will not contain the list of opportunities, so the flow appears to fail in its purpose. Power Automate requires explicit insertion of dynamic content (e.g., the 'value' array from Dataverse) into the email body to transmit the data.

Exam trap

The trap here is that candidates assume the flow 'fails' means a technical error (like invalid filter or missing connections), but the question tests the understanding that a flow can run successfully yet not achieve its business purpose if dynamic content is omitted from the email body.

How to eliminate wrong answers

Option A is wrong because 'statecode eq 0' is a valid OData filter query for Dataverse, where 0 typically represents the 'Active' state; the filter condition syntax is correct. Option B is wrong because the recurrence trigger configuration (e.g., frequency and interval) is syntactically valid and does not cause the flow to fail to send an email; a misconfigured recurrence would prevent the flow from starting, not from sending an email. Option C is wrong because if the connections to Dataverse and Office 365 were not established, the flow would fail at the trigger or action validation stage with a connection error, not silently fail to send an email; the exhibit shows no connection errors.

Practice this question →

91

MCQeasy

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?

A.For a selected item - SharePoint

B.Recurrence

C.Start and wait for an approval

D.When an item is created - SharePoint

AnswerD

Correct. This trigger initiates the flow when a new item is added to the list.

Why this answer

The 'When an item is created - SharePoint' trigger is the correct choice because it initiates the flow automatically whenever a new item (in this case, a new employee record) is added to the specified SharePoint list. This event-driven trigger eliminates the need for manual intervention, making it ideal for automating the welcome email process immediately upon creation.

Exam trap

The trap here is that candidates often confuse manual triggers (like 'For a selected item') with event-driven triggers, or mistakenly think a scheduled trigger (Recurrence) can achieve real-time automation, when only a creation trigger directly responds to the SharePoint list event.

How to eliminate wrong answers

Option A is wrong because 'For a selected item - SharePoint' is a manual trigger that requires a user to select an item in SharePoint and then run the flow, which does not automate the process upon creation. Option B is wrong because 'Recurrence' is a scheduled trigger that runs at specified intervals (e.g., every hour), not in response to a specific event like item creation, so it would not send the email immediately when a new employee is added. Option C is wrong because 'Start and wait for an approval' is an action used to initiate an approval process and pause the flow until a response is received, not a trigger to start the flow based on a SharePoint list event.

Practice this question →

92

MCQhard

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?

A.The flow is disabled or paused.

B.The external application is not sending the correct JSON payload.

C.The flow does not have a 'Respond to a PowerApp or flow' action to send a response.

D.The flow requires authentication and the API key is missing.

AnswerC

Correct. The missing 'Respond to a PowerApp or flow' action means the flow does not send an HTTP response, causing the caller to experience a timeout and receive a 500 Internal Server Error.

Why this answer

When a Power Automate flow is triggered by an HTTP request, it must include a 'Respond to a PowerApp or flow' action to send a response back to the caller. If this action is missing, the flow will still run but the HTTP trigger will timeout or return a 500 error because no response is sent. Option A is incorrect because if the flow were disabled, the trigger would not fire and the external application would likely get a 404 or 503, not a 500.

Option B is incorrect because the flow runs, meaning the request was received; a payload mismatch would cause a different error (like a 400) or failure within the flow. Option D is incorrect because authentication issues typically return 401 Unauthorized, not 500.

Practice this question →

93

MCQhard

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?

A.Increase the timeout setting for the CDS update action in the flow.

B.Split the flow into two: one for the SharePoint trigger and one for the CDS update, and trigger the second via HTTP request.

C.Restart the CDS environment to clear any temporary issues.

D.Reduce the concurrency setting to 1 to prevent multiple simultaneous requests.

AnswerA

The GatewayTimeout error indicates the CDS action is taking longer than the default timeout (typically 2 minutes). Increasing the timeout allows the action to complete.

Why this answer

The GatewayTimeout error indicates that the CDS update action is taking longer than the default timeout (typically 2 minutes) to complete, especially given the cross-region latency. Increasing the timeout setting for the CDS action allows the flow to wait longer for the response, resolving the intermittent failure without altering the flow's logic or concurrency.

Exam trap

The trap here is that candidates confuse a timeout error with a performance bottleneck, leading them to reduce concurrency or split the flow, rather than recognizing that the default action timeout is the direct cause of the GatewayTimeout.

How to eliminate wrong answers

Option B is wrong because splitting the flow does not address the root cause of the timeout; it adds complexity and still relies on the same CDS connector with the same timeout constraints. Option C is wrong because restarting the CDS environment is a disruptive action that does not fix a timeout caused by network latency or action duration limits; it is not a supported troubleshooting step for GatewayTimeout errors. Option D is wrong because reducing concurrency to 1 might reduce load but does not increase the timeout threshold; the error occurs on a single action that exceeds the default timeout, not due to contention from multiple requests.

Practice this question →

94

MCQhard

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?

A.The HTTP request action is not available in Power Automate.

B.The flow does not have permission to access the target list.

C.The HTTP request action cannot update SharePoint list items.

D.The site address in the HTTP request is incorrect.

AnswerD

Incorrect site address causes silent failure.

Why this answer

If the site address in the 'Send an HTTP request to SharePoint' action is incorrect, the request cannot reach the target SharePoint list, and the update fails. Option A is wrong because the HTTP request action is indeed available and can update items. Option B is wrong because the flow typically runs under the creator's or configured connection credentials; permission is usually not the issue unless explicitly insufficient.

Option C is wrong because the action can update list items when the URI and method are correct.

Practice this question →

95

MCQhard

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?

A.The 'email/To' parameter is missing the recipient's email.

B.The condition expression is incorrectly formatted.

C.The flow uses 'Send an email' instead of a proper approval action.

D.The 'body' function should be 'outputs' instead.

AnswerC

The 'Send an email' action only sends an email; it does not capture the recipient's response. An approval action like 'Start and wait for an approval' is required.

Why this answer

The flow uses the 'Send an email' action, which only sends an email message; it does not implement an approval process. The 'Succeeded' status indicates the email was sent, not that the recipient approved. To create an approval, you must use the 'Start and wait for an approval' action, which pauses the flow until the recipient responds.

Options A, B, and D are incorrect because they do not address the core issue: the lack of a proper approval action.

Practice this question →

96

MCQeasy

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

A.Post a message in Microsoft Teams

B.Create a calendar event

C.Send an HTTP request

D.Send an email (Office 365 Outlook)

AnswerD

operationId 'SendEmail' and connection 'shared_office365' match.

Why this answer

The operationId 'SendEmail' and the host connection 'shared_office365' correspond to the Office 365 Outlook Send an email action. Option A is incorrect because 'Post a message in Microsoft Teams' would use a different operationId (e.g., 'PostMessage') and connection type. Option B is incorrect because 'Create a calendar event' would have operationId like 'CreateEvent' and different parameters.

Option C is incorrect because 'Send an HTTP request' would use the 'Http' connection type, not 'shared_office365'.

Practice this question →

97

MCQmedium

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?

A.The SQL login credentials are incorrect

B.The on-premises data gateway is not running or unreachable

C.The SQL table does not exist

D.The flow trigger did not fire

AnswerB

Correct. Gateway timeout typically indicates connectivity issues to the on-premises resource.

Why this answer

The 'GatewayTimeout' error indicates that the flow successfully reached the on-premises data gateway but the gateway did not respond within the expected time frame. This typically occurs when the gateway service is not running, the machine hosting the gateway is offline, or network connectivity between the gateway and the SQL Server is broken. Incorrect credentials or missing tables would produce different errors (e.g., 'Login failed' or 'Invalid object name').

Exam trap

The trap here is that candidates confuse a 'GatewayTimeout' with authentication or data errors, assuming the issue is with credentials or the SQL object rather than the gateway's availability or network path.

How to eliminate wrong answers

Option A is wrong because incorrect SQL login credentials would result in an 'AccessDenied' or 'Login failed' error, not a timeout. Option C is wrong because a missing SQL table would produce a 'Invalid object name' or 'Table not found' error, not a timeout. Option D is wrong because if the flow trigger did not fire, the flow would not execute at all and no error would be generated.

Practice this question →

98

MCQeasy

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?

A.The flow has exceeded its daily execution quota

B.The lead entity schema in Salesforce has changed

C.The flow is hitting API rate limits

D.The Salesforce connection credentials have expired

AnswerD

Expired credentials are the most common cause of authentication failures.

Why this answer

Authentication errors typically occur when the connection credentials for the connected service (Salesforce) expire or are revoked. Option A is incorrect because exceeding execution quotas would cause flow failures but not specifically authentication errors. Option B is incorrect because schema changes would cause data conversion or mapping errors, not authentication errors.

Option C is incorrect because API rate limits would produce throttling errors (e.g., HTTP 429), not authentication errors.

Practice this question →

99

MCQeasy

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?

A.Desktop flow

B.Automated cloud flow

C.Business process flow

D.Scheduled cloud flow

AnswerD

Scheduled flows run on a recurring schedule.

Why this answer

A scheduled cloud flow runs on a recurring schedule and can include actions to query SharePoint and send email. Automated flows trigger on events, not time. Desktop flows are for desktop automation.

Business process flows guide users.

Practice this question →

100

MCQmedium

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?

A.Verify that the flow owner has a valid Power Automate license

B.Confirm that the target library exists and is accessible

C.Ensure that the environment is not in a disabled state

D.Check the trigger configuration to ensure the correct library and site are selected

AnswerD

Incorrect trigger settings are a common cause of flow not triggering.

Why this answer

The most common issue is that the trigger is not configured correctly, e.g., incorrect library, site, or permissions. Checking the trigger settings is the first step. Licenses, environment, and service status are less likely to be the issue if other flows work.

Practice this question →

101

MCQmedium

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?

A.Switch to a different API endpoint

B.Add a 'Terminate' action to stop the flow on error

C.Configure retry policy with exponential backoff

D.Reduce the timeout of the HTTP action

AnswerC

Correct: Retry policies can handle transient failures gracefully.

Why this answer

Configuring retry policy with exponential backoff is a best practice for handling HTTP 429 errors, as it automatically retries after increasing delays, reducing server load. Option A is incorrect because using a different endpoint does not address the rate limit on the original API. Option B is incorrect because terminating the flow on error does not handle the error gracefully and may cause data loss.

Option D is incorrect because reducing timeout does not prevent or handle rate limiting; it only changes how long the flow waits for a response.

Practice this question →

102

MCQeasy

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?

A.Verify that the Teams webhook URL is correctly pointing to the intended channel

B.Review the flow run history for failure details

C.Check if the SharePoint list trigger is properly configured

D.Ensure the flow owner has permissions to post to Teams

AnswerA

A wrong webhook URL would cause the message to go to the wrong channel or fail.

Why this answer

The most common misconfiguration is using the wrong webhook URL for the channel. Option B is incorrect because the trigger is working if the flow runs. Option C is incorrect because posting to Teams does not require special permissions beyond the connection.

Option D is incorrect because flow execution might not show detailed errors unless you open the run history.

Practice this question →

103

Multi-Selectmedium

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

Select 2 answers

A.Use a Scope action to group actions and configure error handling

B.Add a Condition action to check for errors

C.Use a Compose action to store error details

D.Configure Run After settings

E.Add an Apply to Each action

AnswersA, D

Scope allows parallel branches and combined error handling.

Why this answer

Options A and D are correct because a Scope action can group actions and allow you to configure error handling for the group, and the Run After settings let you specify what happens when a previous action fails, succeeds, or times out. Option B is incorrect because a Condition action is used for conditional logic, not error handling. Option C is incorrect because a Compose action is used to build data, not handle errors.

Option E is incorrect because the Apply to Each action is used to iterate over arrays, not for error handling.

Practice this question →

104

MCQeasy

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?

A.When an item is created trigger and Post message action

B.When a new email arrives trigger and Send push notification action

C.When an approval request is triggered and Send email action

D.Recurrence trigger and Send email action

AnswerB

This directly addresses the requirement.

Why this answer

The 'When a new email arrives' trigger is designed to monitor an inbox for incoming messages, and the 'Send push notification' action sends a notification directly to a mobile device via the Power Automate mobile app or Microsoft Teams. This combination directly fulfills the requirement to react to a high-priority email and deliver a push notification to the user's device.

Exam trap

The trap here is that candidates often confuse 'Send push notification' with 'Send email' or 'Post message', not realizing that push notifications are device-specific and require the Power Automate mobile app, while email actions send traditional email messages.

How to eliminate wrong answers

Option A is wrong because the 'When an item is created' trigger is specific to a data source like SharePoint or Dataverse, not an email inbox, and the 'Post message' action sends a message to a channel or chat, not a push notification to a mobile device. Option C is wrong because the 'When an approval request is triggered' trigger waits for an approval action, not an incoming email, and the 'Send email' action sends an email, not a push notification. Option D is wrong because the 'Recurrence' trigger runs on a schedule, not in response to an email event, and the 'Send email' action sends an email, not a push notification.

Practice this question →

105

MCQmedium

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?

A.Verify that the flow is enabled.

B.Ensure that the Sentinel data connector is properly installed.

C.Review the trigger condition or filter query.

D.Check if the ServiceNow connector is configured with the correct instance.

AnswerC

Filter may exclude critical alerts.

Why this answer

The flow uses a trigger condition or filter query that may be set to only fire for specific alert severity levels or types. If the filter is misconfigured, critical alerts might be filtered out even though they are generated in Sentinel. Option A is incorrect because the flow runs, so it is enabled.

Option B is incorrect because the issue is not about data connector installation; alerts are appearing in Sentinel logs. Option D is incorrect because if the ServiceNow connector were misconfigured, the flow might fail at a later step, but the issue is likely that the trigger is not firing due to the filter.

Practice this question →

106

MCQmedium

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?

A.The Microsoft Entra ID license has expired.

B.The flow is exceeding the API request throttle limit.

C.The connection used in the flow lacks appropriate permissions.

D.The Power Automate connector for Microsoft Entra ID is deprecated.

AnswerC

403 Forbidden indicates the authenticated identity does not have permission to perform the action.

Why this answer

A '403 Forbidden' error typically indicates that the connection used in the flow does not have the necessary permissions to access Microsoft Entra ID. Option A is incorrect because license expiration would result in a different error, such as a '402 Payment Required'. Option B is incorrect because throttling limits cause '429 Too Many Requests' errors.

Option D is incorrect because a deprecated connector would likely cause errors related to compatibility or connectivity, not a '403 Forbidden'.

Practice this question →

107

Multi-Selecteasy

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

Select 2 answers

A.A trigger

B.An approval action

C.A variable

D.A condition

E.A Send an email action

AnswersA, E

Correct. Every flow needs a trigger.

Why this answer

A trigger is required because a Power Automate flow must have a starting event to initiate execution. For a SharePoint list, the 'When an item is created' trigger fires automatically when a new item is added, which is the necessary first step before any actions can run.

Exam trap

The trap here is that candidates often think a condition or approval is needed for any 'smart' automation, but the question only asks for the minimum components to send an email on item creation, which is just a trigger and an action.

Practice this question →

108

Multi-Selecteasy

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

Select 2 answers

A.Standard

B.Custom

C.Enterprise

D.On-premises

E.Premium

AnswersA, E

Correct. Standard connectors are included with all Power Automate plans.

Why this answer

A and E are correct. Standard connectors are available to all Power Automate users without additional licensing. Premium connectors, such as those for Salesforce or Common Data Service, require a Premium license.

Option B (Custom) is a type of connector but not a licensing tier, and it is not one of the two correct answers. Option C (Enterprise) is not a recognized connector tier in Power Automate. Option D (On-premises) refers to the data gateway needed for on-premises data sources, not a connector type.

Practice this question →

109

MCQhard

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?

A.Use the 'Peek code' feature to review the flow definition.

B.Check the gateway status for the shared mailbox.

C.Review the flow run history and look for 'skipped' status.

D.Pause the flow and restart it.

AnswerC

Skipped runs indicate throttling or quota limits.

Why this answer

Flow run history in Power Automate explicitly records 'skipped' status for runs that were throttled due to service protection limits. By reviewing the run history and filtering for 'skipped' runs, you can directly confirm whether the flow is being rate-limited, which is the most likely cause of missed emails.

Exam trap

The trap here is that candidates may confuse 'skipped' status with 'failed' status, or assume that pausing/restarting the flow (Option D) is a valid diagnostic step, when in fact only run history provides the specific throttling evidence needed.

How to eliminate wrong answers

Option A is wrong because 'Peek code' shows the underlying JSON definition of the flow, which is useful for debugging logic or expressions but does not provide any information about runtime throttling or service protection limits. Option B is wrong because gateway status is relevant only for on-premises data gateways; a shared mailbox in Exchange Online does not use a gateway, so checking gateway status would not help diagnose service protection limits. Option D is wrong because pausing and restarting the flow does not diagnose the root cause; it only temporarily resets the flow's state, and the throttling will reoccur if the underlying limit issue is not addressed.

Practice this question →

110

MCQmedium

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?

A.Add a 'Condition' action inside the loop.

B.Use a 'Do until' loop instead.

C.Enable concurrency control on the 'Apply to each' action.

D.Reduce the number of items in the list.

AnswerC

Concurrency processes items in parallel.

Why this answer

Enabling concurrency control on the 'Apply to each' action allows multiple iterations to run in parallel, significantly reducing total processing time. Option A adds a condition inside the loop, which does not improve performance and may even add overhead. Option B replaces the loop with a 'Do until' loop, which still processes items sequentially.

Option D reduces the number of items, which is not always feasible and does not improve the flow's efficiency when processing large lists.

Practice this question →

111

MCQmedium

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?

A.The flow owner's mailbox is full

B.The Approvals connector is not properly configured

C.The flow run history shows a success

D.The approver’s email address is incorrect in the flow

AnswerB

Correct: Misconfiguration can prevent email dispatch.

Why this answer

The 'Start and wait for an approval' action relies on the Approvals connector to send approval requests. If the connector is not properly configured (e.g., missing required connections or permissions), the approval email may not be sent. Option A is wrong because the flow owner's mailbox does not directly affect approval delivery.

Option C is wrong because a successful flow run history indicates the action executed, but does not guarantee the email was delivered. Option D is wrong because the approver's email address is defined within the 'Start and wait for an approval' action; if it were incorrect, the flow would likely fail, but the issue here is about email delivery, not address validity.

Exam trap

The 'Start and wait for an approval' action depends on the Approvals connector being correctly configured; a common mistake is to assume the action will work without verifying connector setup.

Practice this question →

112

MCQeasy

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?

A.When a file is created (SharePoint)

B.When a file is modified (OneDrive for Business)

C.When a file is created (OneDrive for Business)

D.When a file is created (OneDrive)

AnswerC

This trigger fires when a new file is added to OneDrive for Business.

Why this answer

The requirement specifies a OneDrive for Business folder, and the 'When a file is created (OneDrive for Business)' trigger is the only one that directly monitors a OneDrive for Business location for new file additions. This trigger uses the OneDrive for Business connector, which is designed to work with the Microsoft Graph API for OneDrive for Business, and it fires specifically when a new file is created, not modified.

Exam trap

The trap here is that candidates confuse the 'OneDrive' and 'OneDrive for Business' connectors, assuming they are interchangeable, but they target different services with different authentication and API scopes.

How to eliminate wrong answers

Option A is wrong because the 'When a file is created (SharePoint)' trigger monitors SharePoint document libraries, not OneDrive for Business folders; using it would require a SharePoint site and library, which is a different storage service. Option B is wrong because the 'When a file is modified (OneDrive for Business)' trigger fires when an existing file is changed, not when a new file is added, so it does not meet the requirement to trigger on file creation. Option D is wrong because the 'When a file is created (OneDrive)' trigger targets the consumer OneDrive service (personal Microsoft account), not OneDrive for Business (work or school account), and these are separate connectors with different authentication and API endpoints.

Practice this question →

113

MCQmedium

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

A.Sending an email to multiple recipients.

B.Sending an email with an attachment.

C.Checking if a condition is true before sending.

D.Sending an email to a single recipient.

AnswerD

The operation is SendEmailV2 with a single To address.

Why this answer

The SendEmailV2 action typically includes a 'To' parameter that accepts a single email address (or a dynamic value resolving to one address). The exhibit does not show multiple recipients, attachments, or condition checks. Option A is incorrect as multiple recipients would require semicolons or an array.

Option B is incorrect because no attachment parameter is visible. Option C is incorrect because the action sends an email, not checks a condition.

Practice this question →

114

Multi-Selectmedium

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

Select 3 answers

A.Scheduled

B.Business process flow

C.Instant

D.Manual

E.Automated

AnswersA, C, E

Triggers based on a schedule (recurrence).

Why this answer

Options A, C, and E are correct. The three main trigger types in Power Automate are Automated (e.g., when an email arrives), Instant (e.g., button trigger), and Scheduled (e.g., recurrence). Option B (Business process flow) is not a trigger type; it is a feature for modeling business processes.

Option D (Manual) is not a separate trigger type; manual triggers are covered under Instant triggers.

Practice this question →

115

Multi-Selecthard

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

Select 3 answers

A.A 'Start and wait for an approval' action

B.A manual button to start the flow

C.A trigger such as 'When a new response is submitted' from Microsoft Forms

D.A SharePoint list to store approval history

E.A 'Post a message in a chat or channel' action to notify the approver

AnswersA, C, E

This action creates and waits for the approval.

Why this answer

Options A, C, and E are correct because they represent the trigger, approval action, and notification. Option B is wrong because it's for manual triggers. Option D is wrong because it's not required for approvals.

Practice this question →

116

MCQhard

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?

A.Implement retry logic with exponential backoff in the HTTP action settings.

B.Increase the flow's concurrency setting to process more requests simultaneously.

C.Use a 'Condition' action to check the status code and ignore 429 errors.

D.Use the 'Configure Run After' option to skip the action on failure.

AnswerA

Exponential backoff reduces request rate after 429 responses.

Why this answer

Implementing retry logic with exponential backoff allows the flow to automatically retry the request after a delay that increases with each attempt, which is the standard approach to handle rate limiting (HTTP 429 errors) and reduces server load. Option B is wrong because increasing concurrency would send more requests simultaneously, likely exacerbating the rate limit issue. Option C is wrong because simply ignoring 429 errors means requests are not retried and the action fails.

Option D is wrong because 'Configure Run After' can handle failures but does not implement backoff, so it would not effectively manage rate limits.

Practice this question →

117

MCQmedium

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?

A.The emails are from external senders.

B.The mailbox is a shared mailbox.

C.The subject filter only applies to the first word.

D.The emails are older than 7 days.

AnswerD

The trigger has a default look-back window of 7 days.

Why this answer

The 'When a new email arrives' trigger in Power Automate only processes emails from the last 7 days by default. Older emails are ignored, so even if the subject contains 'Task', they won't trigger the flow. Option A is incorrect because the trigger can handle emails from external senders.

Option B is incorrect because shared mailboxes work with proper configuration. Option C is incorrect because the subject filter applies to the entire subject line, not just the first word.

Practice this question →

118

Multi-Selecteasy

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

Select 2 answers

A.SQL Server

B.SharePoint

C.Azure Blob Storage

D.Salesforce

E.Microsoft Teams

AnswersB, E

SharePoint connector is standard.

Why this answer

SharePoint is a standard connector available in Power Automate with Office 365 licenses, which do not require a premium license. It enables workflows for list item creation, approval processes, and document management without additional per-user costs.

Exam trap

The trap here is that candidates often assume SQL Server is a standard connector because it is widely used, but Microsoft explicitly categorizes it as premium due to its dependency on the on-premises data gateway and enterprise data integration capabilities.

Practice this question →

119

Multi-Selecthard

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

Select 3 answers

A.Office 365 Outlook

B.SQL Server Management Studio

C.Azure DevOps Services

D.Microsoft Teams

E.SharePoint

AnswersA, D, E

Outlook connector is widely used.

Why this answer

The correct answers are A, D, and E. Office 365 Outlook, Microsoft Teams, and SharePoint are all standard connectors in Power Automate. Option B is incorrect because the connector is named 'SQL Server', not 'SQL Server Management Studio'.

Option C is incorrect because the official connector name is 'Azure DevOps', not 'Azure DevOps Services'.

Practice this question →

120

MCQmedium

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

A.Any email with an attachment

B.Emails with 'Invoice' in the subject line

C.Emails marked as high importance

D.Any email with or without attachments

AnswerB

subjectFilter is set to 'Invoice'.

Why this answer

The trigger condition 'subjectFilter' is set to 'Invoice', meaning only emails with 'Invoice' in the subject line will trigger the flow. Option A is incorrect because 'includeAttachments' is set to false, so attachments are not required. Option C is incorrect because 'importance' is set to 'Any', so importance is not a filter.

Option D is incorrect because the flow requires a specific subject filter, not any email.

Practice this question →

121

MCQmedium

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?

A.The manager does not have a Power Automate license.

B.The flow is using a deprecated trigger.

C.The approval is configured with the wrong response options.

D.The flow is paused due to a quota limit.

AnswerA

Approval actions require the approver to have a Power Automate license or appropriate rights.

Why this answer

The most likely cause is that the manager does not have a Power Automate license (Option A). For approval flows in Power Automate, the approver must have a license that includes Power Automate rights (such as a Power Automate per-user plan or a Microsoft 365 license that includes Power Automate capabilities). Even if the manager's email is correctly configured in Microsoft Entra ID, without the appropriate license the approval request cannot be delivered.

Option B (deprecated trigger) is unlikely because a deprecated trigger would cause the flow to fail to run entirely, not specifically fail to deliver an approval. Option C (wrong response options) would only affect the approver's ability to respond, not the delivery of the request. Option D (quota limit) would pause the flow itself, not prevent delivery of an individual approval request.

Practice this question →

122

MCQmedium

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?

A.The flow requires a premium Power Automate license.

B.The trigger is set to 'When an item is created or modified' and the item is being created and then modified immediately.

C.The user does not have permission to view the SharePoint list.

D.The flow has a 'Delay' action before the approval step.

AnswerB

If the trigger is set to 'When an item is created or modified', a modification after creation could cause the trigger to fire on the modification, but if the modification occurs too quickly, the creation trigger might be skipped.

Why this answer

The SharePoint trigger 'When an item is created' must be set to trigger only on new items, not on changes. A common misconfiguration is setting the trigger to 'When an item is created or modified', which can cause missed triggers if the item is created and then quickly modified. Option A is incorrect because SharePoint triggers do not require a premium license for basic actions.

Option C is incorrect because permissions to the list do not affect the trigger's ability to fire. Option D is incorrect because the delay is unrelated to the trigger configuration.

Practice this question →

123

MCQhard

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?

A.The condition uses 'greater' but should use 'greaterThan'.

B.The 'score' value is passed as a string instead of a number.

C.The condition expression is misspelled as 'greater' instead of 'greaterThan'.

D.The trigger is set to 'When a file is created' but the request is HTTP.

AnswerB

Correct. If the 'score' value is passed as a string, the 'greater' function compares a string to a number, causing the condition to evaluate to false.

Why this answer

If the 'score' property is passed as a string (e.g., '0.9') instead of a number, the comparison 'greater(triggerBody()?['score'], 0.8)' will compare a string to a number, which will not work as intended. Power Automate's 'greater' function requires both arguments to be numbers; a string comparison will not evaluate correctly, causing the condition to evaluate to false, thus the approval email is not sent and the flow proceeds to the default action (log to SharePoint). Option A is incorrect because 'greater' is the correct function name in Power Automate; 'greaterThan' is not a valid function.

Option C is also incorrect because the function 'greater' is spelled correctly; the issue is data type, not spelling. Option D is incorrect because the trigger is explicitly described as an HTTP request in the stem, not 'When a file is created'.

Practice this question →

124

Multi-Selectmedium

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

Select 2 answers

A.Build a custom AI model to analyze images

B.Assign Microsoft 365 licenses to users

C.Create a new item in a SharePoint list

D.Send an email using Office 365 Outlook

E.Design a Power BI dashboard

AnswersC, D

SharePoint connector can create items.

Why this answer

Options C and D are correct. Power Automate can create new items in SharePoint lists and send emails using Office 365 Outlook. Option A is incorrect because building custom AI models is done with AI Builder, not Power Automate.

Option B is incorrect because assigning Microsoft 365 licenses is performed in the Microsoft 365 admin center. Option E is incorrect because designing Power BI dashboards is done in Power BI Desktop.

Practice this question →

125

MCQeasy

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?

A.The OneDrive for Business connector is not licensed.

B.The chosen trigger cannot be used in a solution-aware flow.

C.The flow cannot be saved outside a solution.

D.The flow will not run because of this warning.

AnswerB

Some triggers are not solution-compatible.

Why this answer

The 'When a new file is created' trigger for SharePoint is not available in solution-aware flows (it is a non-solution trigger). Option A is wrong because the OneDrive for Business connector is licensed and supported. Option C is wrong because the flow can be saved outside a solution, but the warning indicates that the trigger cannot be used in a solution.

Option D is wrong because the warning is informational and does not prevent the flow from running.

Practice this question →

126

MCQeasy

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?

A.Check the flow run history for errors.

B.Recreate the flow from scratch.

C.Verify that notifications are enabled in the user's profile.

D.Adjust the flow schedule to run more frequently.

AnswerA

Run history shows execution details and errors.

Why this answer

The first step to diagnose why a scheduled flow runs but does not send notifications is to check the flow run history. The run history provides details about each run, including success, failure, and any error messages, which can indicate why notifications are not being sent. Option B (recreating the flow) is premature without understanding the root cause.

Option C (verifying notifications in the user's profile) may be relevant but should come after checking run history. Option D (adjusting the schedule) does not address the issue since the flow runs already.

Practice this question →

127

MCQeasy

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?

A.Remove 'quantity' from the required array inside the items schema.

B.Add 'items' to the top-level required array.

C.Change the type of 'quantity' to 'string'.

D.Remove the 'required' array from the top level.

AnswerA

Makes quantity optional.

Why this answer

The schema defines 'quantity' as required in each item. To make it optional, you should remove it from the 'required' array inside the items schema. Option B is wrong because the 'items' array itself is not required.

Option C is wrong because changing the type to 'string' is incorrect. Option D is wrong because the issue is in the child object, not the parent.

Practice this question →

128

Multi-Selecteasy

Which TWO are valid trigger types in Power Automate?

Select 2 answers

A.For a selected file

B.Create a new row

C.Apply to each

D.Send an email

E.When an item is created

AnswersA, E

This is a manual trigger for files.

Why this answer

Options A and E are correct because they are valid trigger types in Power Automate. 'For a selected file' triggers a flow when a file is selected, and 'When an item is created' triggers when an item is created in a data source. Options B, C, and D are actions, not triggers.

Practice this question →

129

Multi-Selectmedium

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

Select 3 answers

A.Solution checker

B.Flow checker

C.Run history

D.Alerts

E.Flow analytics

AnswersC, D, E

Shows details of each flow execution.

Why this answer

The correct answers are C (Run history), D (Alerts), and E (Flow analytics). Run history provides execution details for each flow run, Alerts notify administrators of failures or critical events, and Flow analytics offers insights into flow performance and trends. Options A (Solution checker) and B (Flow checker) are validation tools, not monitoring or management features.

Practice this question →

130

MCQhard

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?

A.Modify the existing condition to check if amount exceeds $10,000, and if false, terminate the flow

B.Add a second condition inside the 'Status equals Shipped' condition that checks if amount exceeds $10,000; place the approval action inside this new condition, and the email action after it

C.Use a 'Switch' action based on the amount, with cases for >10000 and <=10000

D.Add a 'Parallel branch' after the trigger: one branch for approval, one for email

AnswerB

This ensures approval only for high-value orders, and email is sent after approval or directly for small orders.

Why this answer

It adds a nested condition inside the existing 'Status equals Shipped' condition to check if the order amount exceeds $10,000. The approval action is placed inside this nested condition (for orders over $10,000), while the email action is placed after the nested condition but still within the 'Status equals Shipped' condition. This ensures that only orders over $10,000 require manager approval, and all shipped orders (regardless of amount) eventually send the email—either directly (if under $10,000) or after approval (if over $10,000).

Exam trap

The trap here is that candidates often think a single condition with a 'terminate' action (Option A) is sufficient, but they overlook that terminating the flow for low-value orders would also stop the email, whereas the requirement is to skip only the approval, not the email.

How to eliminate wrong answers

Option A is wrong because modifying the existing condition to check if amount exceeds $10,000 and terminating the flow for false would stop the flow entirely for orders under $10,000, preventing the email from being sent—which is not the requirement. Option C is wrong because a 'Switch' action based on the amount would evaluate the amount before checking the Status, potentially running the wrong branch if the order is not yet 'Shipped', and it does not naturally handle the sequential logic of approval then email for high-value orders. Option D is wrong because adding a 'Parallel branch' after the trigger would run both branches simultaneously, meaning the email could be sent before the manager approves (or even if approval is denied), violating the requirement that approval must happen before the email for orders over $10,000.

Practice this question →

131

MCQmedium

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?

A.The flow uses a premium connector that requires a license

B.The file is being co-authored by multiple users

C.A trigger condition is filtering out some files

D.The file content contains sensitive information

AnswerC

Correct. Trigger conditions may exclude files based on metadata.

Why this answer

Trigger conditions in Power Automate allow you to define expressions that must evaluate to true for the flow to run. If a condition is configured to filter out certain files (e.g., based on file name, metadata, or size), those files will not trigger the flow, and no email will be sent. This is the most likely cause when emails are missing for some files but not all.

Exam trap

The trap here is that candidates assume email failures are due to licensing or content issues, but the most common cause in practice is a misconfigured trigger condition that silently filters out legitimate file additions.

How to eliminate wrong answers

Option A is wrong because the flow uses a SharePoint trigger and an email action, both of which are standard connectors included with Power Automate licenses; premium connectors are not involved. Option B is wrong because co-authoring does not prevent the 'When a file is created' trigger from firing; the trigger fires once when the file is first added, regardless of subsequent edits. Option D is wrong because file content containing sensitive information does not affect the trigger or email sending; Power Automate does not inspect or filter content for sensitivity by default.

Practice this question →

132

MCQhard

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?

A.The flow requires a premium Power Automate license

B.Users do not have the Power Automate mobile app installed

C.The flow is exceeding API rate limits for notifications

D.The trigger is not correctly configured for high-priority tickets

AnswerB

The mobile app is required to receive push notifications.

Why this answer

Push notifications require the user to have the Power Automate mobile app installed and be signed in with the same account. Option A is incorrect because notification actions do not require premium licenses. Option C is incorrect because notification actions do not use API rate limits.

Option D is incorrect because the flow runs successfully, indicating the trigger is configured correctly.

Practice this question →

133

MCQmedium

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?

A.The SQL Server credentials are incorrect.

B.The flow creator does not have a Power Automate license.

C.The on-premises data gateway is offline or unreachable.

D.The flow trigger is misconfigured.

AnswerC

GatewayTimeout directly indicates gateway connectivity problems.

Why this answer

A GatewayTimeout error typically indicates that the gateway is not reachable or has been offline due to network issues, maintenance, or misconfiguration. Option A is wrong because incorrect credentials would cause authentication errors, not timeout. Option B is wrong because a misconfigured trigger would cause a different error at flow start.

Option D is wrong because insufficient license would cause a quota or permission error.

Practice this question →

134

MCQhard

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?

A.Restart the on-premises data gateway service on the server

B.Remove the gateway from the flow and use a direct connection

C.Configure the firewall on the on-premises server to allow outbound traffic to Azure

D.Reinstall the on-premises data gateway and verify it appears online in the Power Platform admin center

AnswerD

Reinstalling can fix registration issues and ensure the gateway is recognized.

Why this answer

The gateway is showing as offline in the Power Platform admin center despite the service running. Reinstalling the gateway updates its registration and re-authenticates it with the cloud, which resolves the inconsistent connection state. Option A is incorrect because the service is already running; simply restarting may not fix a registration or certificate issue.

Option B is incorrect because the on-premises SQL Server requires the gateway for Dataverse connectivity; a direct connection is not supported for on-premises data sources. Option C is incorrect because the firewall already allows outbound traffic (the server has internet connectivity), and the error indicates a gateway status issue, not a network block.

Practice this question →

135

MCQeasy

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?

A.When a new response is submitted (Forms)

B.When a new email arrives (Outlook)

C.When an item is created (SharePoint)

D.When a row is added, modified or deleted (Dataverse)

AnswerD

Correct: Dataverse uses row-level triggers.

Why this answer

The trigger 'When a row is added, modified or deleted' in Dataverse is used when a support ticket is submitted in a Dataverse table. Option A is incorrect because the Forms trigger is for form responses, not Dataverse tables. Option B is incorrect because the Outlook email trigger is for incoming emails.

Option C is incorrect because the SharePoint trigger is for items in a SharePoint list.

Practice this question →

136

MCQeasy

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?

A.Webhook trigger

B.Polling trigger

C.Manual trigger

D.Scheduled trigger

AnswerB

Polling triggers check for new data at regular intervals.

Why this answer

Polling triggers check for new data at a set interval, such as every 5 minutes. Option A is incorrect because webhook triggers are event-based and fire immediately when data changes, not on a schedule. Option C is incorrect because manual triggers require user interaction to start the flow.

Option D is incorrect because scheduled triggers run at specified times but do not necessarily poll a system; they are used to schedule recurring actions.

Practice this question →

137

MCQeasy

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?

A.Outlook.com

B.SharePoint

C.Office 365 Outlook

D.Microsoft Teams

AnswerD

The Microsoft Teams connector provides actions to post messages to channels.

Why this answer

Microsoft Teams. The Microsoft Teams connector allows posting messages to Teams channels, which is exactly what the scenario requires. Option A (Outlook.com) is for personal email, not Teams.

Option B (SharePoint) is for document management, not Teams messaging. Option C (Office 365 Outlook) is for email and calendar, not for posting to Teams channels.

Practice this question →

138

Multi-Selecthard

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

Select 3 answers

A.Use a 'Scope' action to group actions and configure error handling

B.Use the 'Configure run after' option to set alternative actions on failure

C.Enable 'Retry policy' on an action to automatically retry on failure

D.Use the 'if' function in expressions to check for errors

E.Configure 'Run after' settings on an action

AnswersA, B, E

A scope can have its own 'Run after' configuration to handle errors collectively.

Why this answer

Power Automate provides several built-in features for handling errors and exceptions. Option A is correct: a 'Scope' action groups actions, and you can configure error handling on the scope. Options B and E are correct: the 'Configure run after' option (or 'Run after' settings) on an action allows you to define what happens on failure, timeout, or skip, making it a direct error-handling action.

Option C is incorrect because enabling a retry policy is a configuration setting on an action, not a distinct error-handling action like Scope or Run after. Option D is incorrect as the 'if' function is an expression, not an action.

Practice this question →

139

MCQmedium

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?

A.The 'Include Attachments' option is set to 'No', so attachments are not processed.

B.The flow requires a premium connector, but only standard connectors are used.

C.The user's license does not include Power Automate capabilities.

D.The trigger is set to a shared mailbox, which is not supported.

AnswerA

The flow fails because the 'Include Attachments' option is set to 'No', so attachments are not included in the trigger output and cannot be processed.

Why this answer

The 'Include Attachments' option set to 'No' means the flow trigger does not retrieve the Excel attachment, so the subsequent actions cannot parse it. Option B is wrong because the issue is not about premium connectors; the standard 'When a new email arrives' trigger and Dataverse actions work with appropriate licenses. Option C is wrong because the failure is not due to license type; even with correct licensing, the attachment setting prevents processing.

Option D is wrong because shared mailboxes are supported for the trigger, but the attachment setting is the root cause.

Practice this question →

140

MCQhard

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?

A.Change the HTTP action to use a different API endpoint

B.Add a 'Compose' action to sanitize the input data before the HTTP request

C.Add a 'Condition' to check if the item already exists

D.Increase the retry count for the HTTP action

AnswerB

Correct: Sanitizing can fix malformed requests causing 400 errors.

Why this answer

The 400 Bad Request error typically indicates malformed request syntax, such as invalid characters in the payload. Adding a 'Compose' action to sanitize the input data (e.g., encode special characters, remove illegal XML characters) before the HTTP request can resolve the issue. Option A is wrong because the endpoint is confirmed correct, so changing it is unnecessary and would break integration.

Option C is wrong because checking for existing items addresses duplication, not malformed requests. Option D is wrong because increasing retry count only re-attempts the same failing request; it does not fix the underlying data quality issue.

Practice this question →

141

MCQmedium

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?

A.Enable pagination in the Dataverse 'List rows' action.

B.Install an on-premises data gateway to speed up data transfer.

C.Reduce the schedule frequency to run less often.

D.Increase the action timeout setting in the flow.

AnswerA

Pagination retrieves more records per page, reducing round trips.

Why this answer

Enabling pagination in the Dataverse 'List rows' action allows the flow to retrieve more rows per API call, reducing the number of requests and improving throughput, which helps avoid timeouts when dealing with large datasets. Option B is incorrect because an on-premises data gateway is used for connecting to on-premises data sources, not for speeding up cloud-to-cloud data transfer. Option C is incorrect because reducing the schedule frequency does not address the performance issue; it only runs the flow less often, but the flow itself will still take too long when it runs.

Option D is incorrect because increasing the action timeout setting only gives the flow more time to complete but does not improve performance; it may just delay the failure or mask the underlying issue.

Practice this question →

142

MCQhard

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?

A.Use 'Filter array' to select objects, then 'Insert row'.

B.Use 'Parse JSON' to define the schema, then 'Apply to each' with 'Insert row' inside.

C.Use 'Compose' to store the JSON, then 'Insert row' directly.

D.Use 'Select' to transform the array, then 'Insert row' with a batch.

AnswerB

Parse JSON provides a schema for the array, then 'Apply to each' iterates, and 'Insert row' adds records.

Why this answer

First, use 'Parse JSON' to define the schema of the JSON array returned by the API. Then, use 'Apply to each' to iterate over each object in the array. Inside the loop, use 'Insert row' to create a record in SQL Server for each object.

Option A uses 'Filter array', which only filters the array based on a condition, not iterating; it would still need a loop. Option C uses 'Compose' to store the JSON, but does not provide iteration; 'Insert row' directly would only insert the entire JSON object as a single row, not individual records. Option D uses 'Select' to transform the array's shape, but still lacks the iteration step to process each object individually.

Practice this question →

143

MCQeasy

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?

A.Recreate the connection to Dynamics 365.

B.Ensure the Planner bucket and plan are specified correctly in the action.

C.Change the trigger to 'When a record is updated' instead of created.

D.Grant the flow service principal Planner permissions.

AnswerB

The error indicates a missing template specification.

Why this answer

The error 'Invalid template specification' in the 'Create a task' action typically occurs when the Planner action is not properly configured, specifically the bucket and plan fields are missing or incorrect. Therefore, ensuring that the Planner bucket and plan are specified correctly (Option B) resolves the issue. Option A is incorrect because the error is not related to the Dynamics 365 connection.

Option C is incorrect because changing the trigger does not address the template specification error. Option D is incorrect because the error is about task configuration, not permissions.

Practice this question →

144

MCQmedium

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?

A.The flow took longer than 30 days to complete

B.The flow run history shows a failed run

C.The email was sent to the flow owner's mailbox due to configuration

D.The flow was suspended due to exceeding API limits

AnswerC

Correct: Misconfiguration can route emails incorrectly, or recipients' spam filters block them.

Why this answer

In Power Automate, if the 'Send an email' action is configured to send to the flow owner or there is a misconfiguration in the recipient field, the email might be sent to the flow owner's mailbox instead of the intended recipients. Run history shows success because the action completed, but the email was delivered to the wrong address. Option A is incorrect because a 30-day delay would cause the flow to timeout, not silently deliver to the wrong mailbox.

Option B is incorrect because the run history shows success, not failure. Option D is incorrect because exceeding API limits would cause the flow to fail or be suspended, not deliver to the wrong recipient.

Practice this question →

145

MCQmedium

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?

A.Desktop flow

B.Scheduled cloud flow

C.Instant cloud flow

D.Automated cloud flow

AnswerD

Automated flows trigger on events like new member added.

Why this answer

An automated cloud flow can use the 'When a new member is added to a team' trigger from Microsoft Teams connector. Instant flows require manual trigger. Scheduled flows run on a schedule.

Desktop flows are for desktop automation.

Practice this question →

146

MCQmedium

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?

A.Title and Created By

B.Title and Modified By

C.ID and Modified By

D.Created By and Created By Email

AnswerA

Correct dynamic values for title and creator.

Why this answer

The 'When an item is created' trigger for a SharePoint list exposes dynamic values that include the item's 'Title' field and the 'Created By' field, which contains the user who created the item. These are standard columns in a SharePoint list and are automatically available as dynamic content in Power Automate when the trigger fires.

Exam trap

The trap here is that candidates confuse 'Created By' with 'Modified By' or assume that 'Created By Email' is a direct dynamic value, when in fact the trigger exposes 'Created By' as a user object and 'Modified By' is a separate field for the last modifier.

How to eliminate wrong answers

Option B is wrong because 'Modified By' refers to the user who last modified the item, not the user who created it, so it does not satisfy the requirement to access the creator. Option C is wrong because 'ID' is the unique identifier of the item, not its title, and 'Modified By' again refers to the last modifier, not the creator. Option D is wrong because 'Created By' is correct for the creator, but 'Created By Email' is not a standard dynamic value exposed by the SharePoint trigger; the trigger exposes 'Created By' as a user object, not a separate email field, and the question asks for the user who created it, not their email.

Practice this question →

147

MCQmedium

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

A.When an email with an attachment arrives

B.When a high-importance email arrives

C.When an email is modified in the Inbox

D.When an email with 'Invoice' in the subject arrives in the Inbox

AnswerD

Correct: subjectFilter is 'Invoice' and folderPath is 'Inbox'.

Why this answer

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

Option C is wrong because the trigger is on new email arrival, not on email modification.

Practice this question →

148

MCQmedium

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?

A.SharePoint connector

B.Outlook connector

C.Microsoft Teams connector

D.Dynamics 365 connector

AnswerD

Dynamics 365 connector triggers on record creation.

Why this answer

The Dynamics 365 connector provides a 'When a record is created' trigger. SharePoint, Outlook, and Teams connectors do not trigger on Dynamics 365 leads.

Practice this question →

← PreviousPage 2 of 2 · 148 questions total

Ready to test yourself?

Try a timed practice session using only Demonstrate the capabilities of Power Automate questions.

Start 20-question session