Book Image

Workflow Automation with Microsoft Power Automate

By : Aaron Guilmette
Book Image

Workflow Automation with Microsoft Power Automate

By: Aaron Guilmette

Overview of this book

Microsoft Power Automate is a workflow automation solution included in Microsoft 365. This book explores the core concepts of workflow automation, such as working with connectors, triggers, and actions, along with their practical implementation in automating business tasks and simplifying digital processes to boost enterprise productivity.
Table of Contents (22 chapters)
Section 1 - What is Power Automate?
Section 2 - Basic Flow Concepts
Section 3 - Intermediate Flow Concepts
Section 4 - Administering the Power Automate Environment

Understanding database connectors, triggers, and actions

Power Automate can connect to a number of databases, such as Microsoft SQL Server, Azure SQL Datawarehouse, Postgres SQL, MySQL, DB2, Oracle, and Xoaa Blockchain (as well as the CDS, which we discussed back in Chapter 9, Getting Started with Approvals). Each of these database technologies shares similar mechanics and concepts. In the examples provided in this book, we're going to focus on using Microsoft SQL Server databases and the related connector, but you may want or need to use others, depending on what you have available.

As with other connectors, the SQL connector has both triggers and actions. We'll examine these next.


The Microsoft SQL Server connector supports two triggers (at the time of writing):

  • When an item is created (v2)
  • When an item is modified (v2)

When working with both of these connectors, you'll need to supply a server name, database name, and table name, as well as optional select...