Answered

Sending email when sql is updated - microsoft flow

Like (0) Share

Report

Posted on 1 Oct 2018 15:35:14 by asdeev

Scenario: When a new item is added to a sql table, start a flow and, if the condition (x) is true, and condition (y) contains (sometext), send an email to someperson. X,Y, and sometext will depend on the table you are using.

~Can someone help me create this flow. Do I need to have a gateway? Should I be using the exisiting SQL and any table or should I be able to create a new table? Is there a template already for this scenario?

I have the same question (0)

All responses (2)

Answers (1)

asdeev on 23 Oct 2018 at 16:10:08

Like (0)

Report

Re: Sending email when sql is updated - microsoft flow

Awesome, thank you so much for your help!!

Was this reply helpful? Yes No
Verified answer

v-yamao-msft on 03 Oct 2018 at 09:47:15

Like (1)

Report

Re: Sending email when sql is updated - microsoft flow

Hi @asdeev,

If you are going to trigger a flow using SQL Server triggers, then you don’t need to have Gateway. As currently the SQL Server triggers don’t work for on-premises SQL Server.

For your scenario, please use SQL Server trigger when an item is modified.

Add the first condition, say it is a Yes/No column, then the condition could be configured as:

@Equals(column,bool(‘’True))

Under if yes branch, add the second Condition, say it is a text column, then the condition could be configured as:

@Contains(column name, ‘sometext’)

Under if yes branch of the second condition, add the action Send an email.

SQL Azure is not available on my side so I made another test based on SharePoint list. Please just take it for a reference:

Related docs for your reference:

https://flow.microsoft.com/en-us/blog/introducing-triggers-in-the-sql-connector/

https://docs.microsoft.com/en-us/connectors/sql/

Best regards,

Mabel Mao

Was this reply helpful? Yes No