How to Configure Power Automate Triggers for Row Deactivation in Dataverse?
Table of Contents
Question
You are building a Power Automate cloud flow that is triggered when a Dataverse table row is updated.
You need to configure the trigger so the flow only runs when a row is deactivated.
Which two properties should you configure? Each correct answer presents part of the solution.
Select all answers that apply.
A. Scope
B. Row filter
C. Row count
D. Column filter
E. FetchXML query
Answer
B. Row filter
D. Column filter
Explanation
This item tests the candidate’s knowledge of configuring trigger filters.
To restrict a flow to run when a Dataverse table row is deactivated, you must specify the column that is updated and the query that matches the value of the column. When a Dataverse table row is deactivated, the statecode column is set to 1 (Inactive). To configure the trigger so that the flow only runs when a row is deactivated, you need to set the column filter to the column, which should be statecode, and also set the row filter with an OData query (i.e., statecode eq 1).
FetchXML query and row count are not used in the trigger. They are used in the List rows action. Scope restricts flow runs based on the ownership of the row.
Microsoft Power Platform Developer PL-400 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Microsoft Power Platform Developer PL-400 exam and earn Microsoft Power Platform Developer PL-400 certification.