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
30 Sep, 2024

SMS Integration with Twilio Number in D365 Customer Service- Part 1

Introduction Integrating SMS functionality into Dynamics 365 can significantly enhance customer communication by providing a direct and efficient channel for…

READ MORE
Blogs
24 Sep, 2024

White Box Testing - Its Techniques and Types

In this blog, we’ll deal with one of the most popular methods of testing a system or system component thoroughly…

READ MORE
Case Study
06 Sep, 2024

Implementation of Business Central for a Trading Organization

Customer Overview A prominent trading organization sought to enhance its operational efficiency and streamline its business processes by implementing Dynamics…

READ MORE