Workflow based on multi choice list

%3CLINGO-SUB%20id%3D%22lingo-sub-363023%22%20slang%3D%22en-US%22%3EWorkflow%20based%20on%20multi%20choice%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-363023%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20workflow%20in%20SPD%202010.%26nbsp%3B%20I%20have%20an%20Infopath%202013%20form%20for%20a%20sharepoint%202013%20list.%26nbsp%3B%20The%20form%20has%20a%20multi-choice%20list%20with%20six%20departments.%20Each%20department%20that%20is%20selected%20revels%20a%20hidden%20section%20with%20it's%20own%20set%20of%20fields%20to%20be%20filled%20in%20by%20a%20user.%26nbsp%3B%20For%20example%2C%20one%20of%20the%20fields%20in%20each%20hidden%20section%20is%20a%20date%20field%20showing%20when%20the%20work%20in%20that%20section%20was%20completed.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20workflow%20would%20auto%20populate%20a%20completion%20date%20for%20the%20form%20once%20all%20the%20selected%20departments'%20%22date%20complete%22%20fields%20where%20entered.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20someone%20point%20me%20in%20the%20right%20direction%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-363023%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Designer%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-363796%22%20slang%3D%22en-US%22%3ERe%3A%20Workflow%20based%20on%20multi%20choice%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-363796%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20Tim.%26nbsp%3B%20I'm%20now%20trying%20to%20get%20this%20done%20in%20Infopath.%26nbsp%3B%20However%2C%20I%20cannot%20figure%20out%20how%20get%20the%20form%20completion%20date%20to%20auto-populate%20once%20each%20of%20the%20individual%20groups%20have%20filled%20in%20their%20respective%20completion%20dates.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOnce%20submitted%20the%20multi-choice%20field%20output%20looks%20like%20this%20-%20DepartmentA%2CDepartmentB%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20another%20field%20titled%20Divisions_Hidden%20that%20a%20workflow%20populates%20when%20an%20item%20is%20created%20or%20changed.%20I%20selected%20in%20the%20%22Return%20field%20as%22%20option%20%22Choices%2C%20Comma%20Delimited%22.%20I%20get%20the%20following%20output%20-%26nbsp%3B%20%26nbsp%3B%20DepartmentA%2CDepartmentB%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20where%20I%20get%20stuck.%26nbsp%3B%20How%20can%20I%20make%20the%20form%20recognize%20that%20once%20the%20two%20required%20departments%20populate%20their%20respective%20%22Completion%20Dates%22%2C%20the%20form%20is%20completed%20and%20to%20assign%20the%20form%20a%20completion%20date%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-363371%22%20slang%3D%22en-US%22%3ERe%3A%20Workflow%20based%20on%20multi%20choice%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-363371%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20not%20recommend%20doing%20this%20in%20the%20worklfow.%20Do%20it%20in%20the%20InfoPath%20form%20with%20OnChange%20event's%20attached%20to%20the%20fields%20that%20need%20to%20filled%20out%20with%20logic%20checking%20to%20ensure%20they%20are%20not%20blank.%20Doing%20it%20in%20the%20workflow%20would%20require%20the%20workflow%20to%20be%20run%20when%20the%20item%20changes%20and%20that%20will%20require%20you%20to%20code%20the%20workflow%20to%20check%20(I'm%20going%20to%20guess)%20a%20whole%20bunch%20of%20other%20business%20logic%20conditions.%20Also%20change%20based%20workflow%20tend%20to%20trigger%20a%20lot%20and%20you'll%20see%20that%20in%20your%20logs%20behind%20the%20scenes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20are%20going%20to%20do%20this%20in%20workflow%20-%20break%20down%20the%20different%20form%20areas%20into%20Custom%20Tasks%20-%20get%20all%20the%20data%20via%20the%20task%20(customize%20the%20form%20for%20the%20task)%20in%20there%20and%20then%20after%20the%20task%20is%20marked%20as%20completed%20write%20the%20complete%20set%20of%20data%20back%20to%20the%20form.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

I have a workflow in SPD 2010.  I have an Infopath 2013 form for a sharepoint 2013 list.  The form has a multi-choice list with six departments. Each department that is selected revels a hidden section with it's own set of fields to be filled in by a user.  For example, one of the fields in each hidden section is a date field showing when the work in that section was completed. 

 

The workflow would auto populate a completion date for the form once all the selected departments' "date complete" fields where entered.  

 

Could someone point me in the right direction?

 

Thanks in advance!

2 Replies

I would not recommend doing this in the worklfow. Do it in the InfoPath form with OnChange event's attached to the fields that need to filled out with logic checking to ensure they are not blank. Doing it in the workflow would require the workflow to be run when the item changes and that will require you to code the workflow to check (I'm going to guess) a whole bunch of other business logic conditions. Also change based workflow tend to trigger a lot and you'll see that in your logs behind the scenes.

 

If you are going to do this in workflow - break down the different form areas into Custom Tasks - get all the data via the task (customize the form for the task) in there and then after the task is marked as completed write the complete set of data back to the form.

Thanks Tim.  I'm now trying to get this done in Infopath.  However, I cannot figure out how get the form completion date to auto-populate once each of the individual groups have filled in their respective completion dates. 

 

Once submitted the multi-choice field output looks like this - DepartmentA,DepartmentB

 

I have another field titled Divisions_Hidden that a workflow populates when an item is created or changed. I selected in the "Return field as" option "Choices, Comma Delimited". I get the following output -    DepartmentA,DepartmentB

 

Here is where I get stuck.  How can I make the form recognize that once the two required departments populate their respective "Completion Dates", the form is completed and to assign the form a completion date?

 

Thanks for your help!