Hello Folks,
I have large sharepoint online list which has more than 18000 items, I want to query list data based on some filters, which will return more than 6000 items.
I know that Nintex query list action not work after 5000 item
Can you Please suggest any workaround to resolve this issue.
Thanks,
Sachin
+20
Hi @Jake
Any chance you would know how to do this?
+13
Hi @sachin
This is a limit set by Microsoft to ensure fair use of the system, you would need to break up the query into multiple parts. perhaps look up certain categories at a time.
For example if you had a list of every city in the world, rather than looking up every city at once giving you more than 10,000 cities, instead query by continent and merge the data in a collection.
the workflow might look a little like this:
The workflow will probably be very slow and may throttle, You may want to see if this will be quicker in NWC.
Kind regards
Jake
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
