Sharepointlist +5000 rows

Hi Frederik

I assumed it was some max value imposed by Microsoft.

I googled the error and found this.

https://support.microsoft.com/en-us/office/manage-large-lists-and-libraries-b8588dae-9387-48c2-9248-c24122f07c59?ui=en-us&rs=en-us&ad=us

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.

https://support.microsoft.com/en-us/office/switch-the-default-experience-for-lists-and-libraries-from-new-or-classic-66dac24b-4177-4775-bf50-3d267318caa9

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.