Updated Study Guide for Microsoft Power Automate RPA Developer PL-500 Exam – Use PL-500 Dumps V9.02 to Start Learning

1. The AP team monitors the shared mailbox to confirm that the customer has paid the invoice.

Requirements

Functional requirements

• Large volume orders must be processed before other orders.

• Invoices must be cross-checked with received items against packing slip for shipments.

• The finance team must be able to analyze patterns in transactional data to conduct fraud prevention activities.

• You must automate the process of entering data about incoming orders into SMSApp.

• The solution must follow the principle of least privilege.

Purchase Order Quantity flow

• You must create an unmanaged solution to update purchase order details in SMSApp. The flow must use a manual trigger.

• Members of Accounts Payable team will be testers for the solution. They must be able to access

the Purchase Order Quantity flow.

Flow for processing invoice data

• You must create a flow to monitor the AP mailbox. When an invoice arrives as an attachment in the inbox, the flow must automatically process the invoice data by using a form processing model. The flow must cross-check the received items against the packing slip.

• You must use different Accounts Payable email addresses for development user acceptance testing (UAT), and production environments.

• You must use an environment variable to represent the Accounts Payable mailbox for the environment in use.

• You must be able to use the environment variable across multiple cloud flows, a custom connector, and a canvas app.

Technical requirements

• Users must only be allowed to connect to and access systems that are required for the employee to perform required job tasks.

• All automation flows must be either co-owned or shared between staff.

• All employees must be able to access the new environment to build personal productivity automations.

• You must distribute the workload for desktop flows to optimize productivity.

Monitor flows

• All data extracted from Invoices should be stored in a custom Dataverse entity. Only employees who are part of Finance role should be able to edit all Invoice data but must be prevented from creating or deleting one.

Issues

Invoice data

All users report that they can see and modify invoice data.

New environment

•The IT department creates a new environment. A user creates a cloud flow named FlowA in the environment that triggers a desktop flow. A user reports that the cloud flow does not trigger the desktop flow to run.

• Microsoft Dataverse is not provisioned in the new environment. You attempt to create a Desktop flow in the default environment but receive a Dataverse error message and cannot proceed.

Data entry automation flow

An administrator runs a new desktop flow in the development environment to automate data entry into SMSApp. The flow automatically reverts to a suspended state.

Order fulfillment flow

You must automate the customer communication process by using an unattended desktop flow. The flow must check the fulfillment status of each active order in SMSApp. If an order is fulfilled, the flow must send the customer an email that includes tracking information for their order.

You need to identify the cause for the SMSApp data entry issue.

What is the root cause?

2. You need to configure the flow for processing invoices that arrive in the AP mailbox.

Which three elements should you use? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

3. You need to implement security to resolve the invoice data issue

Which three actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

4. HOTSPOT

You need to configure the solution.

What should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

5. You need to resolve the fulfillment status flow issue.

Which three actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

6. HOTSPOT

You need to determine the causes for the reported issues.

What are the causes? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

7. You need to configure permissions for the Purchase order quantity flow.

Which permission should you assign?

8. You need to ensure that the solution uses the correct accounts payable mailbox.

Which three actions should you perform? Each correct answer part of the solution, NOTE: Each correct selection is worth one point.

9. DRAG DROP

You need to implement a solution to manage the priority of incoming orders.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

10. Topic 2, City Power and Light

Background

City Power and Light is one of the biggest energy companies in North America. They extract, produce and transport oil. The company has more than 50 offices and 100 oil extraction facilities throughout the United States, Canada, and Mexico. They use railways, trucks, and pipelines to move oil and gas from their facilities.

The company provides the following services:

• Produce oil from oil sands safely, responsibly, and reliably

• Refine crude oil into high-quality products

• Develop and manage wind power facilities.

• Transport oil to different countries/regions.

City Power and Light uses various Microsoft software products to manage its daily activities and run its machine-critical applications.

Requirements

ManagePipelineMaintenanceTasks

A user named Admin1 creates a cloud flow named ManagePipelineMaintenanceTasks. Admin1 applies a data loss prevention (DLP) policy to the flow. Adminlshares the flow with a user named PipelineManager1 as co-owner. You must determine the actions that PipelineManager can perform.

MaintenanceScheduler

You create a cloud flow that uses a desktop flow. The desktop flow connects to third-party services to fetch information. You must not permit the desktop flow to run for more than 20 minutes.

You must configure sharing for MatinenanceScheduler to meet the following requirements:

