I have a flow that is setup to trigger when a column is modified on a dataverse table.
I also have a dataflow that updates this table daily, issue I am having is that the dataflow is triggering the automation every time it runs on every line even when the specified column does not change. Is there a way to avoid this?
@rampprakash, I though about the same thing after I posted my reply. I think yes/no wont work. It has to be a time stamp. and you check the time to be within a range where the dataflow run.
Hi @AhmedSalih
But am having another doubt too if we set that field to Yes then while making changes again in the form and we expect the flow to trigger at that time it won't trigger.
Hello, @mschwing, Dataflows update all columns values with the data from the datasource regardless of whether the data changed or not.
One way I use to achieve your requirement is add a column to hold the change status of your
specified column". This will be yes/no column. In your data source, where you are pulling data using the data flow, you will need to change the value of this column to yes when that column change.
Note, you need to have this status column in the dataverse table too and map it in the dataflow.
Now, in your power automate you need to setup your trigger as below:
ankit_singhal
11
Super User 2025 Season 1
mmbr1606
9
Super User 2025 Season 1
CU07050602-0
4