web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Flow using SQL "Get Ro...
Power Automate
Unanswered

Flow using SQL "Get Rows" - workarounds to avoid the row limit issue?

(1) ShareShare
ReportReport
Posted on by 175

Hi all,

 

I have a conceptual question for the community here. For background, here is a layout of a flow that I am working on:

 

  1. Trigger: When a file is created in a folder (This is an Excel file)
  2. Get that file content and store it.
  3. Get items from SQL Server table.
  4. If there are rows in the Excel file content that do not exist in the SQL Server table, insert said rows into the SQL table. 

 

To execute this task, I am using a series of loops and conditional statements. All works fine except for one thing: I am limited to 5000 rows when using the "Get Items" action for SQL Server. Is there any way to get around this? Can I utilize a stored procedure to do this task instead? 

 

I am unsure of how to proceed and would love to hear any ideas from the group. 

 

Thanks, 

Farhan

Categories:
I have the same question (0)
  • karan551 Profile Picture
    3 on at

    I'm facing the same issue. I have made a flow before 6 months where i have set pagination limit to 100000 at that time it was allowed. Now if im trying to change anything in the flow, i'm not being allowed to save and i get an error saying "Pagination limit is 5000" I have spent weeks designing this complex flow and now i'm at a dead end. this makes the flow unusable for me. Please help.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 239 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 177 Super User 2026 Season 1

#3
Kalathiya Profile Picture

Kalathiya 97 Super User 2026 Season 1

Last 30 days Overall leaderboard