Decision table in flow designer

[SivaranjaniR]

Hi Team,

I’m working on a flow where:

• A request is submitted through a Service Catalog item.

• I need to send approval tasks to different groups based on the requester’s department.

• There are about 40 departments and 10 approval sets.

What I’ve done so far:

1. Created a Decision Table with:

   • Input: department (cmn_department).

   • Output: assignment group.

2. In Flow Designer:

   • Get Catalog Variable (requestor_department).

   • Use Make Decision (Decision Table).

   • Create Catalog Task.

   • Update the Catalog Task → set Assignment Group = decision output.

Question:

• Is this the best approach to handle large mappings (40+ departments → groups), or should I consider sub-flows/lookup tables instead?

• How can I make sure the decision output (assignment group) is reliably applied to the created task?

• Is there a more scalable way to maintain these mappings without hardcoding in the Decision Table?

I have run several test ,  decision table output hard to map through the flow .

Thanks in advance!

[Ankur Bawiskar]

@SivaranjaniR 

Decision Table is recommended approach here and your flow can dynamically pick the group based on that table configured.

When you make a decision you have the output of that, you can use that to grab the group and set that in Created Task

where are you stuck?

You are on right track.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[SivaranjaniR]

output- catalog task - assignment group is not updated from decision table

[Ankur Bawiskar]

@SivaranjaniR 

in decision table what type is used to hold group?

Is it reference to group table or name?

share screenshots of decision table how it looks and what came as output from Decision table?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Bhimashankar H]

Hi @SivaranjaniR ,

The output should be point to assignment group table. there you have options like Reference ->Existing Table ->Select Assignment group table. 

and to add like 40 department you can use export/import feature of decision table. first add 5 rows in decision table then export, it will export in excel there you can easily add your new departments and groups. then import that excel it will fill all the rows. This activity can be done in direct PROD as well.

Other than this you could create separate table and store the department and related assignment group and using script include you can get the value of that assignment group based on department.

To update the assignment group on created task, first test the decision table by passing the test department and check the output.  Make first decision that matches in execution in flow. and use the appropriate variable from make a decision to update the assignment group in task and use right record to update.

It will be like Make a decision ->sys_decision_multi_result(Record) ->click on this arrow(->) ->it will show you what you can select like name you given in decision table it should be reference. (Select this )

Then it will update the assignment group on task

Thanks,
Bhimashankar H

-------------------------------------------------------------------------------------------------
If my response points you in the right directions, please consider marking it as 'Helpful' & 'Correct'. Thanks!