Question

You built an automated cloud flow using the Dataverse connector's 'When a row is added, modified or deleted' trigger on the Account table. The flow should run only when the 'Credit Limit' column value changes, but you notice it currently executes on every account update, consuming a large number of flow runs. What is the most efficient way to ensure the flow runs only when the 'Credit Limit' column changes?

Accepted Answer

Set the 'Select columns' (filter columns) property on the trigger to 'creditlimit' and configure the trigger to fire on Modified.

Answer

Add a Condition action at the start of the flow that compares the new value to the old value and terminates if they are equal.

Answer

Add a trigger filter (filter expression) on the trigger to check only Credit Limit, and leave 'Select columns' empty.

Answer

Change the flow to an instant flow and call it manually whenever the Credit Limit is updated.