cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bradcurtisFl
Frequent Visitor

429 error when reading excel file

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

1 ACCEPTED SOLUTION

Accepted Solutions

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

View solution in original post

2 REPLIES 2
v-qiaqi-msft
Community Support
Community Support

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.

 

Best Regards,
Qi

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

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,403)