When an item is modified (v2) trigger. Flow is not triggering

(0) Share

Report

Posted on by Community Power Pla...

I have a flow that connects to an SQL database. Using the Trigger - "When an item is modified (v2)".

The problem is the flow doesn't even trigger even though the:

- Server name is correct

- Database name is correct

- Table name is correct.

We have another flow that uses the same SQL trigger "When an item is modified (v2)" but for a different database and table name which does get triggered when the corresponding trigger event occurs and it works fine.

So could it be the database itself? I really need help.

Thanks

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

CU-18081211-6 9,270 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Anonymous ,

Please be aware about known issues and limitations of the SQL - When an item is modified (V2) action. Does your table meet the RowVersion column condition?

https://docs.microsoft.com/en-us/connectors/sql/

Hope it helps !

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

But I don't understand it works for our other flows which use SQL as a connect and "When an item is modified" as a trigger.
We get this error when I drill into this particular flows analytics
With error details as Bad Gateway.

Was this reply helpful? Yes No
CU-18081211-6 9,270 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Anonymous ,

Let's first solve the problem.

Can you create a rowversion column on your SQL table (use a new created one, not to alter existing data by doing something wrong) ?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report
Copy link

Link copied!

I can't edit the table or alter any information as to it's from a 3rd party company.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (2)

Report
Copy link

Link copied!

I figured it out with some research. That trigger "When an Item is modified" will only work or trigger if the SQL Table in this context has a column that could be called anything. But as a data type of "timestamp".

So In my sql table i need to add a column called anything i.e. "RowVersion" and datatype of "timestamp"

Code snippet here:

ALTER TABLE TableName
ADD ColumnName Datatype;

So for me ALTER TABLE abc
ADD RowVersion timestamp;

Was this reply helpful? Yes No