Announcements
Hi,I'm trying to patch records to multiple tables present in sql server, The patch works fine when limted number of users use the app but when the user number grows and users simultaneously run the patch, powerapps throws Server error [Request operation failed].Why this issue occurs and how do I solve it.
Thank you.
I think we need more details about the error beyond Request Operation Failed.
Do you have more details from the error message beyond Request Operation Failed?
Were 2 people trying to save the same record at the same time?
Does the error occur to all users (in which case it's potentially a lock issue) or just one user of the users (in which case it's a conflict issue as they update a record that has already been updated).
We did test it with 20 users and around 5-6 got the Request operation is invalid Server Response when users trying to insert new records to the table. Here[collector_collection] is the table name.
So it's an issue with new records which means the issue isn't with updates so it's not a context or similar issue and may well be at the database level rather than elsewhere.
What is the SQL server instance you are using and how many DTUs (see https://docs.microsoft.com/en-gb/azure/azure-sql/database/purchasing-models#understanding-dtus) does it have assuming its inside Azure. As I suspect that may be the issue you are seeing..
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 541
WarrenBelz 434 Most Valuable Professional
Valantis 289
