Skip to main content

Hi,

Currently, my site workflow is struggling with Performance. Because it is using the Query Item action to query more than 5000 items in a list. After that I use the Foreach action to loop those items to do my business. But it always get failed on start (retrying) after I started workflow for 10 mins.

‌ 

anyone please let me know your solution ? I knew it is the Performance problem where I use to Query Items action. But my business have to query more than 5000 items. 

Thanks and regards,

//Tan Nguyen

you'll have to process all those items in smaller batches.

sharepoint itself (by default) limits max number of items items returned per view/query to 5000 items.


Thanks Marian Hatala,

I will try to divide into small batches and query if it works.


Reply