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.)
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.