Not able to insert a row using SQL Server Insert Row connector

(0) Share

Report

Posted on by Poweruser32490

144

I am unable to insert a row using SQL Server Insert Row connector. It throws below error. May i know how to solve this?

Microsoft SQL: The target table 'dbo.XXXXXXX' of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause.
inner exception: Microsoft SQL: The target table 'dbo.XXXXXXX' of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause.

If we cannot use Insert Row in this scenario, any alternatives would be helpful.

Categories:

AI Builder

Process mining

Connector development

Building flows

Power Automate Desktop

Power Automate Mobile App

Translation quality feedback

Using flows

General topics

Using connectors

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

MS.Ragavendar 7,613 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

@Poweruser32490,

A limitation of the SQL Server connector is that it doesn't support tables with triggers.

As the documentation here states, a workaround is to use a stored procedure instead.

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

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No
Suggested answer

11manish 3,849 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

The most reliable and commonly recommended solution is to move the insert logic into a SQL stored procedure and call it from Power Automate using Execute Stored Procedure (V2). This avoids the connector limitation while preserving your existing SQL triggers.
this is a SQL Server limitation when using OUTPUT with tables that have enabled triggers, not a bug in Power Automate. A stored procedure is typically the best long-term solution.

Was this reply helpful? Yes No
MS.Ragavendar 7,613 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

@Poweruser32490,

A quick follow-up to see, does the suggestion worked for you or still you were looking for any other approaches or assistance.

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No