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