cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Nintex Newbie

Run Site workflow in batches

Jump to solution

HI There, 

i have 15K items in the list and have a Site workflow to run against themt o change some metadata. I would like this to run in btaches, so say 100 at one time? how can i approach this?

 

please advise?

Labels: (1)
Tags (3)
0 Kudos
Reply
7 Replies
Highlighted
Nintex Employee
Nintex Employee

Re: Run Site workflow in batches

Jump to solution

Hi,

It sounds like you are looping through your 15K items.

You could add the following to your workflow to pause every 100 items.

BatchWF.png

 

Math operation looks at the loop count and divides it by 100.

Math.png

If the calculation has zero remainder then the run If will run.

RunIf0.png

 

 

View solution in original post

Reply
Highlighted
Nintex Newbie

Re: Run Site workflow in batches

Jump to solution

thanks for your message, i am new to nintex so can you please advise where to place these actions, before query list or after and what will be the type of loopcount and calculation variables? please advise? 

 

my workflow screenshots are attached. 

 

thanks 

0 Kudos
Reply
Nintex Newbie

Re: Run Site workflow in batches

Jump to solution
It would also be better to target id 1-100 at one time as this workflow will run for ages?
If user can direct the workflow to pick up id 1-100 at one time and than the next lot and than next.
What do you recommend? Thanks
0 Kudos
Reply
Highlighted
Nintex Employee
Nintex Employee

Re: Run Site workflow in batches

Jump to solution
Hi,

Hard to point you in the right direction based on a bunch of random pictures of your screen. Basically the actions I suggest would go at the end of your for each loop. The variables would be of type number as they will be holding a number.
0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Run Site workflow in batches

Jump to solution
great thanks. i will give this a try but will that mean the workflow will be running until all the item have been updated?
0 Kudos
Reply
Highlighted
Nintex Employee
Nintex Employee

Re: Run Site workflow in batches

Jump to solution
Yes the workflow will run until all will be updated.
If this is not desired you could record the last item id that was processed and then start the workflow again quering from the next item ID. This may not work as it will look like a recursive workflow to SharePoint.
You could maybe use a parent child workflow to avoid the recursive workflow issue.

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Run Site workflow in batches

Jump to solution

Thanks, i am trying to get start IDs and end id in the start of the workflow but it runs find for smaller chunks not for larger number. 

0 Kudos
Reply