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
1answer
362 views

Customize LookUp Field

Someone knows how to customize a LookUp field to make it look like it: http://www.codeproject.com/Articles/18929/An-OwnerDraw-ComboBox-with-CheckBoxes-in-the-Drop (Dropdown + Checkbox).
0
votes
1answer
258 views

Retain array value after postback in sharepoint list edit form

I have saved the values on the right side of multi-select lookup column in an array . When i click on "save" to save the form, the values are getting saved properly. But when i try to edit the form ...
3
votes
2answers
3k views

Lookup Column Values With and Without ID;# in SPD with DVWPs

I see this difference when I'm working with lists in Data View Web Parts and manipulating the values in XSL. Why do some Lookup column values look like '1;#text' and others just have the text? I've ...
0
votes
1answer
520 views

Why is the associated lookup field not on the dispform.aspx?

I have three lists: Events (calendar) Customer1 (custom list from scratch) Customer2 (custom list from template) When I added the lookup of Customer1's ID and added the associated field "Title," ...
0
votes
1answer
488 views

Read lookup value dynamically from list and fill select box

I have one list with different musical Genres, this list is linked as a lookup to the lists Bands and Records. When I register a new band I set the typical genres played by this band and when ...
1
vote
0answers
285 views

How to get lookup field text column to display as an image in a view?

Wonder if anyone can help. I want to add a category choice field to a SP2010 Announcements list. The category choice is a lookup field to another list. The other list contains the categories and a ...
2
votes
1answer
483 views

How to improve performance of lists with multi-lookups

I have a list that includes several lookup fields. Some of these are simple lookups (only one value allowed), others are multi-lookups (the "allow multiple values" checkbox is selected). I have ...
2
votes
2answers
987 views

Invalid Look up Value . A look up field contains invalid data

I have a multi select Lookup column . I have to populate values to the lookup column from another column on a button click. I achieved it using below code but when i try to click ok/save it is ...
1
vote
2answers
716 views

Add lookup field to list from a RootWeb

I have the site collection rootweb called Main Site. I have many subsites called according to the year, 2012, 2011, etc. In the rootweb, there is a list called Products. In the subsites there is a ...
1
vote
1answer
161 views

Why do some of my lookup fields have type-ahead in the UI?

(And how can I get all of my lookup fields to have type ahead?) So here is the weird thing: I have several lists and lookups which I am deploying as a part of a .wsp. Of all of the lookups that are ...
1
vote
2answers
1k views

Cascading Dropdown for Lookup with more than 20 items

I have implemented cascading dropdown using SPCascadingDropdown (SPServices) it was working for lookup with 19 items . When the items count became more than 20 , the lookup column is displayed as ...
0
votes
1answer
786 views

Sharepoint 2007 lookup column

I have a site dropdown column using a list as the datasource (lookup). I was looking for a way to have the column be both required and have a default blank value. I read that is is not possible ...
1
vote
2answers
6k views

How to get multivalue lookup column items from sharepoint list to infopath?

I am on a project. I have a list that have 2 columns. One is the title, other is a multiple value look up column from another list. Everything is ok, working well. And call it ListA. BUT, i am ...
1
vote
1answer
3k views

CAML query for null lookup field values

I have a problem with filtering list items using CALM I Have this list: Code - Text, Name - Text, Link - Text, Order No - Number, Parent - Lookup to this List. I want to filter all items where Parent ...
0
votes
1answer
190 views

List to library lookup

I have a list which contains information about pieces of equipment. I also have a document library which contains things like certificates, receipts etc which relate to the equipment. In the list I ...
1
vote
1answer
706 views

Extending Content Types from Content Type Hub

I have defined a content type in content type hub. I would like to use this content type on a site (other than the hub) but also to extend it with an additional (lookup) column. Is it possible to do ...
0
votes
2answers
1k views

Retrieve Selected Text from Multi select LookupColumn with more than 20 items

I have a lookup column with more than 20 items and I want to retrieve the selected text in a variable.To achieve this I have tried the code below but I am getting an error(mentioned in the code). ...
7
votes
3answers
6k views

How to get the ID of the list item just inserted using ecmascript

I am stuck at a place where I have to update a list which has a Lookup column. For example I am using this code to update my normal list var clientContext = SP.ClientContext.get_current(); ...
0
votes
2answers
643 views

Lookup field on custom form does not save once deployed on testing

I have a custom form on a content type I've created. This content type has 3 site columns which are a lookup field from 3 lists. In the form I've created the user selects a dropdown box and chooses an ...
0
votes
2answers
308 views

How to group repetitive items?

I have 1 list and 4 field in it. one column is person, one is title, one is feature, one is experience. all columns are look up except title. But i have problem with person. If i want to add ...
1
vote
0answers
350 views

CAML Contains on a lookup field of a calculated column

I have some issue when using the CAML Contains statement when the field is a lookup field on a calculated column. It basically does not work, the Equal works though. here is the query, nothing ...
6
votes
5answers
7k views

Why is my column not shown under “Add a column to show each of these additional fields”?

In SP2010, I want to get 2 columns from another list and merge these columns. But when I am trying to do this via Lookup, they are not shown under "Add a column to show each of these additional ...
1
vote
1answer
1k views

set multiselect lookup column using jquery

I have a Multi select Look up column which as you all know is a control with two list boxes and "Add or Remove" Buttons. The user populates the right-hand side of the control with some values by ...
0
votes
2answers
2k views

Multi select Lookup column returns null in javascript client object mode;

I am trying to retrieve the selected values of multi select lookup column and store them in array and then set the lookup column with the same selected values after drop down value changes but always ...
1
vote
1answer
919 views

Lookup column of type “User” showing #ERR

I've defined two list definitions and instances in a feature in VS2010. One list only contains a required field "Employee" which is of type User. The second list has two fields, a simple text field ...
1
vote
0answers
87 views

Lookup columns into document template

I've a DocLib with the lookup field Field01 and I want to display the associated lookup columns as Field01:FieldA, Field01:FieldB... I already have them on the view, now I want the exact same ...
5
votes
3answers
6k views

Deploying List Instance - LookupMulti Type Column in XML

So I have been able to populate rows with Lookup type fields as such: <ListInstance ... > <Data> <Rows> <Row> <Field ...
1
vote
2answers
2k views

Modify existing lookup type column to managed metadata type

We are in process of migrating one of our big website which is built in WSS 3.0 to SharePoint 2010 Standard version. In the process we want to convert all lookup columns to managed metadata type. We ...
1
vote
1answer
420 views

Calculated column based on data in linked list in Sharepoint 2010

I have two sharepoint lists: one with all budget positions one with all cost centers the budget positions have a lookup column that links to an entry in the cost center list. What I would like to ...
1
vote
0answers
124 views

How do I create a linked keyword index?

We have a 2000-document library that we use as a knowledge base. We're trying to create a hyperlinked index of keywords. In this simplified example, consider the following metadata for a document ...
4
votes
1answer
685 views

REST API Filter by multilookup property

Having an Activities list with a column called Engineer of type lookup that allow multiple values. How to build a call to listdata.svc in order to get only activities that are asigned to an Engineer ...
1
vote
1answer
775 views

Lookup with a custom field type as target

I want to create a lookup field with the sharepoint ui which points to a field with a custom field type (parent field type is number). In visual studio with the object model this is not a problem but ...
0
votes
1answer
1k views

SPLookUpField and Adding Values

I am creating a custom list programmatically. List has one Lookup field. Here is my code sample how I am creating LookUp field. oList.Fields.AddLookup("Parent", oListGuid, false); ...
0
votes
1answer
3k views

How do I update a lookup column from a dropdownlist?

