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

Creating a connection to a database

When working with SQL Server (or other database technologies), you'll have to establish a connection to a database. Connection details will depend on the type of database you're connecting to, but the most common fields or properties that you'll need to populate include a server name or IP address, credentials, port numbers, and a database name.

To connect to a database in Power Automate, follow these steps:

  1. Navigate to the Power Automate web portal ( Expand Data and click Connections.
  2. Select + New connection:
  1. Select SQL Server from the list of connection types:
  1. Fill out the dialog box using the server name, database name, and the credentials you created in the previous sections:
  1. Click Create.

Now that a connection has been established, you can create a simple button flow in order to place information in the database.