A lookup column is a SharePoint list column that retrieves its available values from another list in the SharePoint site.

learn more… | top users | synonyms (1)

0
votes
3answers
6k views

Add values to lookupmulti field in c#

I want to add values to a lookupmulti field with c#. the form shows the field correctly but my code just won't work: SPList list = SPContext.Current.Web.Lists["testlist"]; SPListItem item = ...
0
votes
1answer
789 views

Lookupfields not showing up in customlist sharepoint 2010

I have a custom list on dev-int environment, now I saved it as a template and moved it over to the dev-vm environment and created a list (Listl1) based on the template. Now this list consists of few ...
1
vote
0answers
274 views

Content Organizer rule based on a Lookup Column with more than 20 selectable values

Does anybody have any experience making content organizer rule based on a Lookup column with more than 20 values in the list? (When you have more than 20 values, the view of the Lookup field changes. ...
0
votes
1answer
8k views

Setting the value of a lookupfield(sharepoint dropdown formfield) in sharepoint 2010 list forms

How can i set the value of sharepoint form field dropdown box(lookupfield) in sharepoint list form when the form gets saved (using jquery) note: the lookupfield (dropdown formfield renders as input if ...
1
vote
0answers
401 views

How to take a value from a single line of text field in one list and set it as a lookup field in another list?

I have SP 2010 and SPD 2010. I have list A that has a single line of text column named Res ID #. This provides the source for List B as a lookup column. I want to create a WF that will put the info ...
3
votes
2answers
299 views

Assign lookup list item with a quantity?

Parent List has a lookup with multiple promotional items. Once user chooses a promotional item, I want user to be able to add a quantity to that specific item. User should be able to select Multiple ...
3
votes
1answer
832 views

How to create a lookup field that has a list column picker

How would I be able to create a list field in VS that would be a lookup to select columns from any list? I would preferably like to have something like the PickerTreeView.aspx, but instead of ...
2
votes
1answer
677 views

In a DVWP my Multilookup column is not returning IDs, only column values

I've added a DVWP to a page. The DVWP shows data from a list with a multi value lookup column. The value returned for this column is in the form: value1;value2;value3. Now I want to render this ...
1
vote
1answer
76 views

NewListItemForm with pre-defined values from selected Entry inside form

i got two lists. One is called 'Projects' the other one 'Reports'. When i insert a new report i got the following fields Associated Project: <LOOKUP FROM PROJECTS_TITLE> Current StartDate: ...
2
votes
3answers
704 views

Binding lookup fields to document library template

I have features that define site content types and a document library template that uses these content types. Now, when I create a document library from the template, all the content types appear ...
1
vote
1answer
4k views

Using an Additional Lookup Column Value in a Calculated Column

I have a lookup column based on another list's description (a 'Category' list) and have ticked the other list's 'Category ID' column to be shown at the same time (I note that this is a manually ...
5
votes
2answers
144 views

Strategy Queston : how would you implement this calendaring use-case

At my organization there is a process that goes in to preparing for our Board of Director's Meetings that begins 6 weeks beforehand and involves about 9 different steps. We have a template document ...
0
votes
2answers
644 views

Trigger workflow email when item created

We have a list called employee details, which has client name as one of the columns which is of the type lookup (from another list name columns value). So when the users create a new item in the ...
2
votes
2answers
1k views

Copy lookup value from one list to another with SPD workflow

I have two lists and a workflow that copies items from list A, if they get approved, to list B. Problem is that a field in list A uses a lookup list, if I select Dog in the Field Animal and save the ...
2
votes
1answer
811 views

REST: unable to retrieve lookup data from top level

At the top level of my site collection, I have created a list called "Markets", and a site column called "Market", defined as a lookup to the Markets list. In a subsite of this same site collection, ...
4
votes
1answer
2k views

dropdown box on change event in SharePoint list forms

I am editing an SharePoint list form using SharePoint Designer. I need to have two drop down boxes one with the names of the countries and other with the names of appropriate state. How can I ...
2
votes
2answers
342 views

Chart Web Part and lookup fields

How can I make my Chart Web Part look good when I use it with lookup fields? The issue I have is that the chart displays the field id along with its value. For example, it displays "2;#Bing" when I'd ...
3
votes
2answers
5k views

How to get lookup value only via REST (listdata.svc)

I am trying to retrieve a list of items including lookup fields via listdata.svc. My lookup points to a list of companies which has the following fields: Title, Address, Phone. By default, listdata ...
1
vote
0answers
193 views

My custom form isn't saving lookup fields

I have a list with two content types. I've created two custom forms for creating new items (because one field I don't want until the 'edit' form). One works great. The other one doesn't. What's ...
3
votes
2answers
1k views

Migration tool for specific lists

I am looking for a migration tool that works at the list level, not for a full site or server. One specific requirement is to be able to migrate lists that are connected via lookups. For example, if ...
1
vote
1answer
362 views

SharePoint 2010, InfoPath and top-level list lookup

We want to have some lists (Suppliers, Projects, etc) at top-site level which can be reached by all child-sites. Using InfoPath on child-sites we want to have a lookup field in the lists there so we ...
3
votes
1answer
2k views

Can you have lookup column to rich text field

Can a SharePoint 2010 lookup column point to a multi-line rich text field in another list? From what I'm reading, it can only see single-line text fields in the other list, which limits its use in our ...
0
votes
3answers
5k views

Lookup column to Documents library

Here's what I need to do for a SharePoint 2010 list: Allow users to select the filename from a dropdown showing the items in the Documents library. But the "Add new item" form of the list doesn't show ...
1
vote
1answer
1k views

Set lookup field value in infopath form on new Item(List Infopath form)

I have lookup field called project stage, on item created I'd like to set to its default value,(project start). Then this field can only be changed by the Workflow as the project moves to the next ...
1
vote
2answers
3k views

Sharepoint 2010 and Infopath form : lookup fields are displayed by their ID instead of text value

I'm trying to build a custom Infopath form for a list that contains 2 fields that I would like to get auto-completed: Person: people picker field, filled with the current user Team: lookup to the ...
1
vote
1answer
239 views

Association between a custom list and an external list

I have a very basic question. I have a Custom List and I'd like to add a lookup column from an External List based on a WCF Service. Is it possible? E.g. I have employers in a custom list. I'd ...
0
votes
1answer
460 views

Output of SharePointWebControls:LookupField inside an <a> Tag?

I have a lookupfield which is containing an E-Mail Adress and want to have it inside an Tag. How is this Possible? Like: <a href="mailto:<SharePointWebControls:LookupField ...
1
vote
2answers
1k views

Compare two person columns in a list

I have a list which has a "Person or Group" column called as Reviewer. I want to notify the reviewers whenever he/she is added to the list item. I created a custom workflow which sends a mail on ...
0
votes
1answer
201 views

lookup field to display content types

Is there a way to add a lookup field column to display all the content types sitting at the site collection level?
1
vote
1answer
789 views

BDC List column picker filter - search/filter not working and exact entry says not found?

I'm working with MOSS 2007. Rephrasing the question. I have a BDC column to an external datasource in a custom list. Today searching and filtering is not in place and actually exact matches are not ...
2
votes
2answers
531 views

How to show results of one-to-many relationship in search results?

We have a one-to-many relationship between a document library (with 150,000 documents) and a custom list storing additional metadata. We're looking to show the additional metadata from all of the ...
2
votes
4answers
4k views

Two-Way Relational List

We are testing SharePoint 2010 Standard and have a need to have relational data, but be able to view the data from both sides of the relation. For example, I have a contacts list and I create a list ...
2
votes
3answers
601 views

Department lookup from User Profiles - SharePoint 2007

We have some 30,000 user profiles . We'd like to build a custom list with lookup for Department from a unique list of departments in our User profiles. Possible? Was thinking of buildin a new ...
3
votes
1answer
405 views

Set a date/lookup in ListInstance elements.xml

I have two lists. The first one has customers and the second one has Orders. Now i want to add some (test) data in the elements.xml of the listinstances. For customers this works without a problem ...
0
votes
1answer
2k views

Pull values from a lookup column using SPServices()

I would like to retrieve values from a lookup column (pull down) using SPServices() and load an array in javascript. This is available only in Newform.aspx. How can I do this?
0
votes
2answers
220 views

Lookup field not updating when the document uploading

I am uploading document programically and passing lookup field value but its not get updated, how to handle this?
2
votes
3answers
247 views

Managing multiple related lists and lookups in SharePoint 2007

I have a custom solution, which has multiple related lists. Four of the Lists have a lookup field based on the field of one list. And, that list has a lookup based on the field of another list. So, ...
1
vote
1answer
112 views

Creating lookups with OOTB Lists in SharePoint 2007

I am developing a solution which has multiple OOTB lists like Links, Contacts, Custom List and Document Library. And, I have to create a lookup field in four lists which refer to a field in a Custom ...
1
vote
2answers
322 views

How to link two lists using a multi-valued lookup column?

I have two lists, one contains files, each file has one or more ID(depending on its content). These IDs are lookups to another list. Now, I generate another list on fly, this list has the ID column as ...
1
vote
1answer
637 views

Document Information Panel contacted a data source but failed to receive data. The form will load without the requested data

The query cannot be run for the following DataObject: list_48985ACC-FDDD-4732-AA48-078CFE123F35 Document Information Panel cannot run the specified query. The SOAP response indicates that an ...
1
vote
1answer
590 views

Lookup fields - not unique values in look field

We have a list, which contains schools with their names and addresses. We have another list, which has lookup field to that list on school name field. Since schools in different cities can have same ...
1
vote
2answers
70 views

Is there any tool that can convert 2007 text/option field type into Managed Metadata fields

we have a 2007 farm that we are rebuilding in 2010. I want to take advantage of some of the new feature like Managed Metadata and I was wondering if there were any good tools out there that can ...
3
votes
2answers
3k views

Problem with Sharepoint ContentTypeBinding and Lookup field

I have a problem with ContentTypeBinding when creating a new site. I have custom site template definition where I have referenced Publishing Server Feature, so list Pages is automatically created on ...
1
vote
2answers
2k views

lookup fields and client object model — i'm going bald?

new to the development world, not to sharepoint. I'm ultimately trying to populate a listbox with items from a multivalue lookup field. If it's a single lookup, no problem. When I make it a multi ...
2
votes
1answer
2k views

Sharepoint - Creating lookup field to list on site collection scope

I've got a big problem with creating Lookup field between two lists which are deployed on site collection scope. I've got this field definition: <Field ID="{c80e8e3c-7124-4772-a39d-5b69f131d542}" ...
1
vote
1answer
454 views

Item Editor form for list - use a lookup table for dropdown

We have a list on SharePoint 2010 called "Policies". It contains a couple of dropdown boxes which point to custom columns. These columns get their data by going to List Settings > clicking on the ...
1
vote
1answer
356 views

linking a document to another document

our setup for document library as follows. We have bunch of document sets (200 doc sets to be exact) in a document library. Each doc set is for particular vendor. We place contracts in each document ...
0
votes
1answer
2k views

lookup field test if value is (none) from SPD Workflow

everything is in the title. I have a lookup field set to optional and I need from my Workflow to test this field. When you do not select any value, you have (none) in the interface but I cannot seem ...
0
votes
1answer
236 views

Restrict item in List from modification if used in other Lookup or Cascading Drop-down field

Currently I have three lists. The 1st list contains a single column. The 2nd list contains two columns - one of the columns performs a lookup on the 1st list. The 3rd list contains three columns - ...
2
votes
2answers
494 views

A “throttling” exception for a lookup field

I have a large list (with item count > 5000) with invoice positions, which I want to be filtered by a lookup field (invoice header ID). I tried to filter the list extending the URL, i.e.: ...