• User1 must be able to work with you to modify the desktop flow.

• User2 must be able to access and review the run history for the flow.

• You must grant User3 permissions to run but not modify the desktop flow.

ERPDataOperations flow

City Power and light uses an enterprise resource planning (ERP) system. The ERP system does not have an API.

Each day the company receives an email that contains an attachment. The attachment lists orders from the company's rail transportation partners. You must create an automation solution that reads the contents of the email and writes records to the ERP system. The solution must pass credentials from a cloud flow to a desktop flow.

RailStatusUpdater

City Power and Light actively monitors all products in transit. You must create a flow named

RailStatusUpdater that manages communications with railways that transport the company's products. RailStatusUpdater includes five desktop flow actions.

You must run the desktop flows in attended mode during testing. You must run the desktop flows in unattended mode after you deploy the solution. You must minimize administrative efforts.

Packaging

You must package the automations in a solution. All required components must be included in the solution.

Issues

ProductionMonitor flow

You create a cloud flow named ProductionMonitor which uses the Manually trigger a flow trigger.

You plan to trigger ProductionMonitor from a cloud flow named ProdManager.

You add a Run a Child flow action in ProdManager to trigger ProductionMonitor.

When you attempt to save ProdManager the following error messaqe displays:

CapacityPlanning flow

Developers within the company use cloud flows to access data from an on-premises capacity planning system.

You observe significant increases to the volume of traffic that the on-premises data gateway processes each day. You must minimize gateway failures.

DataCollector flow

You have a desktop flow that interacts with a web form. The flow must write data to several fields on the form.

You are testing the flow. The flow fails when attempting to write data to any field on the web form.

RailStatusUpdater flow

The RailStatusUpdater flow occasionally fails due to machine connection errors. You can usually get the desktop flow to complete by resubmitting the cloud flow run. You must automate the retry process to ensure that you do not need to manually resubmit the cloud flow when machine connection errors occur.

HOTSPOT

You need to configure the solution for the ERPDataOperations flow.

Which configuration values should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

11. You need to configure the RailStatusUpdater cloud flow.

What should you do?

12. You need to identify the actions that PipelineManager1 can perform.

Which three actions can PipelineManager1 perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

13. You need to configure the desktop action for the MaintenanceScheduler cloud flow.

Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

14. You need to address the issue with the capacity planning flow.

What should you do?

15. HOTSPOT

You need to configure sharing for MaintenanceScheduler.

Which sharing methods should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

16. HOTSPOT

You need to troubleshoot the issue saving ProdManager.

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

17. You need to resolve the issue reported with the RailStatusUpdater flow.

What are two possible ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

18. You need to package the automations.

What should you do?

19. You need to resolve the issue with the DataCollector flow.

What are two possible ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point

20. Topic 3, Woodgrove Bank

Overview

Woodgrove Bank is a large, member-owned bank in the United States Woodgrove Bank provides financial products with low customer fees and direct customer service.

Woodgrove Bank has 177 branches across the United States with 5,000 branch staff and supervisors serving over 750.000 members The primary languages used by most members include English and Spanish when interacting with customer service representatives. The Woodgrove Bank headquarters is in California and has 450 office workers. The office workers include financial advisors, customer service representatives, finance clerks, and IT personnel.

Bank applications

• An application named Banker Desktop. The branch employees use this desktop app to review business transactions and to perform core banking updates.

• An application named Member Management System. This application is a custom customer relationship management (CRM) that integrates with other systems by using an API interface.

• An application named Fraud Finder. This application is a mission-critical, fraud management application that runs on the employees' desktops. The bank has experienced challenges integrating the application with other systems and is expensive to support,

• SharePoint Online provides an employee intranet as well as a member document management system that includes polices, contracts, statements, and financial planning documents.

• Microsoft Excel is used to perform calculations and run macros. Branch employees may have multiple Microsoft Excel workbooks open on their desktop simultaneously.

Bank devices

• All supervisors are provided with a mobile device that can be used to access company email and respond to approval requests.

• All branch employees and supervisors are provided with a Windows workstation.

New member environment

Woodgrove Bank requires new members to sign up online to start the onboarding process. The bank requires some manual steps to be performed during the onboarding process.

First step:

• Members complete an online Woodgrove Bank document and email the PDF attachment to the

bank's shared mailbox for processing.

Second step:

• Members are asked to provide secondary identification to their local branch, such as a utility bill, to validate their physical address.

