cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Workflow run and always Workflow failed on start (retrying) when use Query Items action with more than 5000 items

Jump to solution

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

0 Kudos
Reply
2 Replies
Workflow Hero

Re: Workflow run and always Workflow failed on start (retrying) when use Query Items action with more than 5000 items

Jump 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.

0 Kudos
Reply
Workflow Hero

Re: Workflow run and always Workflow failed on start (retrying) when use Query Items action with more than 5000 items

Jump to solution

Thanks Marian Hatala,

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

0 Kudos
Reply