Catalog workflow approval process revision

[sushmithar1]

I have hardware catalog item where we are using variable set(requested for, requested by, line manger etc) from sys_user table. But in the workflow, we need to use the data from different custom table for approval based on the department set of the requested for user. In our custom table,we have three department set(consult,construct and group services) in the custom table.

Conditions are:

1. If user's department set is construct or group services then notification should be sent to the project manager(we have a separate variable set for project details in the catalog item).

2.If user's department set is consult , a notification should be sent to the user manager( this data needs to be fetched from the custom table not from the sys_user table).

Please help me how to segregate the department set of the user in the catalog workflow and implement this approval logic?

[JenniferRah]

I'm not sure if you really mean workflow or Flow. Flow is the preferred method, but if this is truly a workflow, you'll have to use script to get the approver in the Approval task. 

For Flow, you will need to implement it just like you stated: 

1. If user's department set is construct or group services
   1. Look up Project Manager
   2. Ask for Approval from Project Manager
2. Else if user's department set is consult
   1.  Look up user's manager
   2. Ask for Approval from user's manager