Automate the process between Decision Table and Flow Designer for Selectbox Catalog Variable

[mfhaciahmetoglu]

Hello folks,

I am trying to automate the process between Decision Table and Flow Designer for Selectbox Catalog Variable. In this way, I do not need to update decision table, if I change the something in choices in the Catalog Variable. 

Let me explain it further.

On the form, I have a select box called Company code with different options available. Let's imagine that the user selected BE25 - Test. What I want is to ask for approval according to this choice.

On the decision table, I chose reference and the question choice table and selected that choice: BE25 - Test and assigned it to a person.

  Now, I added this decision to the flow. 

Of course, because input was a reference field, the decision is refering me to the question choice table. However, I want this input to come from the user. However, it is not possible to use the datapill for company_code because the field only accepts string.

To solve this, I created a string flow variable and converted that company_code_ to a string. 

Now, I run the flow, see the context: 

And the decision:

It seems fine but it does not work, and if I click on (i) button next to BE25 - Test, nothing happens because I think there has been no match. 

Anyone has any ideas how to automate this process?

Thanks.

Best,

Firat

[MugTm09]

Consider creating an action solely for converting values to the String type, in order to obtain an exact match string. Use the resulting string from this action as input for subsequent processing.

[nityabans27]

Hi @mfhaciahmetoglu 

Maintain Approver in Variable Choice Records

1. Extend Question Choice (question_choice) table with a field → approver (reference to sys_user or sys_user_group).

2. For each catalog variable choice (e.g., BE25 - Test), store the approver in that new field.

3. In Flow Designer:

   • Use the Catalog Item Request trigger.

   • Lookup the selected choice’s sys_id from the variable.

   • Retrieve the related approver from question_choice.

   • Use Ask For Approval action → approver from that record.

✅ This way, no Decision Table is needed — everything rides on the variable’s choice records.