knowledgecenter-breadcrum

Knowledge Center

15 Jul, 2020

SQL Connectors in Microsoft Flow/Power Automate

Posted on 15 Jul, 2020 by Admin, Posted in Power Automate

SQL Connectors in Microsoft Flow/Power Automate Blogs

SQL Connectors in Microsoft Flow/Power Automate

Introduction

In this blog, we have explained how to use SQL connectors in Microsoft Flow/Power Automate. We can easily map SQL server database table to CRM entities or update record in to CRM entities from SQL table and vice versa. Whenever changes happen in SQL table, we can move those changes to CRM entities and reverse is also possible. Let’s see how we can do that.

Step by step

  1. In Microsoft flow, we start with a trigger which will starts the flow execution. We can find various SQL server triggers.

  2. Note: When an item is modified trigger works only if you have timestamp type column in your database table.
  3. The first trigger is shown in the picture is used to trigger the flow when a record created in SQL server database and the second trigger is used to trigger the flow when a record updated in SQL server database. You can select the appropriate trigger as per your requirement.
  4. After selecting a trigger, it will show some fields to select “Server Name”, “Database name” and “Table Name”.
  5. To select all information, we first need to connect to SQL server. To connect with SQL server database, firstly, we need to create a connection to SQL server.
  6. To do that, click on 3 dots situated at the top right side of the trigger step. Then click on the “+ Add new connection” tab.
  7. Then you will see a dropdown list of authentication type. Select a type according to authentication type of you SQL server. If you are selecting “Azure AD integrated”, then you sign into your azure. If you are selecting “windows authentication”, you must give window password and username along with server name and database name. In my case, I am choosing “SQL Server authentication”.
  8. As you can see in picture, you must fill into the fields, server name, database name, username and password. After that, click on the “Create” button. It will create a connection to SQL server. Using this connection, you can fill necessary information on SQL trigger in step 4.
  9. Because of SQL trigger, you will get all fields value from selected table specific to a record that triggered the flow. You can use them from Dynamic Content.
  10. As far we have seen how to trigger Microsoft Flow using SQL server triggers. Apart from that there are SQL server action that we can do for perform action on SQL server from MS flow.
  11. SQL Connectors
  12. As per above picture, there are 9 different action to work on SQL server from MS Flow.

There are certain limitations in using SQL server actions. For more information, visit https://docs.microsoft.com/en-us/connectors/sql/

Comment

This is a Required Field

Loading

Recent Updates

Blogs
11 Jun, 2024

How to create a routing rule set to route cases in Dynamics 365

In this blog we will discuss how to create a routing rule to automatically route the cases to queue in…

READ MORE
Blogs
06 Jun, 2024

Restoring Deleted Records in Dataverse Tables

In this blog post, I will be discussing how we can restore the deleted records from any table in Dataverse.…

READ MORE
Blogs
15 May, 2024

Associated Grid Control Component in Dataverse

The Associated Grid Control enables us to improve the simplicity and readability of forms by displaying related record details across…

READ MORE