I’m trying to create a workflow (2010 or 2013) to update all of the Department Names or the Department Codes in List 2 whenever there is change to the Department Names or Department Codes in List 1.
For example, if I update the department name ‘Operations Data’ to ‘Ops Data’ in List 1, I would like a workflow to loop through all the employee data in List 2 and update the department name to ‘Ops Data’.
What is the best way to accomplish this?
List 1 – Depts & Codes (10-15 departments)
Department Name | Department Code
Operations Data 1001
Operations Mgmt 1002
List 2 – Employee Data (800-900 employees)
Employee Name | Position | Department Name | Department Code
John Doe Operator Operations Data 1001
Tim Daily Operator Operations Data 1001