Dataflow - when run Power Automate get triggerd on update

[Oskarkuus]

I use dataflows to bring data from sql database to dataverse.

but then i have power automate flows that triggers on updates on the dataverse tables.

so each time the dataflow runs all my update triggers in power automate activates.

i found this thread: https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Dataflow-triggers-update-on-Power-Automate-F...

But i dont understand how to actually use filter and column to make the flow only trigger if specifi...

[Mira_Ghaly]

@Oskarkuus

So simply filter rows and select columns acts as your update flow triggers so when do you want to run the update flow will help you avoid this unnecessary updates.

If you know the fields that should trigger your update flow and on which conditions?

[Oskarkuus]

Still dont understand.

I want the flow to trigger IF the value have changed in a specific column.

This is my trigger:

But each time i run my dataflow the power automate flow triggers for all rows in the table.

How to make it so that the flow only triggers IF there is a new value. It seems like the dataflow creates an update event in the column and that triggers the power automate flow.

[Mira_Ghaly]

@Oskarkuus 

Then you will need to add a filter rows to avoid this.

Example;

status eq 'active' 

The filter row is an odata expression which defines the criteria for your update to run.

[Oskarkuus]

Well that wont be possible.

Since the dataflow moves data from the sql table to the dataverse table.

You then mean i need to add a column that indicates 1 or 0 (for example) if another value have been updated?

There is no way of actually just trigger the flow if the value is new and not the exact same?

[Oskarkuus]

So maybe you have an idea so i can use something else instead of power automate.

I have a sql db that looks like this

Table 1: Users

Table 2: Customers

Table 1:

UserID, UserName

Table2:

CustomerID,CustomerName,AccountManager

Column AccountManager in Table2 (customers) is the UserID from Table1.

When i bring in the data to dataverse tables.

I want to create a relationship columns. So first i runt the dataflow so the tables and columns are created. Then i add a dataverse column lookup in table 2 (customers) that lookups in table 1 (users).

Then the power automate flow triggers when a change happens in table 2 (customers) and looks for the AccountManager value in Table 1 (users). If found, the power automate flow sets the lookup column so the relationship is created between the records.

Can i set this up in another way?

[Mira_Ghaly]

@Oskarkuus 

My understanding the purpose of the flow is to set the account manager lookup on the customers table if yes try using the below in the FilterRows as below;

_accountmanagerlookuplogicalname_value eq null

Add the null value from the expression pane.

[Oskarkuus · Accepted solution]

Yes you are corrrect.

But if i set

_accountmanagerlookuplogicalname_value eq null

in the filter

Wont that only work if the column is empty?

What about if the account manager changes from one value to another value?

then the flow wont be triggerd

EDIT:

Well i suppose i could set up another dataverse column named AccountManager_LastValue (string)

Then let the flow that updates the relationship column also put the AccountManager value in that column aswell.

Then i suppose it would work to have an filter expression

AccountManger ne AccountManger_LastValue

Would mean if a change in the sql table took place, then a new value wont match the "lastvalue" column and that would trigger the flow...

Am i correct?

If i am correct... i do not like this solution... i think it adds to much complexity to do this.

[Mira_Ghaly]

@Oskarkuus 

Yeap that would work