Currently I am trying to create a workflow where once someone inputs a name into a people picker field, the workflow then matches that submitted name to another list. Once match has been made I need to the workflow to copy the team that the employee is on to the first list.
List 1 is an out list, where the workflow will reside. This is where I need the team name from list 2 to be copied to.
List 2 is a directory list, where the employee name will be matched and where the team name is stored.
Is this possible? Or if there is another way to look up this information and auto populate a field, that would be great too.