Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletter Hub
Free Learning
Arrow right icon
timer SALE ENDS IN
0 Days
:
00 Hours
:
00 Minutes
:
00 Seconds
Workflow Automation with Microsoft Power Automate
Workflow Automation with Microsoft Power Automate

Workflow Automation with Microsoft Power Automate: Design and scale AI-powered cloud and desktop workflows using low-code automation , Third Edition

Arrow left icon
Profile Icon Aaron Guilmette
Arrow right icon
€18.99 per month
Paperback Dec 2025 544 pages 3rd Edition
eBook
€8.98 €26.99
Paperback
€33.99
Subscription
Free Trial
Renews at €18.99p/m
Arrow left icon
Profile Icon Aaron Guilmette
Arrow right icon
€18.99 per month
Paperback Dec 2025 544 pages 3rd Edition
eBook
€8.98 €26.99
Paperback
€33.99
Subscription
Free Trial
Renews at €18.99p/m
eBook
€8.98 €26.99
Paperback
€33.99
Subscription
Free Trial
Renews at €18.99p/m

What do you get with a Packt Subscription?

Free for first 7 days. $19.99 p/m after that. Cancel any time!
Product feature icon Unlimited ad-free access to the largest independent learning library in tech. Access this title and thousands more!
Product feature icon 50+ new titles added per month, including many first-to-market concepts and exclusive early access to books as they are being written.
Product feature icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Product feature icon Thousands of reference materials covering every tech concept you need to stay up to date.
Subscribe now
View plans & pricing
Table of content icon View table of contents Preview book icon Preview Book

Workflow Automation with Microsoft Power Automate

Introducing Microsoft Power Automate

Business activities in the Information Age are filled with repetitive tasks: receive an email, generate a purchase order, send a message, route a document, approve a time-off request, and so on. In many cases, these activities don’t generate real value, though they do need to get done to help support business goals.

Computers introduced the promise of helping us do more, but a lot of that has resulted in there being more to do in order to get the same value. What if we could use technology to handle routine tasks and save our strength for doing the things that require skill and thinking?

In this book, we’re going to learn the basics of Microsoft Power Automate, a tool designed to help you automate repetitive tasks and get you back to generating value. This newly revised third edition includes expansions to include Robotic Process Automation (RPA), artificial intelligence (AI), generative AI (GenAI), and governance.

This...

Join our book community on Discord

A qr code with a square and a white symbol AI-generated content may be incorrect.https://packt.link/EarlyAccess

Business activities in the Information age are filled with repetitive tasks: receive an email, generate a purchase order, send a message, route a document, approve a time-off request. In many cases, these activities don't generate real value, though they do need to get done to help support business goals.Computers introduced the promise of helping us do more, but a lot of that has resulted in there being more to do in order to get the same value. What if we could use technology to handle routine tasks and save our strength for doing the things that require skill and thinking?In this book, we're going to learn the basics of Microsoft Power Automate, a tool designed to help you automate repetitive tasks and get you back to generating value. This newly-revised third edition includes expansions to include robotic process automation (RPA), artificial intelligence (AI), generative AI (GenAI), and governance...

What is Power Automate?

Power Automate, part of the Power Platform family of products, is a workflow engine that can be used to automate common business processes or sequences based on conditions or scenarios. Power Automate (formerly known as Microsoft Flow) is primarily a web-based tool designed to interface with a growing library of software from both Microsoft and other vendors. Due to its no-code/low-code design, Power Automate can be approached by individuals with any technical skill level—including office or business users with no coding experience, system administrators, and analysts. Power Automate also allows more advanced programmers to use complex integrations and develop custom code.

Power Automate Desktop

