Answered

When an item is modified (V2) does not get triggered

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

When a row is inserted or modified, the "When an item is modified (V2)" does not get triggered. I followed other related post to add a timestamp in the SQL table, but the table already has the "LastUpdatedDate" column, an example of that column would be "2021-01-15 23:34:09.3898013".

The idea is I want to have when a row gets modified in a SQL table, runs the procedure.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

CU-18081211-6 9,270 Moderator on at

Like (3)

Report
Copy link

Link copied!
Hi @Anonymous ,

When invoking triggers, SQL connector in PowerAutomate have the following limitations:

A ROWVERSION column is required for OnUpdatedItems

An IDENTITY column is required for OnNewItems

I guess that you don't have a RowVersion Column in your SQL table and that's why the trigger won't start.

References:

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

Hope it helps !

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

Like (0)

Report
Copy link

Link copied!

Thanks for your reply, it works successfully now.

Was this reply helpful? Yes No
RupeshAragonda 2 on at

Like (0)

Report
Copy link

Link copied!

A ROWVERSION column is required to work use below query to create
alter table persons
add VersionStamp rowversion

Was this reply helpful? Yes No
prteotia Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Solution: Add a column of datatype rowversion in the sql table.
For example
Column name: VerCol
Datatype: rowversion

Again connect the sql and modify data (Request Status) in the row. Flow started working.

See here for details : https://learn.microsoft.com/en-us/connectors/sql/#known-issues-and-limitations-with-triggers

Was this reply helpful? Yes No