429 error when reading excel file

[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

[v-qiaqi-msft]

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.

[bradcurtisFl · Accepted solution]

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