Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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.

e.g.

  • 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
add comment

1 Answer 1

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! –  Vee Bee Aug 21 '12 at 23:01
add comment

Your Answer

 
discard

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.