Action Limitations (Executions)

Like (0) Share

Report

Posted on 18 May 2024 06:16:34 by JJD2

Hi, I'm receiving the error "Your flow is executing an excessive number of actions per day and reached 80% of the Power Platform request limit. If the usage grows, further actions may be throttled or slowed down"

I have 28 actions. So nothing excessive. But naturally i have a "Apply to each" action. This loops through a large JSON response from a previous action, it then inserts each record/row into a SQL table. There are thousands of rows. So i'd assume that the loop/for each of the action is being counted towards the action run limitations. I'm on the free/trial option for now, but i do have a work license i just prefer using my own tenant that isn't tainted by anyone else.

Is there a better way of inserting thousands of rows into a SQL table every night?

All responses (1)

Answers (0)

lbendlin 8,111 Super User 2025 Season 2 on 18 May 2024 at 19:34:15

Like (0)

Report

Re: Action Limitations (Executions)

Create a stored procedure on your SQL server that can accept an array of values and can do the inserts for you.