Book Image

Workflow Automation with Microsoft Power Automate - Second Edition

By : Aaron Guilmette
4 (2)
Book Image

Workflow Automation with Microsoft Power Automate - Second Edition

4 (2)
By: Aaron Guilmette

Overview of this book

MS Power Automate is a workflow automation tool built into MS 365 to help businesses automate repetitive tasks or trigger business processes without user intervention. It is a low-code tool that is part of the Microsoft applications framework, the Power Platform. If you are new to Power Automate, this book will give you a comprehensive introduction and a smooth transition from beginner to advanced topics to help you get up to speed with business process automation. Complete with hands-on tutorials and projects, this easy-to-follow guide will show you how to configure automation workflows for business processes between hundreds of applications, using examples within Microsoft and including third-party apps like Dropbox and Twitter. Once you understand how to use connectors, triggers, and actions to automate business processes, you’ll learn how to manage user input, documents, and approvals, as well as interact with databases. This edition also introduces new Power Automate features such as using robotic process automation (RPA) to automate legacy applications, interacting with the Microsoft Graph API, and working with artificial intelligence models to do sentiment analysis. By the end of this digital transformation book, you’ll have mastered the basics of using Power Automate to replace repetitive tasks with automation technology.
Table of Contents (22 chapters)
Other Books You May Enjoy

To get the most out of this book

To get the most out of this book, you should have a Microsoft 365 subscription with access to a premium Power Automate plan to enable access to premium connectors, AI models, and Robotic Process Automation.

You should also have an internet-connected computer with a modern browser such as Microsoft Edge or Google Chrome. You can obtain a free Microsoft 365 subscription from

For Chapter 2, Getting Started with Power Automate, and Chapter 4, Copying Files, you will need accounts on Twitter and Dropbox, respectively.

For Chapter 16, Introduction to Robotic Process Automation, you will need a Power Automate license that includes unattended Robotic Process Automation.

For Chapter 17, Introduction to AI Models, you will need AI Builder capacity. The unattended Robotic Process Automation licensing includes a base level of AI Builder capacity suitable for completing the examples.

Download the example code files

The code bundle for the book is hosted on GitHub at We also have other code bundles from our rich catalog of books and videos available at Check them out!

Download the color images

We also provide a PDF file that has color images of the screenshots/diagrams used in this book. You can download it here:

Conventions used

There are a number of text conventions used throughout this book.

CodeInText: Indicates code words in text, database table names, folder names, filenames, file extensions, pathnames, dummy URLs, user input, and Twitter handles. For example: “Update the prompt to say Please enter today's date.”

A block of code is set as follows:

  "type": "thumbnail",
  "fileName": "FavoriteThing.jpg",
  "fieldName": "Picture",
  "serverUrl": "",
  "serverRelativeUrl": "@{decodeUriComponent(decodeUriComponent(outputs('Add_attachment')?['body/Id']))}",
  "id": "@{guid()}"

Bold: Indicates a new term, an important word, or words that you see on the screen. For instance, words in menus or dialog boxes appear in the text like this. For example: “A gateway is a software application installed on an on-premises computer.”

Warnings or important notes appear like this.

Tips and tricks appear like this.