Hi I’m having problems executing a table from a Cdata source Sharepoint list that has exceeded 5000 rows. Do you have any tips for resolving this issue?
Best regards
Frederik
Solved
Sharepointlist +5000 rows
Best answer by Thomas Lind
Hi Frederik
I assumed it was some max value imposed by Microsoft.
I googled the error and found this.
So it states that you can turn on an index of the list in sharepoint and it will allow more than 5000 rows. It is a requirement that the table has less than 20000 when you apply this.
You can also turn on modern experience.
If you do not have access or can ask someone to apply this I have two ideas.
Try to set a batch size of 5000 in this field.
If this do not work, it is make a query that only pulls 5000 rows and then another that pulls the next 5000 rows and so forth.
+5Hi Frederik
I assumed it was some max value imposed by Microsoft.
I googled the error and found this.
So it states that you can turn on an index of the list in sharepoint and it will allow more than 5000 rows. It is a requirement that the table has less than 20000 when you apply this.
You can also turn on modern experience.
If you do not have access or can ask someone to apply this I have two ideas.
Try to set a batch size of 5000 in this field.
If this do not work, it is make a query that only pulls 5000 rows and then another that pulls the next 5000 rows and so forth.
+5Hi Frederik, can you please help us mark the best answer if you are satisfied with Thomas’ answer above?
Please let us know if you have any follow up questions.
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