In early 2021, Microsoft introduced Power Automate Desktop—a product that could be used to help automate legacy business applications and processes using a new feature called Robotic Process Automation (RPA...

Choosing what to automate

Frequently, people do work that they don't need to do. However, it's important to differentiate between work that doesn't need to be done at all and work that needs to be done but doesn't require you to do it.From both the administrative and end-user perspectives, there are a number of activities, processes, and tasks in Office 365 and other line-of-business applications that can be automated through the use of Power Automate. Automation is a key business technology to reduce the impact of repetitive, low-skill tasks on the workforce. When thinking about business processes, they can generally be divided into one of the following four quadrants:

Figure 1.2 – Candidates for automate

These quadrants make up a type of priority matrix (sometimes called an effort-impact or value-skill matrix). Here’s a breakdown of what each area means:

  • High value, low skill: Requires...

Getting up to speed on general terminology

You've already seen a few terms, and if you're familiar with SharePoint or other collaboration tools, they may be recognizable. But just to make sure we have a solid foundation, we're going to go over some basic terminology, and then we'll start getting into specific Power Automate terminology.

Business process

A business process is any sequence of tasks needed to accomplish the business's purpose. This may be something as simple as submitting a timecard or getting a signature on a purchase order. Business processes generally fall into three categories:

  • Primary or operating processes: These typically result in some sort of customer value delivery, such as a customer placing an order and the business shipping a product. They also may include things such as product design and engineering.
  • Support: These processes are necessary for the primary or operating...

Expanding into Power Automate terminology

As we begin working with Power Automate, it will be important to understand the core terminology that is being used. It’s also important to note that terminology periodically changes, so if you started using Power Automate a few years ago (for example, back when it was called Flow), you may want to read through and make sure you’re using current terminology and concepts. The following terms are generally organized in the order that you’ll encounter them in the book, which also corresponds to their increasing complexity and usage. You'll need to understand them so you can choose where to apply the correct business logic and processes. As you go through this book, if you encounter terms you don’t recognize, you can refer back to this section to help reorient yourself.

Flow

A flow is simply the logical grouping of tasks or actions used to automate a process. Flows can be identified...

Getting Power Automate

Before you get started, you’ll need to make sure you have licenses that support the type of flows you want to create.As mentioned previously, Power Automate contains the concepts of standard and premium connectors. Standard connectors are available for all Power Automate plans, including the Power Automate plans that come with Microsoft 365 (also sometimes referred to as seeded licenses). Premium connectors (or features such as AI builder and robotic process automation) may require the use of a separate standalone Power Automate license. Additionally, Power Automate supports User and Capacity licensing. User licenses are applied to directly to users while capacity licenses are allocated to automations (such as a flow).

  • Power Automate Premium (user license)
  • Power Automate Process (capacity license)
  • Power Automate Process Mining (user license)
  • Power Automate Hosted RPA (capacity license)
  • Power...

Summary

In this chapter, we discussed the high-level concepts of Power Automate, including how it relates to solving problems (such as business processes or workflows). We also covered introductory knowledge concepts such as actions, triggers, and conditions. Understanding the types of triggers and connectors will help you design flows and business processes that reduce repetitive work and produce value in your organization.In addition, understanding the features and terminology, we covered some of the updates and changes to Microsoft Power Automate since the last revision of this book, including the introduction of Power Automate Desktop and general availability of both Robotic Process Automation and AI Builder (along with the expansion and inclusion of generative AI features).We also touched on the licensing necessary to take advantage of Power Automate features.In the next chapter, we're going to begin exploring the Power Automate interface and use it to create simple...

Left arrow icon Right arrow icon
Download code icon Download Code

Key benefits

  • Build flows faster using Copilot, AI Builder, and Gen AI tools
  • Learn to create robust cloud and desktop automations through real-world examples
  • Implement best practices for security, governance, and monitoring

Description

Whether you're automating a daily task or implementing automation at scale, this third edition gives you everything you need to succeed. This practical guide makes automation accessible, helping you streamline operations using low-code cloud flows, desktop RPA, and AI tools built into Microsoft Power Automate. You’ll begin by building foundational skills through easy-to-follow tutorials that show how to automate actions across Outlook, Teams, SharePoint, Slack, and more. From there, you'll level up to integrating approvals, databases, and Forms, handle complex scenarios such as sequential and parallel approvals, and manage shared flows. The book explores Power Automate’s robotic process automation capabilities, teaching you how to automate legacy applications, web interfaces, and Access databases. With expanded coverage of AI Builder, sentiment analysis, Copilot, and document summarization using generative AI, you'll gain hands-on experience creating intelligent, responsive workflows that drive efficiency. Written by a Microsoft 365 expert, this third edition adds 8 new chapters along with guidance on governance, compliance, and enterprise deployment, making it a complete guide for anyone looking to get started or scale automation with Power Automate. *Email sign-up and proof of purchase required

Who is this book for?

This book is ideal for information workers, citizen developers, and Power users looking to automate workflows across Microsoft 365, Teams, Outlook, and third-party platforms. Basic familiarity with Microsoft 365 is recommended.

What you will learn

  • Build cloud flows using triggers, connectors, and actions
  • Use Copilot and generative AI to create and edit flows
  • Automate desktop tasks with Power Automate for Desktop
  • Create approval processes for Teams, Slack, and email
  • Connect Power Automate to Dataverse, Forms, and SQL
  • Implement error handling, monitoring, and troubleshooting
  • Govern and scale automations using best practices

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Dec 05, 2025
Length: 544 pages
Edition : 3rd
Language : English
ISBN-13 : 9781836649632
Category :

What do you get with a Packt Subscription?

Free for first 7 days. $19.99 p/m after that. Cancel any time!
Product feature icon Unlimited ad-free access to the largest independent learning library in tech. Access this title and thousands more!
Product feature icon 50+ new titles added per month, including many first-to-market concepts and exclusive early access to books as they are being written.
Product feature icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Product feature icon Thousands of reference materials covering every tech concept you need to stay up to date.
Subscribe now
View plans & pricing

Product Details

Publication date : Dec 05, 2025
Length: 544 pages
Edition : 3rd
Language : English
ISBN-13 : 9781836649632
Category :

Packt Subscriptions

See our plans and pricing
Modal Close icon
€18.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
€189.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts
€264.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts

Table of Contents

34 Chapters
Part 1: The Basics Chevron down icon Chevron up icon
Introducing Microsoft Power Automate Chevron down icon Chevron up icon
Getting Started with Power Automate Chevron down icon Chevron up icon
Working with Email Chevron down icon Chevron up icon
Copying Files Chevron down icon Chevron up icon
Creating Button Flows Chevron down icon Chevron up icon
Generating Push Notifications Chevron down icon Chevron up icon
Working with Shared Flows Chevron down icon Chevron up icon
Part 2: Advanced Operations and Flows Chevron down icon Chevron up icon
Working with Conditions Chevron down icon Chevron up icon
Understanding Expressions and Functions Chevron down icon Chevron up icon
Getting Started with Approvals Chevron down icon Chevron up icon
Working with Multiple Approvals Chevron down icon Chevron up icon
Posting Approvals to Teams Chevron down icon Chevron up icon
Using Databases Chevron down icon Chevron up icon
Working with Microsoft Forms Chevron down icon Chevron up icon
Posting to Slack Chevron down icon Chevron up icon
Accepting User Input Chevron down icon Chevron up icon
Automating Entra ID Chevron down icon Chevron up icon
Part 3: Robotic Process Automation, AI Models, Copilot, and Beyond Chevron down icon Chevron up icon
Introducing Robotic Process Automation Chevron down icon Chevron up icon
Contributing to an Access Database with RPA Chevron down icon Chevron up icon
Automating Web Pages with RPA Chevron down icon Chevron up icon
Introducing AI Models and Generative AI Chevron down icon Chevron up icon
Creating a Sentiment Analysis Flow Chevron down icon Chevron up icon
Using Copilot to Create and Manage Flows Chevron down icon Chevron up icon
Using Generative AI to Summarize Documents Chevron down icon Chevron up icon
Part 4: Administration Chevron down icon Chevron up icon
Exporting, Importing, and Distributing Flows Chevron down icon Chevron up icon
Monitoring and Troubleshooting Flows Chevron down icon Chevron up icon
Governance in the Power Platform Chevron down icon Chevron up icon
Unlock Your Exclusive Benefits Chevron down icon Chevron up icon
Other Books You May Enjoy Chevron down icon Chevron up icon
Index Chevron down icon Chevron up icon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

What is included in a Packt subscription? Chevron down icon Chevron up icon

A subscription provides you with full access to view all Packt and licnesed content online, this includes exclusive access to Early Access titles. Depending on the tier chosen you can also earn credits and discounts to use for owning content

How can I cancel my subscription? Chevron down icon Chevron up icon

To cancel your subscription with us simply go to the account page - found in the top right of the page or at https://subscription.packtpub.com/my-account/subscription - From here you will see the ‘cancel subscription’ button in the grey box with your subscription information in.

What are credits? Chevron down icon Chevron up icon

Credits can be earned from reading 40 section of any title within the payment cycle - a month starting from the day of subscription payment. You also earn a Credit every month if you subscribe to our annual or 18 month plans. Credits can be used to buy books DRM free, the same way that you would pay for a book. Your credits can be found in the subscription homepage - subscription.packtpub.com - clicking on ‘the my’ library dropdown and selecting ‘credits’.

What happens if an Early Access Course is cancelled? Chevron down icon Chevron up icon

Projects are rarely cancelled, but sometimes it's unavoidable. If an Early Access course is cancelled or excessively delayed, you can exchange your purchase for another course. For further details, please contact us here.

Where can I send feedback about an Early Access title? Chevron down icon Chevron up icon

If you have any feedback about the product you're reading, or Early Access in general, then please fill out a contact form here and we'll make sure the feedback gets to the right team. 

Can I download the code files for Early Access titles? Chevron down icon Chevron up icon

We try to ensure that all books in Early Access have code available to use, download, and fork on GitHub. This helps us be more agile in the development of the book, and helps keep the often changing code base of new versions and new technologies as up to date as possible. Unfortunately, however, there will be rare cases when it is not possible for us to have downloadable code samples available until publication.

When we publish the book, the code files will also be available to download from the Packt website.

How accurate is the publication date? Chevron down icon Chevron up icon

The publication date is as accurate as we can be at any point in the project. Unfortunately, delays can happen. Often those delays are out of our control, such as changes to the technology code base or delays in the tech release. We do our best to give you an accurate estimate of the publication date at any given time, and as more chapters are delivered, the more accurate the delivery date will become.

How will I know when new chapters are ready? Chevron down icon Chevron up icon

We'll let you know every time there has been an update to a course that you've bought in Early Access. You'll get an email to let you know there has been a new chapter, or a change to a previous chapter. The new chapters are automatically added to your account, so you can also check back there any time you're ready and download or read them online.

I am a Packt subscriber, do I get Early Access? Chevron down icon Chevron up icon

Yes, all Early Access content is fully available through your subscription. You will need to have a paid for or active trial subscription in order to access all titles.

How is Early Access delivered? Chevron down icon Chevron up icon

Early Access is currently only available as a PDF or through our online reader. As we make changes or add new chapters, the files in your Packt account will be updated so you can download them again or view them online immediately.

How do I buy Early Access content? Chevron down icon Chevron up icon

Early Access is a way of us getting our content to you quicker, but the method of buying the Early Access course is still the same. Just find the course you want to buy, go through the check-out steps, and you’ll get a confirmation email from us with information and a link to the relevant Early Access courses.

What is Early Access? Chevron down icon Chevron up icon

Keeping up to date with the latest technology is difficult; new versions, new frameworks, new techniques. This feature gives you a head-start to our content, as it's being created. With Early Access you'll receive each chapter as it's written, and get regular updates throughout the product's development, as well as the final course as soon as it's ready.We created Early Access as a means of giving you the information you need, as soon as it's available. As we go through the process of developing a course, 99% of it can be ready but we can't publish until that last 1% falls in to place. Early Access helps to unlock the potential of our content early, to help you start your learning when you need it most. You not only get access to every chapter as it's delivered, edited, and updated, but you'll also get the finalized, DRM-free product to download in any format you want when it's published. As a member of Packt, you'll also be eligible for our exclusive offers, including a free course every day, and discounts on new and popular titles.

Modal Close icon
Modal Close icon