Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Increase limit to 5000 from get rows or list rows present in a table

(0) ShareShare
ReportReport
Posted on by 2

Dear Microsoft,

 

Can you please increase the number of rows you can retrieve with one of the Excel connectors from SharePoint and Onedrive to a proper number?

 

It has been increased (for onedrive at least) to 2048 rows but it feels underwhelming and not logical as, for example, a for each can process 5000 lines.

 

My question is to at least increase the limit to 5000 as most Excel files contain many many lines on which you want to do certain operations.

 

Thanks in advance!

 

With kind regards,

 

Joseph

  • Verified answer
    v-yamao-msft Profile Picture
    v-yamao-msft on at
    Re: Increase limit to 5000 from get rows or list rows present in a table

    Hi @BEND-Arriva,

     

    I saw you have post an idea at here:

    https://powerusers.microsoft.com/t5/Flow-Ideas/Increase-the-number-of-rows-you-can-retrieve-with-one-of-the/idi-p/144249

     

    Thanks for your understanding and cooperation. I will suggest other customers who have the same request to vote your idea. PGs will take hot ideas into consideration first in the future releases.

     

     

    Best regards,

    Mabel Mao

  • Verified answer
    ScottShearer Profile Picture
    ScottShearer 25,150 on at
    Re: Increase limit to 5000 from get rows or list rows present in a table

    @BEND-Arriva- you might want to post this in the Flows Ideas area rather than here.  That way, people can "vote" for the idea - the more votes the better the chance of having your idea implemented.

     

    Scott

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,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard

Featured topics