I'm adding an Approval workflow to an SP2010 list. The list will record change requests for certain items. There is a second list that tracks, for each item, which SharePoint group should be notified when a change is requested.
List 1 will contain:
Current value= "Hello"
Requested value= "Goodbye"
List 2 will contain:
Here I want the workflow to look in List 2 for an item with
ID 123, pull from the value in the Approvers field and email that group.
Is this possible? Are there any tutorials that show you how to do this?