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

Adding database content

In this section, we'll look at creating a simple button flow that adds a row of data to a database table. To do this, you'll need a database and a table. In the following example, we'll create a SQL instance and a database that we'll use for our Power Automate configuration.

Creating a server

While you can use any supported database technology with Power Automate, we're going to focus on SQL Server. If you already have an existing SQL server available, you can skip this step. Otherwise, you can provision the necessary components in Azure to start working immediately.

To create a SQL server in Azure, follow these steps:

  1. Navigate to and sign into a tenant using an account with administrative privileges. (If you don't currently have an Azure subscription, you can sign up for a trial).
  2. From the search bar, begin typing SQL and select SQL Servers.
  3. Click +Add.
  4. Select a subscription and a resource group. If you do...