Understanding Using a Lookup in a Workflow in SPD 2010
Posted on 2013-01-27
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.