Skip to main content

Notifications

Power Automate - Using Connectors
Answered

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

(12) ShareShare
ReportReport
Posted on by 1,387

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
    powerpritish 15 on at
    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
    ChadVKealey 1,387 on at
    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.

  • 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
    antc 34 on at
    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
    Pavel48n0sh 87 on at
    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
    km3000 9 on at
    Re: Excel (Business) - List rows present in a table: 256 row limit, any way around it?

    Worked perfectly. Thank you!

  • Deltodeus Profile Picture
    Deltodeus 80 on at
    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
    KrishnaV 5,023 on at
    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

     

  • 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
    KrishnaV 5,023 on at
    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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard

Featured topics