Hi,
I'm having difficulty attempting to combine and evaluate multi-values in a For Each Value. I'm on Workflow version 11.0.2102.264, if that helps.
What I am trying to do:
Search in a specific folder inside the repository for forms and then pull multivalued fields attached to each form: equipment ID, Outcome, Date. For each found form, I want to retrieve the values and tie them together so I can evaluate whether the equipment needs to be reviewed inside a For Each Entry.
I.E.
Form 1 contains:
Equipment IDs: 1, 2, 3, 4
Outcome: Passed, Passed, Failed, Passed
Date: 1/x/xx, 2/x/xx, 3/x/xx, 4/x/xx
I want to have it to where for each value, it checks it like this:
1 Passed 1/x/xx
2 Passed 2/x/xx
3 Failed 3/x/xx
4 Passed 4/x/xx
This way I can have a conditional added that says if it contains Passed, added to variable( List of Devices to Review)
I'm fine up until the For Each Value part.
I've tried adding the values in the Fore Each Value like this:
%(Equipment) - %(Outcome) - %(Date)
I've also tried this suggestion:
https://answers.laserfiche.com/questions/153710/How-to-merge-3-multivalued-fields-into-1-single-multivalued-filed
For this example, I either end up with 1 returned iteration[%(Equipment) - %(Outcome) - %(Date)].
I get 12 iterations with each value being considered independent if I set it to values like above.
Below is the workflow. I'm using the Date Token Calculator to find forms submitted a year ago and only use it in the Search Repository section.