I currently have a site workflow that looks to List A (list of associates and order number of which they should be assigned an item. Ex - Joe Person, order number = 3; John Person, order number = 6 - if Bob Person who's order number is 5, the next item will be assigned to john Person) and updates List B with the next available associate (John Person) on the list then sends them a summary of all of the items that were assigned to them.
The workflow runs a inside of loop until no more unassigned items exist.
Inside of the loop is a for each action that queries the list for the last assigned item, gets that person that it was last assigned to then assigns the current item to the next person (via order number) on the list.
The issue is that it can take 20 minutes to loop through just 6 items and there are over 200 items that may need to be assigned DAILY. so its pretty time sensitive.
The list of associates available is currently 12, this is not a sttatic number of people and can fluctuate.
Any help would be GREATLY appreciated.
also want to add that using For Each only doesn't work because it will assign all cases to the same person. I tried adding a pause of one minute between each to give it time to catch up after pending changes but that doesn't seem to help.