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

Adding content to a database

Now that you have configured a server, a database, and a table with columns, you get to see all the pieces working together. In this section, you’ll create a flow, execute it, and then verify that it wrote the data successfully.

First, let’s create a flow so that we can add content.

Creating the flow

To verify that you’ve configured database connectivity, we’ll walk through creating a sample button or instant flow so that we can post data to the database. Follow these steps to create the flow:

  1. From the Power Automate web portal (, select Create.
  2. In the Start from blank section, select Instant cloud flow.
  3. Enter a name for the flow, and then select Manually trigger a flow as the trigger type.
  4. Click Create.
  5. Click New step.
  6. In the search box, enter SQL insert and then select the Insert row (V2) action:

Figure 12.13: Selecting the Insert...