Hi All,
I am trying to build an automated cloud flow that triggers when a specific column's value in a row is modified in Dataverse.
I have put together the flow as follows:
Step 1: when a row is modified
Step 2: get a row by name
Step 3: get a row by name (this is just to reference a different table that I need to reference in the email itself)
Step 4: condition (the column I want to reference if changed is equal to the choice value for the one i need)
(The column name is the inspection results and the choice field has either pass or fail as choices, 100000001 being fail and which would make the condition true)
The flow does work in referencing if it is a fail or pass, but it seems that whenever another column is changed it triggers the flow still so it sends the email for a failed item any time another column is updated.
I went back to step 1 and did the advanced options to select columns and put in the logical name of the inspection column so as to make it only run when this column changes, but now it seems that the flow just runs and never completes as it just keeps the spinning ring going and going.
Is the logical name the incorrect input for this field? or do I need to reference this somewhere else in the flow to make it correct?
