Candidates for this course automate time-consuming and repetitive tasks by 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 business workflows. They
collaborate with administrators to deploy solutions to production environments, and
they support solutions.
Course dates and course fee may be subjected to changes.
Course Outline
Lesson 1: Take your first steps with Power Automate for desktop
- Introduction to Power Automate for desktop
- Console overview
- Flow designer overview
- Create a simple flow
- Exercise – Create and run a simple flow
Lesson 2: Power Automate for desktop development essentials
- Introducing to Power Automate for desktop development
- Create a flow in the flow designer
- Create conditionals and loops
- Using subflows
- Test and debug flows
- Manage UI elements and images
- Deploy exception handling
Lesson 3: Build your first Power Automate for desktop flowÂ
- Set up the environment
- Explore Power Automate for desktop
- Create your first Power Automate for desktop flow
- Record Power Automate for desktop actions
- Edit and test recorded actions
Lesson 4: Define input and output parameters in Power AutomateÂ
- Set up in Power Automate
- Define an input variable
- Set input variables
- Define output variables
- Add UI elements and test
Lesson 5: Integrate desktop flows with Outlook connector in Power Automate for desktop
- Setup process in Power Automate
- Build a cloud flow that’s triggered in Outlook
- Test your new flow
Lesson 6: Connect a cloud flow to desktop flows in Power Automate for desktop
- Setup in Power Automate for desktop
- Create a new cloud flow
- Connect your cloud and desktop flows
- Test your new connection
Lesson 7: Use AI Builder to process invoice forms in Power Automate
- Solution setup in Power Automate
- Create a form processing flow
- Add fields and collections of documents
- Analyze and train a model
- Integrate the model into a cloud flow
Lesson 8: Use the Teams connector in Power AutomateÂ
- Work from an existing solution in Power Automate
- Create an approval solution
- Integrate with an existing desktop flow
- Build communication with Outlook
- Test and run a flow
Lesson 9: Run a Power Automate for desktop flow in unattended mode
- Set up an unattended desktop flow
- Create a new cloud flow that calls an existing flow in unattended mode
- Perform a test run
- Best practices
Lesson 10: Optimize your business process with process advisor
- Get familiar with process advisor
- Create your first recording
- Edit recordings and group actions
- Analyze recordings an interpret results
- Automation recommendations
Lesson 11: Handle variables in Power Automate for desktop
- Introducing variables
- Create, edit, and use variables
- Variable data types
- Advanced data types
- Input and output variables
- Variable manipulation
- Sensitive variables
- Exercise – Create, access and manipulate variables
Lesson 12: Automate repetitive tasks using loops in Power Automate for desktop
- Introduction to loops
- Loop actions
- Simple loop actions
- For each loop actions
- Loop condition actions
- Exercise – Loops
Lesson 13: Adjust process behavior using conditional actions with Power Automate for desktop
- Introduction to conditional actions
- Conditional actions
- The If group of actions
- The Switch group of actions
Lesson 14: Configure flow control in Power Automate for desktop
- Introduction
- Flow control actions
Lesson 15: Generate Power Automate for desktop flows by recording
- Introduction to the Power Automate for desktop recorder
- Create desktop flows using the recorder
- Exercise – Use the recorder to automate web applications
- Exercise – Use the recorder to automate desktop applications
Lesson 16: Configure exception and error handling in Power Automate for desktop
- Introduction
- About exceptions
- Exception handling
- Exercise – Exception handling
Lesson 17: Control file and folder handling in Power Automate for desktop
- Introduction
- Folder actions
- File actions
- Exercise – Create a backup copy of the desktop folder
Lesson 18: Web automation in Power Automate for desktop
- Introducing web automation
- Launch, close, and handle browsers
- Handle web pages and forms
- Extract data from web pages
- Direct web access and scripting
- Exercise – Extract stocks from MSN
Lesson 19: Use Power Automate for desktop to interact with windows and applications
- Introduction
- UI elements
- Window handling and element interaction
Lesson 20: Excel automation in Power Automate for desktop
- Introduction
- Launch, save, and close an Excel file
- Read from an Excel document
- Write to an Excel worksheet
- Additional actions and features
- Manage worksheets
- Exercise – Organize data in a spreadsheet
Lesson 21: Automating email handling in Power Automate for desktop
- Introducing email automation
- Automate webmail services
- Automate Outlook
- Automate Exchange servers
- Exercise – Confirm the submission of support tickets
Lesson 22: Automate system, workstation and services actions in Power Automate for desktop
- Introduction
- System and workstation actions
- Services actions
Lesson 23: Communicate using message boxes in Power Automate for desktop flows
- Introduction to message boxes
- Message box actions
- Exercise – Use message boxes to communicate
Lesson 24: Text manipulation in Power Automate for desktop
- Introduction
- Text handling actions
- Date time actions
- Exercise – Text actions
Lesson 25: Simulate mouse and keyboard actions by using Power Automate for desktop
- Introduction
- Mouse and keyboard actions
- Exercise – Simulate mouse and keyboard actions
Lesson 26: Combine Power Automate desktop and cloud flows
- Introduction to running Power Automate desktop flows from cloud flows
- Run a Power Automate desktop flow from a cloud flow
- Exercise – Create a cloud flow that calls a Power Automate desktop flow
Lesson 27: Database handling in Power Automate for desktop
- Introduction
- Database actions
Lesson 28: Active Directory handling in Power Automate for desktop
- Introduction
- Active Directory actions
- Exercise – Create a new Active Directory user
Lesson 29: Scripting in Power Automate for desktop
- Introduction
- Scripting actions
- Exercise – Calculate modulo with VBScript
- Exercise – Use Java Script to find the last day of the current month
Lesson 30: OCR technologies in Power Automate for desktop
- Introducing OCR technologies
- OCR actions
- Exercise – Extract data from images
Lesson 31: Get started with custom connectors in Power Automate
- Introduction
- Demo of the maker portal experience
- Explore custom connector configuration options
- Exercise – Create a new connector in a solution
- Use a custom connector
- Exercise – Use a connector from Power Automate
Lesson 32: Configure custom connectors with authenticated APIs in Power Automate
- Introduction
- Authentication options
- Use APIs with Azure AD
- Configure Azure Active Directory authentication
- Use graph API from custom connector
- Share and move between environments
Lesson 33: Introduction to Microsoft Power Platform security and governance
- Introduction
- Identify Microsoft Power Platform environments
- Data Loss Prevention policies
- Microsoft Power Platform Center of Excellence Starter Kit
- Exercise – Create a Power Platform environment