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

[bpwendy]

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.

[gabibalaban · Accepted solution]

Hi @bpwendy ,

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 !

[bpwendy]

Thanks for your reply, it works successfully now.