Skip to main content
Nintex Community Menu Bar

Nintex workflow Online Query list action - threshold issue

  • February 17, 2022
  • 2 replies
  • 150 views

Forum|alt.badge.img

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

 

 

2 replies

MillaZ
Nintex Employee
Forum|alt.badge.img+22
  • Nintex Employee
  • February 21, 2022

Hi @Jake 

Any chance you would know how to do this?


Jake
Forum|alt.badge.img+13
  • Scholar
  • February 21, 2022

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