Introducing Power Automate

by Eric Wyatt
(last updated March 15, 2021)

A considerable pain for many users when it comes to using their computers is dealing with repetitive tasks. These repetitious tasks can, at many times, feel like a waste of time. If you're like me, there are times you wish you could code so you could write a program or app that would perform the task for you. These tasks often go on and on, making you feel like a drone. In recent years, a growing number of solutions try to provide a break from repetitive tasks. These services include sites like IFFT and Zapier. However, a significant drawback to most of these services is that they only work in the cloud and not on your desktop.

Fortunately, Microsoft has a solution that they recently released to all Windows 10 users, capable of desktop automation and cloud service integration. Power Automate is the result of Microsoft's acquisition in 2020 of Softomotive. When Microsoft initially released Power Automate, it was only available for specific versions of Windows operating systems. It was also a service for which Microsoft charged a monthly fee. Recently, however, Microsoft has released Power Automate for all versions of Windows 10, and it is now free. Microsoft has implied that Power Automate will be a part of upcoming Windows releases.

Power Automate allows you, according to Microsoft, to "build flows that do the work for you." A "flow" is the term Microsoft uses for the processes you create to do the repetitious tasks for you. These tasks can be just about anything, from capturing or scraping data from emails or websites to managing files. A simple flow could entail opening a folder of over one-thousand purchase orders you created in Microsoft Word. The flow then opens the files and pulls the specified data from the file, and it will then place the content into the appropriate cell in an Excel workbook.

But why stop there? You can then have Power Automator take those Word files, convert them into a PDF, and then save those PDF files in a new folder. Let's say your purchase order folder also includes other files such as PowerPoint and Excel files all mixed in. You can instruct Power Automate to ignore all the files other than Word documents without slowing you down at all.

Hopefully, this illustrates the type of power that Power Automator affords you. To learn more about Power Automate, go to Microsoft's site:

 This tip (13835) applies to Windows 10.

Author Bio

Eric Wyatt

Eric Wyatt is a swell guy (or so his friends tell him). He is a formally trained designer and branding expert, bringing a wide range of skills to his Tips.Net articles. ...


Keeping Track of Time with Timers

Often it is necessary to be notified when a set amount of time has gone by. With the Timer tab of the Alarms & Clock app ...

Discover More

Setting Process Affinity

When your computer has a multi-core processor or multiple processors you can control how tasks or processes take ...

Discover More

Changing Your DNS Server

Your DNS server is usually set by your Internet provider. You can change the default DNS to another server easily in ...

Discover More
More WindowsTips

Using the Contact Support App

Windows 10 has a built-in Contact Support app that you can use to look up possible answers to issues you're having and ...

Discover More

Ending a Frozen Program

Sometimes a program can get "stuck," meaning it is no longer responsive and appears to be doing nothing at all. You can ...

Discover More

Understanding USB Speeds

The primary method to connect external devices to computers today is USB. Learn about the types of USB and what makes ...

Discover More

FREE SERVICE: Get tips like this every week in WindowsTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.


If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] (all 7 characters, in the sequence shown) in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 3 - 1?

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)

Newest Tips

FREE SERVICE: Get tips like this every week in WindowsTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.