
Announcements
Hello, everyone, this is my first time using Power Apps, and I was inserting records in a table called "Ventas" but I needed a sql trigger, so I created it, but after that, I tried to insert a record on "Ventas" again, to see if the trigger would work as it should, but my app stopped working, and It shows me an error that says: "network error when using patch function the requested operation is invalid"
The trigger works fine, I tested in on a SQL query.
I'd appreciate your help with this ❤️
Hi @AndyVela
Unfortunately, the SQL server connector does not support tables with triggers, as highlighted in the documentation.
Therefore, you would need to remove to trigger in order to write to the table.
https://learn.microsoft.com/en-us/connectors/sql/