Microsoft Power Automate RPA Developer MPAD001
- Course Code : MPAD001
- Duration : 4 Day
- Price : 2,475 GBP
- Level: Intermediate
- Language: English
Course Content
Candidates for the Microsoft Power Automate RPA Developer (PL-500) course automate repetitive tasks using Microsoft Power Automate. They review solution requirements, create process documentation, and design, develop, troubleshoot, and evaluate solutions. Candidates work with business stakeholders to improve and automate workflows, collaborating with administrators to deploy and support solutions in production environments.
Delivery Method
In-Person
Online
Have questions about this course?
Goals
Design RPA solutions
Develop RPA solutions
Deploy and manage RPA solutions
Prerequisites
Experience with JSON, cloud flows, Azure services, and integrating solutions with REST and SOAP services.
Familiarity with analyzing data using Microsoft Excel, VBScript, Visual Basic for Applications (VBA), HTML, and JavaScript.
Knowledge of one or more programming languages.
Background with the Microsoft Power Platform suite of tools (AI Builder, Power Apps, Dataverse, Power Virtual Agents).
Course Outline
Module 1 - Module 15
Module 1: Take your first steps with Power Automate for desktop
Explore the console and flow designer.
Use core features of Power Automate for desktop.
Create and run a flow.
Module 2: Power Automate for desktop development essentials
Create a flow from scratch.
Use actions and variables.
Understand testing and debugging features.
Configure error-handling properties.
Use UI elements and images.
Use subflows to compartmentalize and reuse parts of a flow.
Module 3: Build your first Power Automate for desktop flow
Create a new desktop flow.
Record actions in a desktop application.
Perform a test run of the new desktop flow.
Module 4: Define input and output parameters in Power Automate
Create a desktop flow with predefined inputs.
Record actions in an invoicing application using predefined inputs.
Perform a test run with a new set of inputs.
Module 5: Integrate desktop flows with Outlook connector in Power Automate for desktop
Create a new solution for invoicing.
Create a cloud flow that starts with an email.
Integrate a desktop flow into a cloud flow.
Test the new cloud flow.
Module 6: Connect a cloud flow to desktop flows in Power Automate for desktop
Install Power Automate for desktop and create flows.
Set up an on-premises data gateway.
Add the desktop flow to the cloud flow.
Test the desktop and cloud flows.
Module 7: Use AI Builder to process invoice forms in Power Automate
Build an AI model for form processing.
Train the AI model with invoice forms.
Integrate the AI model into a cloud flow.
Test the cloud flow and AI model predictions.
Module 8: Use the Teams connector in Power Automate
Integrate a Teams-based approval model into a cloud flow.
Integrate the desktop flow into the approval process.
Integrate Outlook notifications into the invoice process.
Test the end-to-end invoice process.
Module 9: Run a Power Automate for desktop flow in unattended mode
Run a desktop flow in unattended mode.
Run a desktop and cloud flow scenario in unattended mode.
Learn best practices for unattended flows.
Module 10: Optimize your business process with a process advisor
Create a recording of a business process.
Edit and group actions in the recording.
Analyze the recording to improve the process.
Module 11: Handle variables in Power Automate for desktop
Create, edit, and manipulate variables.
Understand variable data types and properties.
Configure input and output variables.
Module 12: Automate repetitive tasks using loops in Power Automate for desktop
Use loops to perform repetitive tasks.
Deploy loop conditions.
Iterate through list items.
End loops when required.
Module 13: Adjust process behavior using conditional actions with Power Automate for desktop
Use “If” conditionals.
Deploy “Switch” conditionals.
Provide default and alternative behaviors based on conditions.
Module 14: Configure flow control in Power Automate for desktop
Learn flow control concepts.
Use flow control actions to direct and manipulate the flow.
Module 15: Generate Power Automate for desktop flows by recording
Use the recorder to automate tasks.
Automate interactions with a web browser.
Edit recorded actions.
Module 16 - Module 33
Module 16: Configure exception and error handling in Power Automate for desktop
Exception handling allows Power Automate for desktop to manage unexpected issues during a flow run.
Configure exception-handling properties for individual actions.
Module 17: Control file and folder handling in Power Automate for desktop
Managing files and folders is essential in business processes.
Create flows to manage files and folders.
Manage properties of multiple files and folders.
Module 18: Web automation in Power Automate for desktop
Web applications are crucial for most organizations.
Configure browser automation actions.
Extract data from web pages.
Create a flow to extract gainer stocks from the MSN website.
Module 19: Use Power Automate for desktop to interact with Windows and applications
UI interfaces are identified through UI elements.
Learn about UI elements.
Discover window and element-handling capabilities.
Module 20: Excel automation in Power Automate for desktop
Power Automate for Desktop offers numerous Excel actions.
Open Excel files and attach processes to them.
Read and write data to Excel files.
Create, edit, save, and close Excel files.
Module 21: Automating email handling in Power Automate for desktop
Email services are vital for business procedures.
Familiarize with email, Outlook, and Exchange actions.
Create flows to retrieve, process, and send emails.
Module 22: Automate system, workstation, and services actions in Power Automate for desktop
Automate tasks fundamental to Windows OS.
Use system and workstation groups of actions.
Manage Windows services with service actions.
Module 23: Communicate using message boxes in Power Automate for desktop flows
Message boxes interact with users for input or output.
Familiarize with various preset message box actions.
Module 24: Text manipulation in Power Automate for desktop
Manipulate text and datetime values.
Use text and datetime actions for standardized data formats.
Process and edit text in flows.
Module 25: Simulate mouse and keyboard actions using Power Automate for desktop
Create flows simulating mouse and keyboard actions.
Automate mouse movement, clicks, and key presses.
Select and locate screen images with the mouse.
Module 26: Combine Power Automate desktop and cloud flows
Combine desktop and cloud flows.
Call a desktop flow from a cloud flow.
Use variable values between desktop and cloud flows.
Module 27: Database handling in Power Automate for desktop
Automate database handling with database actions.
Compose a connection string.
Run queries on a database.
Module 28: Microsoft Entra handling in Power Automate for desktop
Manage network permissions with Microsoft Entra actions.
Connect to an Microsoft Entra server.
Manage users, groups, and objects.
Module 29: Scripting in Power Automate for desktop
Automate complex scenarios using scripts.
Use VBScript, JavaScript, PowerShell, and Python.
Create flows with scripting actions.
Module 30: OCR technologies in Power Automate for desktop
Read, extract, and manage data with OCR actions.
Configure OCR actions.
Extract text from images using OCR.
Module 31: Get started with custom connectors in Microsoft Power Platform
Custom connectors ease connecting to cloud apps, data, and devices.
Configure and use custom connectors.
Build and use a connector in a Power Automate flow.
Module 32: Configure custom connectors with authenticated APIs in Microsoft Power Platform
Access custom or third-party APIs.
Learn authentication options.
Use APIs with Microsoft Entra.
Use a graph API from a custom connector.
Share and move between environments.
Module 33: Introduction to Microsoft Power Platform security and governance
Secure and govern Power Automate and Power Apps.
Use Power Platform environments to create DLP policies.
Access admin experiences and COE toolkit.
Identify Business and No-business data groups.
