How do I display individual values from a list collector variable into an approval request email?

ubido · ‎10-18-2019

Dear folks,

I have a workflow in which users select from 1 to N values displayed in a list collector; I have a requirement that each value needs to go through an approval process and might be approved/rejected without that affecting the other values collected in the list.

So if for example a user selects Value1 and Value2 from the list collector, there will be an approval for Value1 and another approval for Value2. I was able to implement this with the help of this community, but now I have a last hurdle that I need help with: in each approval, the email displays all the values that the user selects (Value1 and Value2) instead of the corresponding value that is being submitted to the approval record.

The approvers won’t be able to discern what they are being asked to approve; how do I reference the specific value from the list collector in the notification record or the email script? I can share the code I used in this workflow if needed.
Regards,

ubido

premer · ‎10-18-2019

"I should insert a condition on the current Approval Request notification so that it won't fire in this workflow" - Yup, well I don't know if you can exclude a workflow, but you should be able to exclude based on some value of your table/form
"which one branch continuing to the Approval and working just as it is now (except that the notification will not fire) and another branch to an email event to do what you suggest" - Yup again 🙂
"except that I don't need a script to look through the apprv_ar array " - Ah I thought you wanted to send out a mail for every entry in your array. But if you only need to send out one mail then you indeed do not have to run through the array again.
"How do I make a reference to a parameter in the notification Message field?" - In your workflow script, use gs.eventQueue("Your event name", current, workflow.scratchpad.apprv_ary[N], a_second_parameter_if_you_need_one); to call the event, then in your email notification body, use ${event.parm1} to display it.
```
 
```

View solution in original post

premer · ‎10-18-2019

"I should insert a condition on the current Approval Request notification so that it won't fire in this workflow" - Yup, well I don't know if you can exclude a workflow, but you should be able to exclude based on some value of your table/form
"which one branch continuing to the Approval and working just as it is now (except that the notification will not fire) and another branch to an email event to do what you suggest" - Yup again 🙂
"except that I don't need a script to look through the apprv_ar array " - Ah I thought you wanted to send out a mail for every entry in your array. But if you only need to send out one mail then you indeed do not have to run through the array again.
"How do I make a reference to a parameter in the notification Message field?" - In your workflow script, use gs.eventQueue("Your event name", current, workflow.scratchpad.apprv_ary[N], a_second_parameter_if_you_need_one); to call the event, then in your email notification body, use ${event.parm1} to display it.
```
 
```

ubido · ‎10-18-2019

Excellent, thanks for the clarification! I'm on the east coast and finishing some other task, but I will try this later today or on Monday as I believe this gives me the functionality I've been looking for. I will provide feedback once I'm done.

Regards,

ubido

ubido · ‎10-29-2019

Hello! Just wanted to let you know that I have not forgotten about this; another project held me up, but I'm working on this today and will let you know how it goes...