Site workflow - List Items limit

Yes there is limit with number of item in list and the number of custom permission check this official link from MS : https://docs.microsoft.com/en-us/sharepoint/install/software-boundaries-and-limits#list-and-library-limits)

by default you can't query a liste with more than 5000 items.

However, if you want to query your list, you can :) (even with 30k items). You need to first index on you field that you want to filter (warning, create your index before add your items in you list).

https://support.office.com/en-us/article/manage-large-lists-and-libraries-in-sharepoint-b8588dae-9387-48c2-9248-c24122f07c59 

So after that, you can query you list with 30k items, be carefull with the custom permission (item level permission) more you have custom permission on your items, more the list will be slow.

Hi @nico , 

Thanks for the feedback.

Just wanted to confirm, I have already created index on some columns but If I want to retrieve all items without filter the query, will Nintex work flow work fine for all 30k Items (Query + Item level permissions) ? 

Thanks, 

Kalpesh  

That I don't know, I never had to get all the items in one query of a large list (more than 5k items).

You have to test it (let me know the result, I'm interesting)

I think there is some limitation, the doc of Nintex query list say : 

Maximum number of rows : Default: 100. Valid values: Any integer up to the limits of the SharePoint REST API, or empty (undefined)

https://help.nintex.com/en-US/o365/o365/O365WorkFlow/WorkflowActions-STD/QueryList.htm

And in REST API, you can't get more than 5k items in one query (you have to do query with pagination) else you will have a threshold