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
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Users online (2,388)