Hello everyone,
I have an application that writes batches of rows to a dataverse table. For the past ~7 months, I have not had an issue with the code below:
ForAll(
CollectionSplit As Split,
Patch(datasource,FirstN(SortByColumns(ShowColumns(Filter(collection,Updated = true),
"recordid","columns",...), "cr1c1_field", Split.Sort),Split.RecordCount));
//Removes records from collection to prevent overwriting.
Remove(Collection,FirstN(SortByColumns(Filter(Collection,Updated = true),"cr1c1_field",
Split.Sort),Split.RecordCount))
);
The collection I am using as a source for patching the dataverse table has anywhere from 40-150 rows in it. I ran into 429 errors when I would do Patch(datasource,collection). Instead, I decided to break up the patch into 4 operations using the 'CollectionSplit' collection. This resolved the 429s and everything was working great until 4/26. All of the sudden, 429 errors ran rampant and now the app is almost unusable.
I've tried increasing the amount of batches to 6, I've tried doing a ForAll for each record. Interestingly, the ForAll for each record is faster somehow and still results in 429s.
I have read up on The API limits, Service protection API limits (Microsoft Dataverse) - Power Apps | Microsoft Docs, but unfortunately, PowerApps doesn't have a ton of diagnostic capability. The Monitor doesn't even show the error.
Does anyone have any thoughts on why this suddenly happened, what I can do and/or how I can get more information about what's going on internally in PowerApps?
User | Count |
---|---|
24 | |
4 | |
4 | |
4 | |
3 |
User | Count |
---|---|
26 | |
10 | |
9 | |
9 | |
7 |