Hello everyone!

I am creating an approval form where the approvers will need to be loaded from a list or set of lists based on 2 pieces of information, Department and Region.

The method I'm currently using is to have a workflow initialize the form after it's been saved, and fill in that information.

I've got a Switch case for each Department (21) and then 5 "If region = X" on the inside of each switch.  Inside each If, is 7 set fields.

21 * 5 * 7 = 735 set field actions

I actually can't publish this workflow while it is this large.  I get an error. (Server was unable to process request. ---> Failed to publish workflow: Error in the application.)

I don't believe this is the best way to do this anyway,  should I be trying to load this data in at run-time via JavaScript?

Is there a better way to perform this action in Nintex Workflow?

I tried Parallel actions as well as the switch function, but it ultimately leads to the same thing.  An enormous unpublishable workflow.

Right now I'm thinking about creating 5 more workflows based on region, then using a switch to call the workflow that corresponds to the region and then have a workflow with only 147 set fields since I would have 21 cases (possible departments) each with 7 fields to set.

I feel like maybe I've approached this wrong, any assistance is greatly appreciated.

Thanks,

Greg