Getting Error as "Failed on starting (retrying)" while looping through large SharePoint On-Prem List

  • 13 June 2022
  • 1 reply
  • 172 views

Hi There,

I have created a workflow which query list items(around 5000) from one of the list and update data in column of each item in the same list and 4 more lists(having same items) as per condition satisfied.

 

I am facing issue while looping through all the items which are queried. As per functionality workflow is working fine and updating data as expected for some amount of items but after that it fails with status as "Failed on start (retrying)".

 

Please help me to solve this issue.

 


1 reply

Userlevel 6
Badge +22

Hi,


 


The first thing you may want to try is to do the updates in batches.


In your loop add a Math operation with Mod calculation.


Next add a Run if action that checks when the Mod calculation is zero and if so pause for a minute.


 


Example will pause every 100 loops.




Pause


 

Reply