We are running into very similar issues. From what I can find SQL Server limit is 100 calls per 10 seconds. We want to roll out an app to a larger number of people. The app needs to have real time data for certain values.
Did you find anything that has helper you over come these throttling limitations of PowerApps?
This is where powerapps falls over and i feel definitely needs looking at for paying customers.
The only thing i have been able to do is where i was using concurrent to process updates to multiple tables at once (reducing time for the end user) i have had to process them individually which adds about 2 minutes to the upload for me.
Since there is no 'Delay' or 'Sleep' function within commands i don't see any way to limit the rate, otherwise we could break the patch functions up and do say the first 50, wait, next 50 etc etc.. although this still doesnt solve the fact that multiple users could be executing the command together.
I already load all data into collections for processing, not viable if it has to be real time, but if a couple of users patch at the same time then its just error after error.
There has to be some form of limit to stop ddos etc but i do feel the rates need to increase significantly as if i'm getting them testing with 1 user, how do we expect to roll this out for multiple.