how to get value from specific column based on another column

[C-G]

hi everyone, 

I have a flow that is triggered by a record producer (associated with the incident table) that needs to choose the "assigned to" field based on the user input on "department".

the "department" field is a reference drop-down to my departments table, and the table has columns like: name, number, and manager. 

if user selects a department I want the incident record to be assigned to the manager associated with that department on the departments table. I'm not sure how to achieve this, your help would be appreciated!

[Dr Atul G- LNG]

Hi @C-G 

There are 2 separate requirements in this

I have a flow that is triggered by a record producer (associated with the incident table) that needs to choose the "assigned to" field based on the user input on "department".

the "department" field is a reference drop-down to my department's table, and the table has columns like: name, number, and manager. 

Atul: For this you can create look up way. 

https://docs.servicenow.com/bundle/vancouver-build-workflows/page/administer/flow-designer/reference...

---->

if user selects a department I want the incident record to be assigned to the manager associated with that department on the departments table. I'm not sure how to achieve this, your help would be appreciated!

Atul: For this, use can use auto populate in way to populate

Create 2 variable

- Location ( Refence to Location Table)

- Street - Single line text

Go to Auto populate tab. and do dot walk to street.

[C-G]

Thank you for you reply! Using the Look Up Records did not offer the result I needed, but using Auto-populate on the manager name variable was a good work-around. 

[Dr Atul G- LNG · Accepted solution]

Hi @C-G 

Good to know it works for you.  Please accept my answer as a solution and close the thread.