• Branch staff scan the secondary identification in English or Spanish using optical character recognition (OCR) technology.

Third step:

• A branch supervisor approves the members’ application from their mobile device.

• Only supervisors are authorized to complete application approvals. Fourth step:

• Data that is received from applications must be validated to ensure it adheres to the bank's naming standards.

The bank has the following requirements for the members’ data:

• New members must be enrolled by using the document automation solution New members must be enrolled by using the document automation.

• Member data is subject to regulatory requirements and should not be used for non-business purposes.

• A desktop workflow is required to retrieve member information from the Member Management System on-demand or by using a cloud flow.

Bank fees

The process for calculating bank fees include:

• using a shared Excel fee workbook with an embedded macro, and

• an attended desktop flow that is required to automate the fee workbook process. The flow should open an Excel workbook and calculate the members’ fees based on the number of products.

Fraud detection

The bank has the following requirements to minimize fraud:

• Branch employees must use the Fraud Finder application during onboarding to validate a member's identity with other third-party systems.

• Branch employees must be able to search for a member in the Fraud Finder application by using a member's full name or physical address.

• If fraudulent activity is identified, a notification with member details must be sent to the internal fraud investigation team.

Technical

The bank has the following technical requirements:

Flows

• The Fraud Finder application uses a custom connector with Power Automate to run fraud checks

• The application approval process triggers a cloud flow, then starts an attended desktop flow on the branch employee's workstation and completes the approval.

• The banker desktop flow runs using the default priority.

• An IT administrator is the co-owner of The banker desktop flow.

• The IT department will be installing the required OCR language packs.

• The Extract text with OCR action is used to import the members’ secondary identification

Member Management System

• A secure Azure function requires a subscription key to retrieve members’ information.

• Production flows must connect to the Member Management System with a custom connector. The connector uses the Azure function to perform programmatic retrievals, creates, and updates.

• The host URL has been added to the custom connector as a new pattern.

• A tenant-level Microsoft Power Platform data loss prevention (DIP) policy has been created to manage the production environment

• A developer creates a desktop flow to automate data entry into a test instance of the Member Management System.

• A developer creates an on-demand, attended desktop flow to connect to a data validation site and retrieve the most current information for a member.

Banker desktop application

• A banker desktop flow is required to update the core banking system with other systems.

• When a transaction is complete, the branch employee submits the request by using a submit button.

• After submitting the request, an instant cloud flow calls an unattended desktop flow to complete the core banking update.

• The banker desktop flow must be prioritized for all future transactions.

Deployment & testing

• Development data must be confined to the development environment until the data is ready 1 for user acceptance testing (UAT).

• The production environment in SharePoint Online must connect to the development instance of the Member Management System.

• Developers must be able to deploy software ever/ two weeks during a scheduled maintenance window.

• The banker desktop flow must continue to run during any planned maintenance.

• The fraud custom connector requires a policy operation named EscalateForFraud with a parameter that uses the members' full name in the request.

Scalability

• The bank requires a machine group to distribute the automation workload and to optimize productivity.

• The IT administrator needs to silently register 20 new machines to Power Automate and then add them to the machine group.

Security

• The IT administrator uses a service principal account for machine connection.

• The IT administrator has the Desktop Flow Machine Owner role.

Issues

A branch staff member reports the document automation solution is not processing new members' data and emails are not being sent for approvals.

An IT administrator reports that the banker desktop flow has become unresponsive from data that is queued in another flow.

You need to install Windows updates on the desktop flow machines.

What should you do?

21. You need to resolve the document processing issue.

Which two components should you verify? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

22. You need to create the custom connector that will be used to retrieve member information.

Which authentication option should you use?

23. DRAG DROP

You need to create the desktop flow to calculate a member's fees.

Which four steps should you perform in sequence? To answer, move the appropriate steps from the list of steps to the answer area and arrange them in the correct order.

24. You need to set up a policy for the developer to perform desktop flow testing.

Which two actions should you do? Each correct answer presents a part of the solution. NOTE: Each correct selection is worth one point.

25. HOTSPOT

You need to identify which automation technology to use for the application approval process.

What should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

26. You need to resolve the banker desktop flow issue

Which two actions should you do? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

27. HOTSPOT

You need to identify the values or the behavior for the pattern added to the tenant Microsoft Power Platform data loss prevention (DIP) policy.

What should you identify? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

28. DRAG DROP

