cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Reigningfear
Advocate IV
Advocate IV

ForAll Now generating 429 Errors (52 concurrent requests) for users

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. 

Reigningfear_0-1651743795320.png

 



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?

0 REPLIES 0

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (1,913)