Dataflow Triggering "Modified" Automation

(1) Share

Report

Posted on by mschwing

I have a flow that is setup to trigger when a column is modified on a dataverse table.

Screenshot 2023-01-26 105104.png

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?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

AhmedSalih

6,678 Moderator on at

Like (0)

Report

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:

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Verified answer

AhmedSalih 6,678 Moderator on at

Like (1)

Report

@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.

Was this reply helpful? Yes No