How to assign the assignment group of catalog task based on the details present in table

[suuriyas]

HI Community,

I have created a catalog item now i need to crate a flow designer for the flow is catalog task need to be created but the assignment group of the task should be based on the reference number pserent in sap table

there is a table name sap and fields in the table are ;ike short description, category, reference number , assignment grp etc. reference number is unique meaning each reference number have different assignment group tagged in the sap table.

in portal there is reference number variable is present but not assignment grp variable so if end user select any reference number and submit the request then task needs to be assignment to that particular group from sap table 

let me know how we can achieve this in flow designer

[Mark Manders]

Get the variable from the flow, do a lookup to the sap table to find the record with that reference and set the assignment group to the group that is on that table. If it's a reference, you can set it directly. If it's just a string field, you need to do an additional lookup to the sys_user_group table to find the group with that name.