cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
vsslasd
Level 8

PowerApps Patch Statement Error when Trigger Enabled

Is there any remedy for this ? Trigger.png

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: PowerApps Patch Statement Error when Trigger Enabled

Hi @vsslasd

Unfortunately, PowerApps doesn't support tables with triggers. It's one of the known limitations of the SQL Connector, which is described here.

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

 

Possible workarounds are:

  • Remove the trigger from the table (which I realise isn't ideal)
  • Use a Stored Procedure and Flow instead.
  • Insert the data into a 'staging table', and create some 3rd party job to copy the data into the target table.

Here's a thread with a bit more detail
https://powerusers.microsoft.com/t5/General-Discussion/Update-SQL-Server-Table-with-trigger/td-p/102...

 

View solution in original post

Community Support Team
Community Support Team

Re: PowerApps Patch Statement Error when Trigger Enabled

Hi @vsslasd,

I agree with @timl's thought almost. It is a known limit that Insert and update to a sql table does not work if you have a SQL server side Trigger defined on the table.

Please check the following article for more details:

https://docs.microsoft.com/en-us/connectors/sql/#known-issues-and-limitations

 

Please consider take a try to remove the trigger within your SQL table, then try your Patch formula again, check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Super User
Super User

Re: PowerApps Patch Statement Error when Trigger Enabled

Hi @vsslasd

Unfortunately, PowerApps doesn't support tables with triggers. It's one of the known limitations of the SQL Connector, which is described here.

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

 

Possible workarounds are:

  • Remove the trigger from the table (which I realise isn't ideal)
  • Use a Stored Procedure and Flow instead.
  • Insert the data into a 'staging table', and create some 3rd party job to copy the data into the target table.

Here's a thread with a bit more detail
https://powerusers.microsoft.com/t5/General-Discussion/Update-SQL-Server-Table-with-trigger/td-p/102...

 

View solution in original post

Community Support Team
Community Support Team

Re: PowerApps Patch Statement Error when Trigger Enabled

Hi @vsslasd,

I agree with @timl's thought almost. It is a known limit that Insert and update to a sql table does not work if you have a SQL server side Trigger defined on the table.

Please check the following article for more details:

https://docs.microsoft.com/en-us/connectors/sql/#known-issues-and-limitations

 

Please consider take a try to remove the trigger within your SQL table, then try your Patch formula again, check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

vsslasd
Level 8

Re: PowerApps Patch Statement Error when Trigger Enabled

Thank you. Yes, it is a limitation, unfortunately.
The triggers cannot be removed.

I agree the Flow or Stored Procedure workarounds, will work.

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Demo Extravaganza Championship Voting Open

Voting Ends: October 30, 2019!

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 181 members 4,400 guests
Please welcome our newest community members: