cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chanshaw
Helper I
Helper I

Creating a flow with add a row in excel getting error status code '429' rate limit is exceeded.

The problem started when I tried to copy and paste an add a row action. Now I can no longer make this work at all. This is not a high volume flow. 

chanshaw_0-1600373062562.png

I am trying to divide one form into 13 different spread sheets for people to work with. This is the best way I know how. If anyone has a better suggestion I am all ears.

7 REPLIES 7
Jcook
Super User III
Super User III

Hello @chanshaw 

 

Which license do you have forPower Automate?

 

also could you share a screenshot of your full flow. Thanks


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





chanshaw
Helper I
Helper I

A5. I have an account owned by a whole state. So all of the flow runs are combined.

chanshaw_0-1600374165800.png

I have written many flows with add a row. Some have ran over 10k times. Never had this issue.

Hi @chanshaw 

 

You mentioned this happened when you copied and pasted the action.

Unfortunately this is a bug, could you try creating the action without using the copy paste


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





Creating action without using copy and paste helped. But I had to do this about 80 times for this flow. Even if i did it without copy paste too quickly I got error. It does not allow me to even search for the excel file. Like it will not look in my directory. This is why i do not think the excel file is the issue. The error occurs even before the excel file is selected. Thank you for all your help 

@Jcook  I tried to copy it and I get this error

chanshaw_0-1600377619585.png

 

Hi @chanshaw 

 

You are using 80 different Excel actions in the same flow? This is where the API limit is coming from.

 

Please try and split up the connections. I assume you're using the same connection for all actions. Try changing the connections on some of the actions. For example:

 

Click the 3 dots on an excel action, click +Add new connection. You can add the same connection, but make sure half of your actions use the first one and the other half use the second (Newly) created one.

Jcook_0-1600458427530.png

 


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (35,340)