带条件的Azure逻辑应用 [英] Azure logic app with Condition

问题描述

当数据库中存在重复的条目时，当我想发送电子邮件时，我正在创建逻辑应用程序，直到这些条目被删除之前，应在一定间隔后触发电子邮件

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

根据Logic App，当将数据插入或修改为波纹管之后，我们可以在SQL上创建触发器

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

所以我选择了第一个选项，然后添加了另一个操作，该操作将运行我的SQL脚本以检查重复条目的逻辑

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

推荐答案

您可以使用

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.

在这里，我添加了Execute a Stored Procedure操作.我的存储过程返回结果集，您可以使用逻辑检查重复项，在下一个条件下，您可以检查重复结果为true(或)false.如果是这样，您可以发送电子邮件，否则不发送电子邮件.

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.

更新1

如何添加条件控件

这篇关于带条件的Azure逻辑应用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！