Power Platform Community Forum Thread Details

Flow stucks when it comes to batch create rows in excel; The request failed with status code of 429

Hello Community,

I built a flow using a template for batch creating rows in excel. ~1 000 rows in every 15 minutes.

I keep getting the following error message when the flow reaches batch create action in excel;

We were unable to run the script. Please try again.
Office JS error: Line 2: {"message":"The request failed with status code of 429, error code tooManyRequestsUncategorized and the following error message: The client app or user has been throttled. Please try your request again after the cooldown duration specified by Retry-After header. Refer to https://docs.microsoft.com/graph/workbook-best-practice#reduce-throttling-errors for best practices to reduce throttling.","code":"tooManyRequestsUncategorized","type":"Workbook","method":"getWorksheet","line":2}
clientRequestId: 9487a055-d430-4341-9577-c45e1c23660d

I have spent tens of hours researching related this topic, already tried using 'Retry Policy' in various ways, using delays between actions etc., but no success.

Also note I have Premium license, so I could not imagine that I reached daily API limit

Could you please someone help me out?

Thank you in advance!

Regards,

Zsolt

Categories:

Business Process Flows

Licensing

Quick Links

Leaderboard