Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

One SQL table cant be patched, other tables work just fine

(0) ShareShare
ReportReport
Posted on by 2

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:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard