Unanswered

List rows present in table only returning two rows

(0) Share

Report

Posted on by Novice4

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,

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sundeep_Malik 6,484 on at

Like (0)

Report

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??

Was this reply helpful? Yes No
Novice4 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No