Divide items evenly and update in groups

  • 28 July 2021
  • 1 reply
  • 3 views
N
Badge +8

Hi All, 

 

I'm trying to get a workflow together that will query a large list of items, divide them evenly among a number of people that may vary (there is another list that sets a persons status as to whether they will receive anything that day) and "assign" the items to them.

 

I have a list workflow that assigns one item, then starts the workflow on the next item but that is taking forever. 

 

Is there a way to do it as a site workflow that will query all of items, divide them and only assign those to person one, then do the same for everyone else? 

 

 

1 reply

J
Badge +7

Tough one! Would something like this work?


 


ItemCollection = the items


ItemCount = the number of items in the collection


ItemIndex = pointer indicating which item is being handled


UnusedItem = variable that holds an item that won't be used


Item = variable that holds an item that will be used


 


UserCollection = the users


 


Set ItemIndex to 0 (the first item)


 


For Each Item in ItemCollection (sets UnusedItem; terminate if ItemIndex >= ItemCount)


  ForEach User in UserCollection (terminate if ItemIndex >= ItemCount)


    If ItemIndex < ItemCount


      Collection Operation > set Item = the item in ItemCollection at index "ItemIndex"
      Assign Item to User


      ItemIndex = ItemIndex + 1


  Next User


Next Item


 


 

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings