Answered

429 error when reading excel file

(0) Share

Report

Posted on by bradcurtisFl

Hi,

I am getting a 429 error when I read an excel file from power automate. The excel file has 4,890 line items. The power automate only reads 4096 items then gets the 429 error. It re-tries 2 times then only uses the 4096 items and completes.

I would have expected the flow to fail but it succeeded. Is there anyway to throttle the excel read or read it all at once?'

thx

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @bradcurtisFl,

Runtime error 429 is an error that causes the program, which we are using currently, to shut down suddenly. It is mainly caused due to memory issue/computer threats / conflict between software’s or registry problems.

When you find the 429 error messages in Microsoft Flow you will find that the issue is the "Rate limit exceeded. Try again in X seconds".

Error handling in this case is no real help as all we can do is make things worse by calling more SharePoint API calls.

There is an easy way around this problem. Imagine you have a flow that triggers on updates and you are updating a field within the triggering item.

Was this reply helpful? Yes No
Verified answer

bradcurtisFl 15 on at

Like (0)

Report
Copy link

Link copied!

We found the problem. The amount of rows in the excel file exceeded some sort of limit. We had about 5k rows in the file. When we implemented pagination when we retrieved the rows, the error went away.

When we are gathering rows in an excel file does the connector make separate web service calls for each row? Or does it gather all the data and create the structure within the power automate process.

It almost seems like excel is acting like a sharepoint list

Was this reply helpful? Yes No
Tushar_Soni 2 on at

Like (0)

Report
Copy link

Link copied!

@bradcurtisFl Can you please explain how you implemented pagination while retrieving the rows?

Was this reply helpful? Yes No