Send email when Embed Azure SQL Log in Power Automate

We'll get to know the techniques:

1. Create Automated Cloud Flow:

• Microsoft Power Automate allows you to create automated flows in the cloud that respond to specific events and perform actions across different services, including Azure SQL Database. These flows can be triggered by events such as the arrival of a new email or the updating of a record in the database.

2. Select SQL SERVER AUTHENTICATION TYPE:

• When connecting Power Automate to Azure SQL Database, you need to specify the authentication type. This can be Windows authentication (integrated) or SQL Server authentication (username and password).

3. Create Flow-Compatible Table (CREATE TABLE, IDENTITY, ROWVERSION

• Example of creating a table with identity column and a row version column (rowversion):

  CREATE TABLE Example (
      ID INT PRIMARY KEY IDENTITY,
      Name: NVARCHAR(50),
      Versao ROWVERSION
  );
  

4. Add Email Send Step (SEND MAIL, OFFICE 365 OUTLOOK):

• After an event or action in Power Automate, you can add a step to send an email. This can be done by using the "Send an email (Office 365 Outlook)" action.

5. Insert Record and Execute Trigger (INSERT INTO, TRIGGER

• Example of inserting a record and executing a trigger in the database:

  INSERT INTO Example (Name) VALUES ('New Record');
  -- The trigger will be triggered after insertion
  

6. Set email text to HTML format (VARIABLE):

• In the body of the email, you can use HTML to format the text. This can be configured directly in the settings of the send email action. For example, you can use Power Automate dynamic variables to include information from the embedded record.

These actions enable the automation of processes that involve interactions between Power Automate and Azure SQL Database, providing a flexible and powerful way to create automated workflows.