You are viewing limited content. For full access, please sign in.

Question

Question

How to combine multi-values into one for each value to work

asked on February 16, 2023

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.

 

0 0

Answer

APPROVED ANSWER
replied on February 24, 2023

Hello Jasciel

In your "Evaluate Each Outcome" loop, you need to use the current iteration index for each of your multivalue inputs during the Append options. The syntax for that looks a little something like this:

I just sent you an FTP link to upload the Workflow to. 

Thank you

 

 

0 0
replied on February 24, 2023

To anyone running into this issue in the future,

Braden provided the solution:
In my case, since I'm trying to determine if each value is acceptable, he just used the token (%outcome)

Inside my condition statement, what I was missing is the iteration part for the other two multi-values I was trying to evaluate at the same time:


In my email I received only the first value. To correct this, I had to go inside the token dialog, select the token-> Apply index: All values separated by: Line break(my preference)


Thanks Braden for providing the solution and looking into this for me!

0 0

Replies

replied on February 22, 2023

Hello Jasciel

Would you be able to attach the Workflow to this page? I believe I know what the issue might be but I need to see the token configurations to be sure. 

Thank you

0 0
replied on February 22, 2023

Hi I am not able to add the workflow as it's not a support format.

Here are the tokens created(Some aren't used), if this helps - 


Tokens assigned metadata all 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.