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.

Hi 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.