Skip to main content

Notifications

Community site session details
Power Automate - Using Connectors
Answered

Excel (Business) - List rows present in a table: 256 row limit, any way around it?

Like (12) ShareShare
ReportReport
Posted on 16 May 2018 20:33:33 by 1,393

I know with some of the other Excel "get rows" or "get tables" actions, there is a "Maximum Get Count" property that can be increased to 2048. However, the "List rows present in a table (Preview)" action does not have that property. There is a "Top Count" property, which I've set to 2048 (see below), but the Flow I'm using is still only getting 256 rows from the file. In this file, there are typically going to be 1,000 or fewer rows, so this would be an ideal solution if I could get around the 256-row limit. Any help would be appreciated.

2018-05-16_16-25-31.png

  • powerpritish Profile Picture
    15 on 16 Apr 2024 at 15:27:39
    Re: Excel (Business) - List rows present in a table: 256 row limit, any way around it?

    @KrishnaV  Paul Muran shows a way to upload batch entries to sharepoint which willy significantly reduce time.

    https://www.youtube.com/watch?v=2dV7fI4GUYU&t=135s&ab_channel=PaulMurana

    https://www.tachytelic.net/2021/06/power-automate-flow-batch-create-sharepoint-list-items/

     

  • ChadVKealey Profile Picture
    1,393 on 03 Apr 2023 at 17:34:40
    Re: Excel (Business) - List rows present in a table: 256 row limit, any way around it?

    Probably not use Power Automate. There are more efficient ways to process that amount of data. Which you use depends on what you want/need to do with it.

  • Community Power Platform Member Profile Picture
    on 03 Apr 2023 at 14:41:36
    Re: Excel (Business) - List rows present in a table: 256 row limit, any way around it?

    What if we have more than 10,000 records in excel. What we have to do?

  • antc Profile Picture
    34 on 26 Oct 2022 at 02:33:31
    Re: Excel (Business) - List rows present in a table: 256 row limit, any way around it?

    Speed it up on your "Apply to each Loop"

     

    antc2_0-1666751566753.png

     

  • Pavel48n0sh Profile Picture
    87 on 15 Sep 2022 at 11:09:42
    Re: Excel (Business) - List rows present in a table: 256 row limit, any way around it?

    Hi! My task is much more difficult. More than 16 thousand rows to process.
    Screenshot_373.png
    It's been 1 hour and I'm still waiting...
    I think it should be possible to break it down into sub-cycles in order to go through 500 rows first and get the result, then another 500, and so on.

  • km3000 Profile Picture
    9 on 11 Jun 2022 at 22:52:22
    Re: Excel (Business) - List rows present in a table: 256 row limit, any way around it?

    Worked perfectly. Thank you!

  • Deltodeus Profile Picture
    80 on 10 Jan 2022 at 02:54:42
    Re: Excel (Business) - List rows present in a table: 256 row limit, any way around it?

    how long it took to process 3500 rows in excel? 

  • KrishnaV Profile Picture
    5,023 on 24 Aug 2020 at 15:20:52
    Re: Excel (Business) - List rows present in a table: 256 row limit, any way around it?

    Hi @Anonymous,

     

    Follow this article you will come to know more insight on Flow and its limitations:
    https://docs.microsoft.com/en-us/power-automate/limits-and-config

     

  • Community Power Platform Member Profile Picture
    on 24 Aug 2020 at 15:17:20
    Re: Excel (Business) - List rows present in a table: 256 row limit, any way around it?

    Is there a way Microsoft can make limits like this more easily KNOWN? These things are not obvious. The Flow runs happily through 256 items and there's no warning -- nothing. We only found out after a significant business impact was detected.

  • KrishnaV Profile Picture
    5,023 on 05 Apr 2020 at 02:53:27
    Re: Excel (Business) - List rows present in a table: 256 row limit, any way around it?

    Just to be more precise it took 52 min for populating 5470 records from excel to Sharepoint after I change the pagination from 256 to 3500 đꙂ

     

    Regards,

    Krishna

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,743 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,079 Most Valuable Professional

Leaderboard

Featured topics

Loading started
Loading started