I have an SP site where I want users to post their invoices for the projects they work on. As part of the workflow I want to be able to lookup the conractor and approver from another list in my site. This list has the Project, Contractor and Approver columns where theContractor and Approver columns are lookups from other lists. When I try to use the lookup in the workflow I don't see theContractor and Approver columns listedin the Field dropdown. Is there a way to get this to work so I don't have to duplicate thedata in the Projects list?

Thanks,
Tony

---

Tony Green

Hi,

If your goal is getting the lookup column displayed value in the workflow, you could use Build Dynamic String action to convert the lookup column value type to string, then you can use the returned value in other field.

Hope the information can be helpful.

-lambert

---

Posting is provided "AS IS" with no warranties, and confers no rights.

(All) Workflow questions go to the workflow forum.

---

WSS FAQ sites: WSS 2.0: http://wssv2faq.mindsharp.com WSS 3.0 and MOSS 2007: http://wssv3faq.mindsharp.com
Total list of WSS 3.0 and MOSS 2007 Books (including foreign language titles) http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/V%20Books.aspx

I would try this:
- Go to the list that has the contractor defined as a lookup.
- Add another column to the list named somehting like "ContractorAsText" as a calculated fieldand have it initialize to the value of "Contractor" (or whatever field is tied to the contractor lookup).

If you're lucky, ContractorAsText may be available to your workflow.

---

--Paul Galvin of EMC Consulting, New York area Microsoft MVP - SharePoint Blogging @ http://feeds.feedburner.com/PaulGalvinsSharepointSpace Twitter @ http://www.twitter.com/pagalvin

Unfortunately this doesn't work either as I tried to create the computed column and it too does not list any columns which are lookups from other lists. Is this a known feature (BUG) in SharePoint or the Designer? Is there any way to get either of these to work properly? This is very frustrating. :-(

---

Tony Green

Hi,

If your goal is getting the lookup column displayed value in the workflow, you could use Build Dynamic String action to convert the lookup column value type to string, then you can use the returned value in other field.

Hope the information can be helpful.

-lambert

---

Posting is provided "AS IS" with no warranties, and confers no rights.