Courseiva

CCNA Demonstrate the capabilities of Power Automate Questions

26 of 176 questions · Page 3/3 · Demonstrate the capabilities of Power Automate · Answers revealed

Practice these questionsDomain overviewAll questions
151
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

Option A is correct because 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 →
152
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 D are correct because they are standard trigger types. Option B is wrong because it's an action. Option C is wrong because it's not a trigger.

Option E is wrong because it's an action.

Practice this question →
153
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

Options A, C, and E are correct. Flow analytics provides insights, run history shows execution details, and alerts notify on failures. Option B is wrong because 'Flow checker' validates flows but is not a monitor feature.

Option D is wrong because 'Solution checker' is for Power Apps, not Power Automate.

Practice this question →
154
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

Option B is correct because 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 →
155
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

Option C is correct because 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 →
156
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

Option D is correct because 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 flow execution success means the trigger is working. Option B is incorrect because notification actions do not require premium licenses.

Option C is incorrect because notification actions do not use API rate limits.

Practice this question →
157
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

Option C is correct because 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 →
158
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

Option C is correct because the gateway can become unavailable if the associated Azure service (cloud service) is down or if the gateway's status in the Power Platform admin center shows as offline. Reinstalling the gateway is a common fix. Option A is incorrect because the gateway service is already running; restarting may not fix underlying issues.

Option B is incorrect because the flow requires the gateway; removing it would break the connection. Option D is incorrect because the issue is gateway connectivity, not firewall rules for SQL Server.

Practice this question →
159
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

Option B is correct because Dataverse triggers use 'When a row is added, modified or deleted'. Option A is wrong because SharePoint triggers are for lists. Option C is wrong because Outlook triggers are for email.

Option D is wrong because Forms triggers are for form responses.

Practice this question →
160
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

Option C is correct because polling triggers check for new data at a set interval. Option A is incorrect because a webhook trigger is event-based, not polling. Option B is incorrect because there is no 'scheduled' trigger type that polls a system.

Option D is incorrect because a manual trigger requires user input.

Practice this question →
161
MCQmedium

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?

A.Use a 'When an item is created' trigger on the SQL table.
B.Create an instant flow triggered by a Power Apps button for manual archiving.
C.Use a 'When a HTTP request is received' trigger from an external scheduler.
D.Use a SQL Server connector with a 'Recurrence' trigger to query and move data.
AnswerD

A recurrence trigger can run a SQL query to get completed orders and then create SharePoint list items.

Why this answer

Using a SQL Server connector with a recurrence trigger is the appropriate approach for querying a database on a schedule. Option A is event-driven and not scheduled. Option C is for approval, not data movement.

Option D is for real-time streaming, not batch processing.

Practice this question →
162
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

Option B is correct because the Microsoft Teams connector allows posting messages to channels. Option A is for Office 365, not Teams specifically. Option C is for Outlook, not Teams.

Option D is for SharePoint, not Teams.

Practice this question →
163
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 built-in actions for error handling. Option A is a scope action that can have run after settings. Option B is a configuration on actions.

Option C is a built-in action. Option D is not an action; it's an expression. Option E is a configuration on actions.

Practice this question →
164
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

Attachments must be included to parse the Excel file.

Why this answer

Option B is correct because the flow fails to include attachments, so it cannot parse the Excel file. Option A is wrong because the trigger is correct for a shared mailbox. Option C is wrong because the issue is not related to premium connectors.

Option D is wrong because license is not the issue.

Practice this question →
165
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

Option B is correct because the HTTP action likely fails when the request payload contains special characters or invalid data from the SharePoint list item; adding a 'Compose' action to sanitize the input before the HTTP call can resolve the 400 error. Option A is wrong because retry policy might mask the issue but not fix malformed requests. Option C is wrong because the endpoint is correct per the stem.

Option D is wrong because there's no indication of throttling.

Practice this question →
166
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

Option C is correct because adding pagination allows the flow to retrieve more rows per API call, reducing the number of requests and improving throughput. Option A is wrong because reducing the flow run frequency would only delay the issue, not fix timeout. Option B is wrong because increasing the timeout limit might mask the problem but doesn't address root cause.

Option D is wrong because using an on-premises gateway is irrelevant for cloud-to-cloud operations.

