Hi Everyone,
I am working on creating/updating multiple records (over 50 rows) in SharePoint using Power Apps.
However, I've encountered performance issues and occasional errors when dealing with large numbers of records.
The error message I see is:
"Network error when using the Patch function: An error occurred on the server."
I create a collection to save all records that need to change.
base on https://www.matthewdevaney.com/patch-multiple-records-in-power-apps-10x-faster/
Then patch the collection directly.
Patch(datasource, collection);
I used the monitor to check the patch request and noticed that the duration increases significantly with more records. Currently, patching 30 records takes approximately 30694ms, which is very slow.
Any suggestions or tips to improve this process would be greatly appreciated.
Thank you for your help!