Converting List Collector values to string field and store in decision table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-20-2024 07:59 AM
Hi,
My requirement is that I have one field in my intake form with the following choices:
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.
Please help me with this..
Thank you,
VullankiL
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-22-2024 04:45 PM
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:)
Murthy
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-22-2024 04:53 PM
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:
Hope this resolves your issue
Murthy
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-22-2024 10:42 PM
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