Practice this question →
167
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, parse the JSON to define the schema, then use 'Apply to each' to iterate over the array, and inside the loop use 'Insert row' to create SQL records. Option A is missing the parse step. Option C uses 'Filter array' which is for filtering, not iteration.

Option D is missing the loop.

Practice this question →
168
MCQhard

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?

A.The Office 365 Outlook connection is not configured.
B.The flow does not include an approval action; it only sends an email.
C.The trigger schema is empty, causing the flow to fail.
D.The email body is missing the approval response options.
AnswerB

The flow sends an email but does not include an approval action to wait for a response.

Why this answer

Option B is correct because the Send_approval_email action uses a manual trigger but there is no approval connector action to wait for response. Option A is not an issue; the connection is defined. Option C is not true; the manual trigger does not require a schema.

Option D is not the cause; the body is provided.

Practice this question →
169
MCQmedium

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?

A.The folder path is set to 'Inbox' but the email was moved to a different folder.
B.The trigger requires attachments, so emails without attachments are ignored.
C.The importance filter is set to 'High', so lower importance emails are ignored.
D.The trigger is set to 'When a new email arrives' but the email is already read.
AnswerC

Only high importance triggers.

Why this answer

Option D is correct because the trigger parameters include 'importance': 'High', so only emails with high importance trigger the flow. If the email has attachments but is not high importance, the flow will not trigger. Option A is wrong because the trigger is for new emails.

Option B is wrong because attachments are set to 'true', so they are required. Option C is wrong because the folder path is 'Inbox'.

Practice this question →
170
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

Option A is correct because the error 'Invalid template specification' indicates that the Planner task template is missing or incorrectly defined. Option B is wrong because the trigger is correct. Option C is wrong because the error is not about permissions.

Option D is wrong because the error is about the task template, not the connection.

Practice this question →
171
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

Option D is correct because the email might be sent to the flow owner's mailbox instead of the intended recipients if the 'To' field is configured incorrectly, or the recipients might have spam filters. Option A is wrong because flow suspension would stop execution, not cause missing emails. Option B is wrong because run history would show failure, not success.

Option C is wrong because the flow run time is irrelevant to delivery.

Practice this question →
172
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 →
173
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

Option A is correct because 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 →
174
MCQhard

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?

A.Use a 'When an item is created' trigger with a condition on Score > 50 and Status = 'New'. Use 'Send an email' to notify the manager and include a link to a Power Apps approval screen. Use a separate flow triggered by an HTTP request from Power Apps to update the item.
B.Use a 'When an item is created' trigger with a condition on Score > 50 and Status = 'New'. Inside the condition, use 'Start and wait for an approval' with a 7-day timeout. After approval, update item and send email. For reminders, create a separate scheduled flow that runs every 2 days, queries SharePoint for items with Status = 'New' and approval pending, and sends an email.
C.Use a 'When an item is created' trigger with a condition on Score > 50 and Status = 'New'. Inside the condition, use 'Start and wait for an approval' with a 7-day timeout. After approval, update the item and send email. Use 'Parallel branch' to send a reminder every 2 days by adding a 'Delay' action followed by an email.
D.Use a 'Recurrence' trigger that runs every hour, queries the SharePoint list for items with Status = 'New' and Score > 50, then sends an approval request. Use a 'Delay until' action to set a 7-day timeout. Use a 'Compose' action to track reminders.
AnswerB

This design separates the concerns: the main flow handles creation and approval with timeout, and the scheduled flow handles reminders.

Why this answer

Option B correctly uses a recurrence trigger to check for pending approvals and send reminders, and also uses the 'Start and wait for an approval' action which can have a timeout. Option A uses a trigger on item creation but does not handle the 7-day timeout or reminders. Option C uses a manual trigger which is not automated.

Option D uses an approval action without timeout and does not handle reminders.

Practice this question →
175
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

Option C is correct because the trigger fires when a new email arrives in the Inbox with 'Invoice' in the subject. Option A is wrong because 'fetchOnlyWithAttachment' is false. Option B is wrong because 'importance' is 'Any'.

Option D is wrong because the trigger fires on new email, not on email modification.

Practice this question →
176
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 3 of 3 · 176 questions total

Ready to test yourself?

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

Start 20-question session