I'm creating a custom web part in asp.net for SharePoint 2010 programmatically. When a user presses an Add button, the selected item from the dropdownlist is supposed to then be added to the Groups ...
0
votes
1answer
657 views

How to use the Links list item as target column for a lookup field in SharePoint?

I have created a Links list in my SharePoint 2010 site. Also, I have created a default document library. Now I want to create a new column in the document library; the column should be a multiple ...
1
vote
2answers
130 views

Document look-up of PDFs

I have a look-up to the Documents list on the Title column, containing a mixture of DOCX and PDF files. The DOCX files appear in the drop-down, but the PDFs seem to be ignored. I can open the PDF ...
3
votes
1answer
3k views

Maximum allowed values in a single sharepoint lookup column/ sharepoint list update

I am facing problem with my custom developed webpart which inserts data into a sharepoint list using excel sheet. I have a list with around 50+ columns in it, it has 10+ lookup columns in it, things ...
2
votes
2answers
2k views

Is it possible to have a lookup field with multiple source lists?

I have two lists: list A and list B. List A should have a new multiple choice lookup column that allows the user to choose items from both list A and list B. Is this even possible? I have a kind of ...
2
votes
0answers
322 views

Multivalue and single value lookup issue

Let's assume that we have two lists - Foo which has some kind of information - no matter what, and second - Cities - which holds city names. Now, we set up on Foo list lookup field to City list and ...
0
votes
0answers
775 views

Lookup multiple-values on form-library sharepoint 2010 for InfoPath Form

I use InfoPath form template for a form library without coding. I want to get multiple-value of lookup to another list items. For lookup I should use sharepoint 2010 column due to no such data type in ...
3
votes
1answer
2k views

How to sort SharePoint 2010 lookup combobox?

I have a lookup combobox whose source is another SharePoint list. By default, this combobox items are sorted by word order but I want to sort this items with another/custom order. How can I do this? ...
2
votes
2answers
2k views

Lists with lookup columns aren't saving - read only?

I've got several list which have lookup fields, and I can't add new items to any of them. Every time I've clicked save, I get this error: "Invalid data has been used to update the list item. The ...
3
votes
1answer
561 views

AddLookup using the client object model?

Trying (desperately) to find the Microsoft.Sharepoint.Client equivalent of SPList.Fields.Addlookup My code: ClientContext ctx = new ClientContext("http://sharepoint/"); Web website = ctx.Web; ...
2
votes
1answer
586 views

set or update multiple values cascading lookup field using client object model

I'm struggling since a couple of weeks with setting a multiple values cascading lookup field using a client object model, I could set the first value but then It show me an error of invalid lookup ...
0
votes
1answer
324 views

lookup external list

I have two tables: Documents Project task What I am looking for is the following: I have a page with project tasks in a hierarchy list (done) Clicking on a task will open an edit screen (done) ...
0
votes
1answer
351 views

Copy data from Lookup field to Filtered Lookup

I'm migrating a list up a level from the site to the site collection. After migrating the list via list template, I need to move the data from the Lookup to the new Filtered lookup field on the same ...
0
votes
1answer
926 views

How to pre-fill the look-up column in a child list?

How to pre-fill the look-up column in a child list item based on the parent item, from whose form the child is being created? Is this possible?
0
votes
1answer
785 views

Filtered lookup field

I would like to apply filtering to existing out-of-the-box lookup fields (without InfoPath). The solution should be limited to GUI only: when Backup/Restoring to a clean farm the filtering would be ...
6
votes
2answers
5k views

How to display lookup additional field in display form?

I have two lists: Projects and Tasks In the Tasks list, I have created a lookup field titled ProjectID which targets ID filed from the Projects list. Also, I have set for this field to display an ...
1
vote
1answer
955 views

Can't delete List item after setting lookup deletion to restricted

I have a List Item and I wanted to delete it. It's nothing special at all, but it fails. I have two lists, Company and Company Contacts. Each Company have 0...n contacts. A company can't be deleted ...