Dataflows modifying EVERYTHING instead of rows that changed

[Syndicate_Admin]

I have a power automate flow that triggers based on changed values in a table. The table has a dataflow that somehow triggers every single row with the flow even if most of the rows are identical to before the refresh. I think the act of the dataflow itself is "modifying" every row, therefore triggering the flow for every single row. How do I stop this? How do I make it so the dataflow only updates the row if there is a different value there than before? I've tried incremental refresh but we don't have a date column to help with that.

[v-yanjiang-msft]

Hi @Syndicate_Admin ,

Please try to add a filter in your flow to check if the value has changed. Firstly create a column "value is changed", when the value is changed, the column get "yes", then the flow can be trigered. Please refer to: Trigger flows when a row is added, modified, or deleted - Power Automate | Microsoft Learn

Here're some similar threads:

Solved: Run flow only when status column has changed and t... - Power Platform Community (microsoft....

Solved: Trigger flow when only one field in list is modifi... - Power Platform Community (microsoft....

Best regards,

Community Support Team_yanjiang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.