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,
Solved! Go to Solution.
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.