I am trying to make an approval workflow run off of an approver pulled from a separate list.
For instance I have a SharePoint list called "access" that has a lookup of a choice field from a separate list called department (which is just list of departments and a person who is approver).
What I am trying to accomplish is to have the workflow pull the associated approver based on which department that is selected in the dropdown from the "access" form.
What I have tried so far is setting a local variable in SP designer but I am unsure of how to work the logic to pull the associated approver when a department is selected.
I am trying to accomplish this in SharePoint designer, but if coding through Visual Studio is the better way I can give it a shot.