cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pavlamar
New Member

SQL trigger When an item is modified (V2) cannot join the table

Hi, I'm connecting manage instance with SQL trigger. When I use "When an item is created (V2)", everything's working fine. But if I use "When an item is modified (V2)", no available table in DB is offered. In both cases I use the same connection. The moment I enter a custom value, the flow crashes on error "Cannot run trigger query for table". Any suggestions, please?

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @pavlamar ,

 

Although the document shows 'A ROWVERSION or an IDENTITY column is required.' for this trigger, I found the IDENTITY can't work.

vxiaochenmsft_0-1648015333149.png

I suggest you create a rowversion column.

 

Best Regards,

Wearsky

 

 

View solution in original post

1 REPLY 1
v-xiaochen-msft
Community Support
Community Support

Hi @pavlamar ,

 

Although the document shows 'A ROWVERSION or an IDENTITY column is required.' for this trigger, I found the IDENTITY can't work.

vxiaochenmsft_0-1648015333149.png

I suggest you create a rowversion column.

 

Best Regards,

Wearsky

 

 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Top Kudoed Authors
Users online (3,220)