web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : kR+mgx7hy1FziWjuZr38j+
Power Platform Community / Forums / Power Automate - Building Flows / Strange limitation of ...
Power Automate - Building Flows
Answered

Strange limitation of Flow at 2048 list items

Like (1) ShareShare
ReportReport
Posted on 19 Jul 2017 17:51:51 by CivilNJ 59

We have a Flow which is pulling a table from our on-prem SQL with 2550 records yet when the Flow adds them to a clean list, it only imports 2048 records.  Has anyone ever seen this or am i missing something obvious?  Confirmed count in table, confirmed complete flush of data from list and confirmed final count after run.

 

We have tried lower counts and they work properly - i.e. 1,000 records works fine.  It doesn't seem to be timing out at about 34 minutes to run.

 

  • RPGpro Profile Picture
    RPGpro 41 on 02 Feb 2023 at 15:10:56
    Re: Strange limitation of Flow at 2048 list items
    If anyone else has a robust solution though, would love to hear it

    Make sure pagination is off, it sets a minimum record count which will mess with this process: 

    1. Create 2 variables, 1 is a boolean the other is an integer, initialise them as 0 and false. 
    2. Create a while loop which runs while the boolean is false. 
    3. Inside the loop, run get rows, set the "skip count" field as the integer you created, make sure pagination is turned off (it sets a MINIMUM return qty that will mess this up, this is why you got duplicate data when setting it to 5000). 
    4. count the number of records returned by the get rows connector, if it's 0 set the boolean to true and do nothing else. if > 0 then: 
      1. Run w/e process you want with the rows or store the data to process outside of the while loop later on. 
      2. Add the number of records to the integer, this means the next loop iteration will skip the first x rows and return the next set of data. 
    5. The loop repeats until the last record is returned. 

     

  • twhite-cfauk Profile Picture
    twhite-cfauk 9 on 23 Apr 2022 at 10:05:58
    Re: Strange limitation of Flow at 2048 list items

    I've tried this and found that with pagination on and threshold set at 5000, the connector gets the correct number of records, but ends up missing some from the original source and duplicating others instead. Very odd. After a fair bit of tinkering I've surrendered and split the data on the SQL server side into 2 views for separate import. If anyone else has a robust solution though, would love to hear it

  • Community Power Platform Member Profile Picture
    Community Power Pla... on 24 Jul 2018 at 12:53:09
    Re: Strange limitation of Flow at 2048 list items

    Hi CivilNJ,

    I have made pagination and set limitation to 10000 even tough not able to get all records

  • CivilNJ Profile Picture
    CivilNJ 59 on 20 Jul 2017 at 16:45:41
    Re: Strange limitation of Flow at 2048 list items
    I think 2048 is a default.
  • Verified answer
    CivilNJ Profile Picture
    CivilNJ 59 on 20 Jul 2017 at 16:45:02
    Re: Strange limitation of Flow at 2048 list items
    I believe I have resolved it. In the SQL Get_rows part of my flow, I went to the 3 dots and Settings. I forced PAGINATION to ON and set to max 5000. I am now getting all of my content to pull.
  • v-yamao-msft Profile Picture
    v-yamao-msft on 20 Jul 2017 at 08:35:49
    Re: Strange limitation of Flow at 2048 list items

    Hi CivilNJ,

     

    I am afraid that there might be a limitation for the records that action “get rows” could get. We are able to get the rows up to 2048.

     

    Please consider to create a request at Flow Ideas Forum to expand the total number that action “get rows” can retrieve.
    https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

     

    Best regards,
    Mabel Mao

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

News and Announcements

Welcome to the Power Platform Communities
Announcing our 2025 Season 2 Super Users!

Quick Links

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans