Answered

Rate limit is exceeded - New Restriction

(0) Share

Report

Posted on by Rene_Newbee

106

Hi

I have an app that has worked perfectly for a long time and then this morrning when starting the app it took a very long time. I then closed the app and started it again and I then got this error at the top of my app:

An error occurred on the server. Server Response: 'SharePointListName' failed: Rate limit is exceeded. Try again in 31 seconds. Please see https://docs.microsoft.com/azure/logic-apps/handle-throttling-problems-429-errors for more details.

Then this error showed up for 4 of my SharePoint Lists, at the top of my app:

The request was not sent or there was no response from the server. Check your internet connection. Server Response: 'SharePointListName' failed: null

If I open the app in edit mode then the "ants" are runing at the top for a very long time, but once in a while the app opens normally.
I have removed alle the connections to the SharePoint Lists in the app and then connected them again, but it's the same.
Nothing has changed in the app, no new functions and only a few rows has been added to the Sharepoint Lists, in the past few days.
Why do I all of a sudden get this error?

I can see that it is about the API quota limit, but nothing has changed, no new LookUp's or is it new new restrictions from Microsoft?
Hope someone can help 🤔

Regards
René

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

ANB 7,250 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Rene_Newbee , Have you checked this: https://powerusers.microsoft.com/t5/Building-Power-Apps/Error-Server-Response-Rate-limit-is-exceeded/m-p/475501
https://powerusers.microsoft.com/t5/Building-Power-Apps/Error-Server-Response-Rate-limit-is-exceeded-while-submitting/m-p/2047677

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
Verified answer

Rene_Newbee 106 on at

Like (0)

Report
Copy link

Link copied!

I found out what it is that is killing my app. It is thsi code:
ClearCollect(
colStatisticsCollection,
AddColumns(
DigiAssis_Stats,
"Tool", LookUp(DigiAssis_T, Id = TextId).Tool.Value,
"TextLanguage", LookUp(DigiAssis_T, Id = TextId).TextLanguage.Value,
"IsApproved", LookUp(DigiAssis_T, Id = TextId).IsApproved,
"Ændret", LookUp(DigiAssis_T, Id = TextId).Ændret,
"Oprettet", LookUp(DigiAssis_T, Id = TextId).Oprettet,
"LevelText", LookUp(DigiAssis_T, Id = TextId).LevelText,
"TitleFromTexts", LookUp(DigiAssis_T, Id = TextId).Title
)
);

Can I remove some of the LookUp's or simplify the code in some way?

Was this reply helpful? Yes No
ANB 7,250 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Rene_Newbee , I am not sure how this code is being used in other place, however I can suggest you that dont directly Lookup to data source, instead create global variable like this and use it accordingly:
Set(gblvar_DigiAssis_T, LookUp(DigiAssis_T, Id = TextId)); ClearCollect( colStatisticsCollection, AddColumns( DigiAssis_Stats, "Tool", gblvar_DigiAssis_T.Tool.Value, "TextLanguage", gblvar_DigiAssis_T.TextLanguage.Value, "IsApproved", gblvar_DigiAssis_T.IsApproved, "Ændret", gblvar_DigiAssis_T.Ændret, "Oprettet", gblvar_DigiAssis_T.Oprettet, "LevelText", gblvar_DigiAssis_T.LevelText, "TitleFromTexts", gblvar_DigiAssis_T.Title ) );
-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
Rene_Newbee 106 on at

Like (0)

Report
Copy link

Link copied!

Hi ANB
I solved this by patching the information, that I added to my collection, to the DigiAssis_Stats list earlier in the app. It does mean that I have two lists with almost identical content, but it solved my problem.

Was this reply helpful? Yes No