Solved

Understanding Using a Lookup in a Workflow in SPD 2010

Posted on 2013-01-27
1
772 Views
Last Modified: 2013-02-13
I have created two lists, one is called "CDRL Review" and the other is called "Vendors".  I created a Lookup column in the CDRL Review List that is supposed to pull the Vendor's email address from the 2nd List and populate an email header with the vendor's email address for an email to be sent.  When I start to set up the lookup in SPD, I receive a series of windows asking for the Field Data to Retrieve, Data Source, Field from source, etc.  I cannot seem to fill these windows out properly to get the lookup to pull the vendor's email address to store in a workflow variable.  Would someone please help me understand what goes where in order to make this work?  For example, in the "Lookup for String" window, do I list the CRDL Review list as the Data Source, since that is the one that contains the lookup?  Which list is the "Find the List Item" section referring to?  And lastly, which list do I choose as the Data Source in the last window called "Lookup for Single line of text"?  Thanks.
0
Comment
Question by:Cljose
1 Comment
 

Accepted Solution

by:
Cljose earned 0 total points
ID: 38886516
I figured this out by looking at other answers.  What I learned is that the first window labeled "Lookup for String", the Data source must be the secondary List tied to your Master List, i.e. the List containing the Lookup column.  The "Field from source" is the EXACT field you would like info from.  In my case, it was EmailAddress.  Return the field "As String".  In the lower portion of the same window, where it reads "Find the List Item", you are now focusing on the Master List.  When you click the blank textbox to select the column name from your Master List (labeled "Field"), a second window opens.  The idea is that this works similar to a wizard to assist in selecting the correct field.  The top of the window will read "Lookup for Single line of text".  Choose "Current Item" as your Data Source.  The "Current Item" is your Master List or, in this case, the CDRL Review List.  This would be the column labeled "Vendor Communications".  The "Field from source:" refers to the Master List column name.  The "Return field as:" must be set to "Lookup Value (as Text).
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question