Power Automate courseware and training manuals

We have the following courseware manual chapters on Power Automate Desktop.

You can see details of how to license our Power Automate courseware (including volume requirements) here.


Power Automate Desktop courseware

Here is a list of all of our Power Automate Desktop manual chapters (you can download the ones marked):

Chapter Sections Subsections
Getting Started (2 pages) What is Power Automate Desktop (PAD)?
Requirements for Using PAD
Flows (3 pages) Creating Flows
Working with Flows Running Flows ; Stopping a Flow
Editing, Copying, Renaming or Deleting Flows
Basic actions (17 pages) Our Example
Comments
Input Dialog Boxes
Variables Viewing the Variables Produced by an Action ; Turning Variable Capture Off ; Renaming Variables ; A Possible Variable Naming Convention ; Viewing your Variables ; Pinning Variables ; Filtering Variables ; Listing the Uses of a Variable
Launching Excel Opening an Excel Workbook ; Going to the Correct Worksheet ; Reviewing Progress to Date
Copying the Final Row Getting the Final Row Number ; Copying and Pasting
Clearing Copying (Sending Keys)
Writing in the New Data Converting the Date to Text ; Writing to Excel Cells
Closing the Workbook and Final Reporting Capturing the Final Information ; Saving and Closing the Workbook ; Displaying the Final Verdict
The Final Flow
Testing Conditions (4 pages) Our Example
Conditional Actions Testing Simple Conditions ; Testing between Two Alternatives ; Testing between Multiple Alternatives (Nesting) ; Testing between Multiple Conditions (Else if)
Using Switch and Case
Subflows (3 pages) The Need for Subflows
Creating Subflows Adding a New Subflow ; Moving Actions to Subflows
Calling Subflows
Debugging (6 pages) Basic Debugging
Using a Debug Variable Setting Debug (or Other) Variables ; Adding the Condition ; Setting the Default Date to Today
Pausing Programs Setting Breakpoints ; Pausing a Program
Other Debugging Techniques Inspecting Variable Values ; Starting Execution in Mid-Flow ; Disabling Actions
Calling Flows (6 pages)

Download this chapter
Our Example
The Output Variable Flow Creating an Output Variable ; Filling the Output Variable ; The Output Variable Flow
The Input Variable Flow Creating the Input Variable ; The Limitation of String Variables ; Splitting the String back into a List ; The Input Variable Flow
The Master Flow
Errors (Avoiding) (3 pages) Reacting to Message Boxes The Problem ; The Solution ; Testing Buttons ; Cancelling Flows
Checking Files or Folders Exist
Errors (Trapping) (5 pages) Error Handling for Individual Actions Our Error-Handling Flow ; Starting to Configure the Error-Handler ; Setting the Error Flag ; Setting the Next Action
Error Blocks Step 1: Adding an Error Block ; Step 2: Configuring the Error Block ; Step 3: Writing an Error-Handling Subflow
Loops (6 pages) Introducing Loops The Three Types of Loop ; Breaking Out of a Loop
Looping N Times Our Example ; The Loop Action ; Exiting a Loop Prematurely
Looping While a Condition is True
Looping over Items Our Example ; Getting a Collection of Things ; Adding the Loop ; Action within the Loop
Lists (5 pages) Single Lists The Possible List Actions ; A Typical List Flow ; Viewing Lists ; Referring to List Items ; Looping over Lists ; Removing Duplicate Items
Working with Multiple Lists
Linking to SQL Server (4 pages) Connecting to SQL Server Our Table Example ; The SQL Server Actions Available ; Creating a Connection ; Executing a SQL Statement ; Closing your Connection
Calling a Stored Procedure
DataTables and DataRows (4 pages) Data Tables Data Rows
Working with Data Rows Viewing Data Rows ; Referring to Individual Rows ; Looping Over Data Rows ; Referring to Individual Fields
Collapsing a Data Table Column to a List
CSV Files (2 pages) Reading CSV Files Our Example ; The Read from CSV File Action ; Configuring Reading from CSV Files ; Looping Over the Rows Returned
Working with Excel (6 pages) Reading Simple Excel Tables Summary of Flow ; The Individual Actions
Reading Selected Excel Data Advanced Excel Actions ; The Flow Explained
Running VBA Macros
Moving Around a Worksheet
Files and Folders (5 pages) Looping Over Files Getting a List of Files or Folders ; Looping Over a List of Files Obtained
File Properties Viewing Files ; Listing File Properties
Renaming Files Renaming a Set of Files ; Renaming Files Individually within a Loop
Utilities (3 pages) The Clipboard
Capturing Screens
Logging Off and Shutting Down
Email (6 pages) Email Options in PAD
Sending/Receiving using SMTP
Using Outlook Finding your Outlook Account ; Launching and Closing Outlook ; Downloading All Attachments ; Reading All Emails ; Email Properties
Reading PDFs (3 pages) Managing your Expectations
Reading from PDFs Reading in Text ; Reading in Images ; Reading Tables of Data
Basic Web Browsing (12 pages) About Web Browsing Some Warnings
Installing Browser Extensions Using Edge ; Using Chrome or Firefox
Opening and Closing Browsers
Filling in a Form Going to a Text Field ; Populating the Text Field ; Pressing the Button
Extracting Single Items of Data Step 1 – Adding the Action ; Step 2 – Doing the Easy Bits ; Step 3 – Choosing the UI Element ; Step 4 – Solving Problems
Extracting Tables of Data Adding the Data Extraction Action ; Configuring Data Extraction
Page Properties The Available Properties ; Parsing a Web Page’s Readable Text
UI Elements (10 pages) Understanding HTML The Document Object Model (DOM) ; HTML Tags ; Tag Attributes ; Classes and Ids
Working with UI Elements Viewing the UI Elements Pane ; Removing Unused Elements ; Adding an Element ; Renaming Elements ; Keeping an Eye on Pages ; Viewing and Editing Elements
Selector Builders Viewing Individual Selectors ; JQuery ; Removing Selectors
The Practical Implications Viewing Source HTML to Check
Images (6 pages)

Download this chapter
Example of Use Reasons Not to Use Images
Working with Images Adding Images ; Adding Folders ; Removing Unused Images
Using Images Step 1 – Start your Browser ; Step 2 - Add a Move Mouse to Image Action ; Step 3 – Choose an Image ; Step 4 – Customising Image Matching
Trouble-Shooting Considering Screen Resolution
UI Automation (7 pages) Examples of UI Systems
Our Example
Starting Applications Finding an Executable Path ; Running an Application
Working with UI Elements
Creating the Flow Going to the Server Name Text Box ; Typing in the Server Name ; Clicking on the Connect Button ; Expanding Nodes ; Creating a Query
Recording Actions (4 pages) Recording a Flow
Limitations of Recording
Recording Recording Actions ; Adding Comments ; Pausing Recording
Case Study - Backups (8 pages) Attacking The Problem Choosing the Input Medium ; Creating an Algorithm
Design Choices
The Individual Subflows Explained Initial Checks ; Initialising our Variables ; Getting the Files and Folders ; Initialising Logging ; Logging ; Processing the Files and Folders ; The Final Message
Case Study - Emailing Files (5 pages) The Problem
A Suggested Algorithm and Main Flow
The Subflows Called Creating a List of Recipients ; Starting Outlook ; Adding Attachments to Recipients ; Sending Files to each Person
Case Study - SEO Results (6 pages) Purpose of Flow
The Flows Involved The Main Flow ; Time-Stamping the Results ; Getting the List of Search Phrases ; Getting the Search Position for each Phrase
Possible Improvements Searching beyond the First Page ; Getting the Correct Position Number

Notes:

  1. Since Wise Owl print courseware double-sided to save trees, the number of physical pages in each chapter is roughly half of the number of sides quoted.
  2. Downloads are provided as examples only, and should not be used or distributed in any way or form without the prior written permission of Wise Owl.
This page has 0 threads Add post