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.
Thank you in advance,
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.
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??
Michael E. Gernaey
497
Super User 2025 Season 1
David_MA
436
Super User 2025 Season 1
Riyaz_riz11
244
Super User 2025 Season 1