SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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:

    ID = 123
    Current value = "Hello"
    Requested value = "Goodbye"

  • List 2 will contain:

    ID = 123
    Name = "Greeting"
    Approvers = "IT_Management"

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?

share|improve this question
up vote 0 down vote accepted

Misunderstood your question. I would create a variable in SharePoint designer and use the "Set Workflow Variable" action.

Click "value" and choose the list you want to pull from. Click the small "fx" button to open the Define Workflow Lookup Dialog.

Choose the list you want to pull from as the Data Source. You can choose your Person field on top. In the "Find the list Item" section you can set your filter. Choose the ID field. The value should be the Current Item ID.

Let me know if you need more clarifciation.

share|improve this answer
Got it thanks to your pointers. Thanks! – Vishal Bardoloi Aug 21 '12 at 23:01

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.