How to resolve threshold error?

[Anonymous]

All of sudden, I am getting below error in the flow.

Spoiler

Number of write requests for identity '3acffbad-b43e-4d4d-1da4c070ff01' exceeded the limit of '1000' over time window of '00:05:00'.

How can I resolve this error? I am getting this error in all the actions of my flow which tries to update the SharePoint List.

[manuelstgomes]

Hi @Anonymous 

You're hitting a threshold:

https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/api-limits#service-protection-api-limit-errors-returned

Microsoft recommends the following (quoting from the website):

• Decreasing the total number of records that can be selected in a list. If the number of items displayed in a list is reduced to 50, the user would need to perform this operation 120 times within 300 seconds. The user would have to complete the operation on each list within 2.5 seconds.
• Combine the selected operations into a batch. A batch can contain up to 1000 operations and will avoid the number of requests limit. However, you will need to be prepared for the execution time limit.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

[v-harkaur]

The threshold error is based on the throttling limit set on the number of API request per minute/day. The default limit is 5000 if the limit is crossed because flow carries number of tasks the threshold error appears.  To fix this error:

1. Enable Concurrency control - To run number of instances in parallel. For example, in the screenshot below, I have set the degree to 1 which means that at any given time there will only be once instance of the flow running and all consecutive runs will be put on the wait list.

2. Enable Custom Retry Policy - In some cases, where single flow run instance create threshold error. Custom retry policy can be set that will wait for defined time before making a call to API. As shown in the screenshot below, I have modified the retry policy from default (4 retries) to 20 retries and each retry should wait for 60 seconds before making the API call. The number of retries and the interval can be customized as well.