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 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. Under the Start from blank section, select Instant 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:
  1. From the dropdowns for the action, select the server name, database name, and the table name you created...