Converting List Collector values to string field and store in decision table

VullankiL
Tera Contributor

Hi,

My requirement is that I have one field in my intake form with the following choices:

VullankiL_0-1726843766501.png

It is a list collector field referring sys_choice table, as the choices are created in that table only. I want to map these choice values to decision table field and have to make decision based on it. 
But in decision table there is no list collector field option. so I used string field and storing the sys_id's of the choices. Because if I use reference field, it didn't letting me to choose sys_choice table as my application is scoped.
But while I am storing the sys_id's in the string field. It is only taking first option sys_id that i selected in intake form and making decision based on it. But i want to consider multiple choices and their sys_id's and make different decisions how can i achieve this?
Please refer the decision table below. these are the sys_id's of different choices of list collector field in intake form.

VullankiL_1-1726844258297.png


Please help me with this..

Thank you,
VullankiL

3 REPLIES 3

Murthy Ch
Giga Sage

Hello @VullankiL 

As you are using " contains" operator. It will check all the sys_id's you provided in the string field. Also, I noticed in the picture you shared you given only one sys_id.

If you are giving more than one just give like this a,b,c

Let me know if you still stuck. Happy to help:)

Thanks,
Murthy

Murthy Ch
Giga Sage

@VullankiL 

Sorry. Now I get it.
I think you decision table returning the first decision match.

If you running this through script make sure to check for all decision conditions in your code.

Refer the below image:

MurthyCh_0-1727049194345.png

Hope this resolves your issue

Thanks,
Murthy

Hi @Murthy Ch ,
Thank you for your prompt reply.

I am running it through Flow designer. And also using "Return all decisions that match" only. still it is taking only first value, I think there is a problem with storing list collector values into string. I think it is only storing first value.
How can I solve this?
Please help me with this.

Thanks,
VullankiL