Azure logic app with Condition

Question

I am creating the logic app when I want to send an email when there are duplicate entries created in my database, and until those are not removed email should be triggered after some interval

As per Logic App, we can create a trigger on SQL when data is inserted or modified as bellow

So I selected the first option then I am adding another action which will run my SQL script to check the logic of duplicate entries

and last I have added another action to send an email.

Now I want my last action of sending email to be executed only when my query comes up with some result

Answer 1

I think you're better off programming the duplicate condition detection into a Stored Procedure rather than a SQL Trigger then using the Logic App change Trigger.

Instead, use a Logic App and Recurrence to call the Stored Procedure that queries for duplicates and returns the necessary meta data.

Trigger + table + change will be less reliable then you expect and much harder to maintain.

Answer 2

You can use a Condition Control to check whether the given result set is valid if the condition satisfies then you can send the email

See my logic app below.

Here I've added the Execute a Stored Procedure Action. My stored procedure returns resultsets, you can use the logic for checking the duplicate and in the next condition you can check the duplicate result is true (or) false. If it's true you can send email else not to.

Update 1

How to Add condition control