I am trying to use the Workflow Assign Field Value activity to update Field Groups. The group has 3 fields and only 2 will have a value. I have a loop to populate the field group multiple times. The workflow completes without any errors, but when you go in and view the metadata on the document, the fields are not matching up properly because when the Date value is null, it is not placing a null placeholder in the multivalue date field.
Field Group on template
-Field A (String)
-Field B (String)
-Field C (Date)
Say I have 3 groupings of
-Field A = Value 1
-Field B = Value 2
-Field C = Nothing
-Field A = Value 3
-Field B = Nothing
-Field C = Value 4
-Field A = Value 5
-Field B = Value 6
-Field C = Nothing
We end up with this on the document
-Field A = Value 1
-Field B = Value 2
-Field C = Value 4
-Field A = Value 3
-Field B = Nothing
-Field C = Nothing
-Field A = Value 5
-Field B = Value 6
-Field C = Nothing
How are we to apply dates in the Field Groups in workflow so they end up in the proper groupings?
In my Workflow, I create tokens (A, B, & C) and populate the values from a lookup, but either B or C will be null. Then in the assign Fields, I append value to each of the 3 fields and set them to the token values.