The CreatorCon Call for Content is officially open! Get started here.

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