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

Excel List Rows Throttled due to Action Limit

I have a flow that is being throttled almost daily due to action limits. When I click the "Learn more about the connector's throttling limits" link in the "Error Details" section, the page it takes me to states that the limit for Excel Online (Business) is 100 Calls with a Renewal Period of 60 secs. I don't understand how my List Rows action that is pulling from a table of less than 10 rows could possibly be hitting a 100 call limit.

  • What counts as a single call?
  • How many calls would a List Rows action need for a table of less than 10 rows?
  • Is the 100 call limit per 60 secs, per day, or what?
  • If not per 60 secs what is this 60 sec "Renewal Period" mentioned in Microsoft's linked documentation?

Background: This is a reoccurring Flow that runs every 30 mins from 8am to 6:30pm. It compares the current time with a column of meeting end times in an excel table. If the meeting end time is equal to 1hr prior to the current time an email reminder is sent based off a name found in another column of the same table. A screenshot of the flow is below showing the 429 error on the List Rows action.

 

stamperadam_0-1666370187890.png

 

EDIT: I have a separate flow that also uses a List Rows action, but the table that action connects to does have A LOT of rows (over 1,500). Does the number of rows in a connected table affect the number of Calls the List Rows action requires? From what I can tell Action Limits are per user, not per Flow, so I'm wondering if this table could be what's causing the 429 error (throttling).

 

1 REPLY 1
takolota
Super User
Super User

@stamperadam 

 

List rows will consume one call/action per 5000 records it pulls.

 

But if you have multiple Excel actions creating, reading, updating, & deleting on the same connection across multiple flows, then it could be another flow’s excel actions are consuming all those units.

 

For a simple fix try clicking the 3 dots on the List rows action & create a new Excel connection just for this action.

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.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,484)