MSSQL Tables that have triggers on update/ insert currently fail when a PATCH or UPDATE/IF operation is applied.
UpdateIf( , Patch( :
MSSQL Error: The target table 'xxxxxxxx' of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause.
This is due to the generated SQL statement the Powerapps MSSQL connector is generating for these functions. Please reference https://stackoverflow.com/questions/13198476/cannot-use-update-with-output-clause-when-a-trigger-is-...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.