Power Automate Tutorial - SQL Server

If you have not read the Power Automate Integration article, please read that first before beginning this tutorial.

Okay, now that we've got the Pares JSON connector setup we can take the form data and integrate in to other back end systems.

Microsoft SQL Server is a relational database management system. You can perform various actions such as create, update, get, and delete on rows in a table.

This tutorial is focused on 'Insert row' connector, used to add rows to tables in your database.

First create a new connector by searching for SQL Server, and select "Insert row".

Now that you have chosen the connector, you will need to connect your database.

This will depend on the specific database you wish to use.

Once you have finished connecting your SQL Database, you will be asked to select a table you want to populate.

The columns for the table will automatically display, and all you need to do is connect the columns to the correct form data source.

Your done! Make sure to save, and try submitting your form and seeing if the form data appears in the database table. 

You are able to check if you flow ran correctly by clicking on the flow and looking at the Run History.