Hi guys,
I can successfuly get flow to insert a row into one of my SQL tables. Now the issue I have is that I need to set up a trigger on this table to get the same data sent pover to a different table on a different Server.
Since implementing the trigger Flow will not insert into the original table:
error:
"status": 400,
"message": "Invalid Mashup Expression using supplied values.\r\n inner exception: Microsoft SQL: The target table 'dbo.TABLE' of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause.",
"source": "sqlconnectionprovider-westeurope.am2-ase-001.p.azurewebsites.net"
Is there any way around this please?
For the error I suspect that the SQL Flow generates in the back end to get the data into my table is the issue by not using the into clause when using the output clause?
many thanks
Lee
Lee,
You are right! This is a current limitation on the SQL connector that updating a row do not work when the SQL Table has a SQL Trigger defined on it. While we have plans on fixing this, we don't have a timeline yet.
There is no workaround for this today w/o making changes anything on the SQL side.
The feasible workarounds you can do are:
(1) Use a stored procedure
(2) Remove the trigger from your SQL Table
Obviously, (1) is the preferred method. Let know if that works.
Thanks!
Sameer
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2