web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / One SQL table cant be ...
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:
I have the same question (0)

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 380 Most Valuable Professional

#2
Kalathiya Profile Picture

Kalathiya 340

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 333 Super User 2025 Season 2

Last 30 days Overall leaderboard