Browse 540 attributed reviews, viewable separately for our classroom and online training
Introducing Power Automate Desktop
Power Automate Desktop allows you to automate any common sequence of tasks that you perform in Windows, and has the potential to change your working life. So what is it?

Posted by Andy Brown on 18 November 2021

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Introducing Power Automate Desktop

Whatever you do in Windows, Power Automate can make your job easier - and not many programs can claim that!  In this blog I'll explain the idea behind Power Automate, but you might also like to read this example of its practical use to give an insight into its power.

Bear with me as I take a digression into how Excel works: it is relevant, honestly!

Automating things in Excel

Anything you can do in Excel can be automated in a language called VBA (Visual Basic for Applications).  For example, suppose you type Wise Owl in to cell A1:

Typing into cell A1

If you have macro recording on when you do this, you'll be able to look at the VBA command generated.

 

The VBA command to do this is Range("A1").Select.  The fact that every Excel action has an equivalent VBA command means that you can automate any repetitive task in Excel (or Word, PowerPoint, Outlook or Access for that matter, since these all use VBA too).

Automating things in Windows

Power Automate Desktop (PAD) allows you to automate tasks in Windows too - the analogy is near-perfect (the only difference is that in PAD there is no language as such, just a series of commands that you accumulate).  To give you an idea of the scope of what you can do, here's a list of the possible actions:

List of PAD actions

Whatever you do in Windows is likely to be covered by this list, including emailing, browsing the web, filling in forms, using different programs, printing and much, much more.  Quite why the list appears in this order, though, is baffling!

 

As one example, here's what the Workstation category above shows when you expand it:

Workstation category

The things you can do wtih the Workstation category.

 

The buzzword for this sort of thing is Robotic Process Automation (RPA), which was the reason why Microsoft bought a Greek company called Softomotive in 2020 (they've now integrated this software into Power Automate).

Recording actions

Power Automate Desktop includes two tools for recording:

Two recorders

The two recording tools.

 

Actions quickly accumulate when you're recording:

Recording script

All I did here was click on a box in an Access database!

What a Power Automate program looks like

Here's an excerpt from a Power Automate program, to show what the commands look like:

Part of a program

This program is looping over the rows of an Excel workbook, typing something into Google for each and getting the results.

How to get Power Automate

Power Automate Desktop is included free of charge within Windows:

Type of Windows licence How to get Power Automate Desktop
Windows 10 Run an installation program
Windows 11 Included automatically

What Power Automate potentially replaces

You could make a case for Power Automate replacing the following software:

Software Notes
Old DOS batch files Why write old-style batch files when you can do everything in PAD?
PowerShell scripts Why learn a different language when you can build flows in Power Automate Desktop?
SQL Server Integrated Services packages Or at least the part which allows you to process files and folders.
Python programs Or at any rate any programs which play around with files and/or folders, call operating system tasks or link to other applications.
Any VBA programs Whether you're working with Word, Excel or Outlook, Power BI Automate lets you automate simple tasks without using VBA.
Web scraping tools You can mimic a human user of a website by building a sequence of PAD commands.

I'm sure this list is incomplete, but it does give some idea of how much time Power Automate can potentially save you!

This blog has 0 threads Add post