Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

List rows present in table only returning two rows

(0) ShareShare
ReportReport
Posted on by 2

I am using the list rows present in table to get data and push it to a SharePoint site.  When the command runs it is only returning the top two rows of the Excel table.  The table is located on OneDrive.  When I run the flow in the test environment and look at the raw data output it only shows the top two lines of data as well.  I have looked through the sites and see a number of issues with this action but it all relates to greater then 256 rows.  I have also tried increasing my pagination to 5000 and tried it at its default value with no success in getting the additional data.  Any help would be appreciated.  I have attached a picture of the connector below.

 

Flow Details.png

 

Thank you in advance,

  • Novice4 Profile Picture
    2 on at
    Re: List rows present in table only returning two rows

    Excel.png

    Thank you for the response.  The data does show in the table.  I am trying to add new items. by bringing in the data from the table and then comparing to SP to only add new data.  Perhaps I am overcomplicating this.

  • Sundeep_Malik Profile Picture
    6,482 on at
    Re: List rows present in table only returning two rows

    Hey @Novice4 

    I hope all your values are in the table. Sometimes when I create a table in excel and add new rows, it doesn't add in the table and Power Automate is not able to read it. Just check that, if it's the same in your case or not.

     

    Just a doubt, this has no effect on the current result of your flow. But you said you are taking data from excel and passing to SP List, so why have you use get items??

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1