Power Platform Community Forum Thread Details

So I'm making an app in Power apps that is working with multiple tables within an Azure SQL Server. There are about 5 different tables that the app is using and before this week there hasn't been a problem with any of them. Then this week I started testing some things and the main list, let's call it head, just stopped letting me patch to it from within power apps. It would give me an error that said "Network error when using Patch Function: An error occurred on the server" I tried refreshing the database, deleting and re-adding it, deleting my connection to the SQL server entirely from my Power Apps account, and reconnecting it and none of that worked. I also tried having a friend log into their account and try the app, but that didn't work. We then both made a new app, connected it to the SQL server, and tried to patch it. That didn't work either. I can still edit it from within SSMS, but not within power apps at all. We can still get data from it, so the app still shows all the data inside the tables and updates when I edit info from the SSMS. I tried using a form and using "Submit Form" but that also just gave me the same patch error as earlier. Any help would be appreciated, i could probably just make a new table and remake the head table since this isn't in production yet, but I'd really prefer to fix this bug and know what happened rather than just restart it.

Categories:

Building Power Apps