You need to configure the machine deployment for the IT administrator.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

29. HOTSPOT

You need to implement the scripting action for the Member Management System flow.

What should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point

30. DRAG DROP

You need to add a policy to the Fraud custom connector.

Which five actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

31. You need to choose the two optical character recognition (OCR) engines that are able to extract text from the members' secondary identification.

Which two OCR technologies achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

32. Topic 4, Mix Questions

You create an unattended Office 365 automation. The automation stops running.

You suspect that the runtime identity used by the automation caused the automation to stop running.

Which two issues can the runtime identity cause in this scenario? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

33. HOTSPOT

A company has a customer relationship management (CRM) app installed on a machine.

Each month an employee signs into the machine by using their Azure Active Directory (Azure AD) account to generate a financial statement for each account in a list of accounts. The list of accounts is stored in Microsoft Dataverse. The employee must send each customer their statements by using Office 365 Outlook.

You need to develop a solution to automate the task.

Which components should you use? To answer, select the appropriate options in the answer area.

34. HOTSPOT

You create an environment for a company. You need to configure security to meet the company's requirements and follow the principle of least privilege.

Which security roles should you assign? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

35. DRAG DROP

You are editing a cloud flow in the Power Automate flow designer.

You need to resubmit the most recent trigger.

Which five actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

36. You are creating automation solutions for a company. You create a cloud flow that includes a Scope action.

What is the purpose of the Scope action?

37. HOTSPOT

You create the following flow:

Use the drop-down menus to select the answer choice that answers each question based on the information presented in the graphic. NOTE: Each correct selection is worth one point.

38. You develop a desktop flow.

You need to debug the flow.

Which three tools can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

39. You are developing a desktop flow that reads data from a table in a Microsoft Excel workbook. You need to read the cell in the fourth row and first column of the table.

Which two expressions can you use? Each correct answer presents a complete solution. NOTE: Each correct answer is worth one point.

40. You develop a desktop flow. The flow performs five actions in sequence.

If an error occurs, you must restart the flow from the first action. You add the five actions to an On block error action.

You need to configure error handling.

Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

41. DRAG DROP

You create a Microsoft Power Platform solution. You create variables to define input values for the flow. You export the solution as managed and import the solution into a user acceptance testing (UAT) environment.

The flow in the UAT environment is still using the values from the development (DEV) environment.

You need to resolve the issue.

Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

42. You must create new flows within a solution and import existing flows into the solution. You need to configure the solution.

Which three actions can you perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

43. You have a flow that interacts with different SharePoint sites. You add the flow to a solution.

You redeploy the solution to production each time you make a change to the flow. You do not want to change the SharePoint site URL every time you redeploy the solution.

You need to configure the solution.

Which solution component should you use?

44. DRAG DROP

You plan to create a Microsoft Visio process diagram.

You need to create the diagram and then export the diagram as a Power Automate flow.

Which five actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

45. HOTSPOT

You create the following flow:

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

46. DRAG DROP

A company has a customer relationship management (CRM) application that runs on a virtual machine (VM) in Azure.

The solution must automatically extract common invoice data from documents sent as email attachments and save the data to the company's CRM application.

You need to design the solution.

In which order should you perform the actions? To answer, move all actions from the list of actions to the answer area and arrange them in the correct order.

47. You have an automation solution that uses a desktop flow. The flow reads data from a file that is stored on a user's machine and writes the data to an application. You import the solution to an environment that is connected to another user's machine.

The user reports that the flow fails. An alert indicates that the path to a file does not exist. You confirm that the file is present on the user's desktop. You need to resolve the issue.

What should you do?

48. HOTSPOT

You are creating a custo A company uses activity logging to measure performance for invoice processing.

Users report that the data analytics department takes too long to manually analyze data. The company requires an automatic process to speed up activity log analysis and provide insights.

You need to select the Microsoft Power Platform feature to meet the company requirement.

Which feature should you select?

49. HOTSPOT

You are creating an automation for a company. When a new record is created in a Microsoft Dataverse table, the automation must add the same data to an enterprise resource planning (ERP) system. The ERP system does not have an API.

You need to create the automation solution.

What should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

50. A company uses Microsoft 365 apps. You are building a flow that is triggered when a new email arrives.

If an email message contains a Microsoft Excel workbook attachment the solution must post the Excel data to an external customer relationship management (CRM) system that runs on a user's workstation. The CRM system is not accessible by using an API.

You need to design the solution.

Which three actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.