我是从“添加,修改或删除的行”连接器开始的,我将通过一个开关连接器,该连接器是否添加,修改或删除该行,该连接器可以控制该连接器。
然后,我使用邮件节点来通知自己,如果添加,修改或删除了一行,则在添加一行的情况下,我必须将其包括在邮件中,该行已修改了该行的哪个字段。
我找不到此控件是否可能(检查行并将其与预修改版本进行比较)以及如何做。
这是拥抱流
I'm starting from a "When a row is added, modified or deleted" connector, i'm passing in a switch connector that controls if the row is added, modified or deleted.
I'm then using the mail node to notify myself if a row is added, modified or deleted, in the case a row is added i have to include in the mail which fields of that row have been modified.
I can't find if this control is possible (check the row and compare it with the pre-modified version) and how to do it.
This is the embrional flow
发布评论
评论(3)
这可能会帮助您进行特定的修改:
在触发节点中,如果单击“显示高级选项”,您将看到一个标有“选择列”的文本框。如果您在该框中输入任何字段名称,则除非修改其中一个字段,否则云流量不会触发。悬停在文本框上,向您展示了它的作用。
This may help you for getting specific modifications: https://carldesouza.com/power-automate-dataverse-adding-scope-for-field-changes/
In the trigger node, if you click "Show advanced options", you'll see a textbox labeled "Select columns". If you enter any field name in that box, the cloud flow won't trigger unless one of those fields is modified. Hovering over the textbox shows you an explanation of what it does.
根据要求,我会尝试更详细。
请注意,这是电源自动流量,因此几乎没有代码。
CRUD连接器采用3个参数:
- 变换类型(添加,修改或删除项目时)
- 表名称(这是Dataverse表名称)
- 范围(业务单元),
所以我需要知道(例如在该连接器的输出中)是否有一个变量或其他连接器,其中包含哪个列更改并引起触发器)
,这是有关输出或可能相关的连接器的问题对于数据词CRUD节点,因此不涉及代码,并且不再需要“发行”流程规范来理解我的请求
As requested i'll try to be more detailed.
Please note that this is a POWER AUTOMATE FLOW so there is almost no code.
The CRUD connector takes 3 arguments:
-Change type (When an item is Added, Modified or Deleted)
-The table name (It's the Dataverse table name)
-The scope (Business Unit)
So i need to know if (for example in the output of this connector) there is a variable or other connector that contains which column changed and caused the trigger)
It's a question about the output or possible connectors related to the Dataverse CRUD node so there is NO CODE involved and no more "after-issue" flow specification needed to understand my request
一种解决方案是创建一个新的字段,该字段保持原始字段的当前值并使用触发条件才能使您的流程仅在两个字段不匹配时运行,这意味着原始字段已更新并且其值已更改。
A solution is to create a new field that keeps the current value of the original field and use trigger conditions to make your flow run only when those two fields don't match, meaning that the original field is updated and that its value has changed.