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)

2
votes
2answers
421 views

infopath form not updating fields

I have an infopath form that has three read-only fields referencing items in another list, but when someone opens the form the values never change, even if they have changed in the other list. It ...
2
votes
3answers
2k views

How to Force Alphabetical Order in Lookup Dropdown with Multiple Choices

In my portal (Sharepoint Server 2010 Enterprise) I have a simple list with only the title field. I've created about 50 entries in the list. In another list, I have a lookup column that pulls from ...
2
votes
2answers
260 views

Lookup List and return data from within a Form

OK, I'm beginning to despair at SharePoint...please help restore some faith :) Seems some very basic things are very hard to achieve? 1: I have data in an SQL database table. 78,000 rows, but I want ...
2
votes
3answers
600 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 ...
2
votes
3answers
246 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, ...
2
votes
3answers
2k views

Can someone provide examples and direction with relational list?

I'm trying to figure out the best course of action concerning relational lists. I have create several parent and child related lists but I'm having a bit of trouble understanding how to build my CAML ...
2
votes
2answers
3k views

How to automatically link parent in child list new form?

I would have thought this would be something I could find easily with a search, but not so far. I have a parent/child relationship between two lists using a lookup column in the child. I have added ...
2
votes
1answer
44 views

How does the look up function work?

I currently have two lists: List #1 have the fields country and colour (and several other fields that are irrelevant) List #2 have the field colour (and several other fields that are irrelevant) So ...
2
votes
1answer
96 views

Filtered lookup column with 'WHERE' clause

I have 2 lists: List 1 and List 2. List 1 has 2 columns 'supplier' and 'broker'. List 2 has 2 columns 'nature' and 'supplier name'. My requirement is 'supplier' is a lookup from 'supplier name' ...
2
votes
1answer
175 views

Calculated field shows seemingly random number when set to be empty

I'm trying to set up this solution for creating a filtered lookup: How to make a filtered lookup field I have set up an ItemAvailable column like this: The column "Availability" is a choice ...
2
votes
2answers
578 views

SharePoint 2010 NewForm.aspx Lookup Fields Issue

I have a SharePoint 2010 Foundation site that has recently been upgraded from WSS 3.0. The upgrade was completed successfully with no glitches. However, ever since I have upgraded the site I have ...
2
votes
1answer
417 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
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
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 ...
2
votes
1answer
1k views

Validate a date column against a lookupfields additional column

In a list you can create a lookup column which queries data from an other list, the fun part is that you can add "additional columns" which results in some sort of ghost column which is added to the ...
2
votes
1answer
725 views

Lookup site column not saving/storing metadata for Office 2007 documents?

I'm having this issue on several server environments. We have a list at the site collection root. There is a site column created as a multi-value lookup on that list's Title field. This site column ...
2
votes
2answers
55 views

Autocomplete Lookup - Finding the Best Approach

In my past months learning the ins and outs of Sharepoint, I've had some difficulty finding a really good solution for creating an Autocomplete Lookup. I've explored a couple different options, each ...
2
votes
1answer
89 views

Uploading a file to a library with curl - how do you also update the column values

I'm able to upload files from linux to sharepoint using something like this curl -u "Domain\Account":'Password' --ntlm -k -T report.xls https://portal.company.com/test_site/test_doc/ I would ...
2
votes
2answers
88 views

Am I doing something wrong, or are these common pitfalls or limitations of using lookup lists?

I'm using (and limited to) OOTB Foundation 2010, and have been exploring lookup lists. I am discovering a few things that aren't working the way I'd like, seem to be working inconsistently, and are ...
2
votes
3answers
1k views

Can a SharePoint 2010 lookup column point to a multi-line rich text field from same list

Can a SharePoint 2010 lookup column point to a multi-line rich text field in same list? i dont find multiline column while creating a lookup column. Is there any way to achieve this. Because my ...
2
votes
1answer
210 views

Self Referencing Related Documents Library Through Lookup Column

I am trying to create a single document library that links to documents in the same library in SharePoint 2010 Server. I've created a multi-value lookup column that references the same library to ...
2
votes
1answer
436 views

Use count-related column value as int in a SP Designer-workflow

I have another problem concerning the count-related column-value of SP2010 in a workflow(see also: How to get count related Lookup value programmatically? ). my use-case: I have a column "actual ...
2
votes
2answers
1k views

Can text in a lookup column be displayed as text with no link?

SharePoint 2007 and have site curate access only. List-A has a column Name and that is a lookup to List-B, which only has names and no other information. Now when looking at lookup columns in views ...
2
votes
1answer
734 views

Managed metadata vs lookup for column

I have a property content type. I'm wanting to add a property code column which will look up the codes from somewhere else on a SharePoint Online site, where it can easily be managed by end users. I ...
2
votes
2answers
773 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 ...
2
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
1answer
529 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 ...
2
votes
1answer
675 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 ...
2
votes
3answers
701 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 ...
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
2answers
492 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.: ...
2
votes
2answers
1k views

Maximum lookup columns - the magic number 13

So I did create on an SPWeb 20 custom lists and then a tasks list. For each of those 20 lists I've created 20 site lookup columns. I then created 20 Content Types based on Task content type. Then I've ...
2
votes
0answers
33 views

Create a lookup field that is text instead of a drop-down (or similar)?

In SharePoint, I have a list (staff) and a document library and have successfully made a custom lookup column/field from the document library pointing to the staff list (staff id column). This ...
2
votes
1answer
61 views

Lookup column with no duplicates

I have a library containing documents, each one regarding a project. I also have a custom list with tasks (for monitoring) which has a column PROJECT. There are more than one tasks per project so this ...
2
votes
0answers
46 views

Sharepoint 2013 not displaying lookup field as input

I have a lookup column whose datasource has many items (2 000+) and when creating an item that references the source list, a dropdown is not very suited for the task. In SP2010 when there were more ...
2
votes
0answers
72 views

Sorting a Lookup Column from Survey that pulls from Calculated Field SP 2010

I'm looking for a way to sort a Lookup question in a survey that pulls from a calculated field. Specifically, I have it lookup a calculated field that combines the date and name from a list. I want ...
2
votes
0answers
86 views

Getting distinct/unical values from External List

I have got an External List. I want to get distinct values from this External list to the dropdownlist getting from lookup Field. The values are often repeated. How can I get distinct values from ...
2
votes
1answer
448 views

How to update metadata?

I have following code (didn't list the whole code) behind a button on a InfoPath Managed Form. and it works meaning I can submit data to a list. Now I have 2 controls on the form that is ...
2
votes
0answers
307 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 ...
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, ...
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}" ...
2
votes
2answers
673 views

How do I create custom control or action that works in a list's DataSheet view?

I have created a cascading lookup column field for a list in sharepoint 2010. It's working fine in the Standard view but not in the DataSheet view. In datasheet view it is showing all the possible ...
1
vote
3answers
5k views

How do you connect a Calendar List to a Project Tasks list using Web Part Connections?

I created a Calendar List and a Project Tasks list. Then I added a lookup from the Tasks list to the Calendar list. However, when I try to connect the two with the related field visible on both list ...
1
vote
3answers
2k views

Content Type Hub Syndication and lookup site column within a content type

I am a content type which has to have a lookup field. I have created two exactly identical lists in hub site collection and the consumer site. Then I created the lookup site column and added to the ...
1
vote
3answers
1k views

Lookup Field programmatically in FeatureActivated

I've created a lookup field programmatically in the featureactivated method. This is the code snippet. public override void FeatureActivated(SPFeatureReceiverProperties properties) { using (SPWeb ...
1
vote
1answer
130 views

How do I add a user column to a custom list?

I have created a custom list programatically. I want to add a field to it call User, this should be a lookup to the system Users. This will be like the default CreatedBy field. How would I do this?
1
vote
2answers
125 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 ...
1
vote
1answer
735 views

Is it possible to iterate all lists in Sharepoint in search for a given Field?

Is it possible to itterate all Lists in SharePoint to find out which ones use a custom Lookup field? I have an application which is currently failing because the custom Lookup field was pointing to a ...
1
vote
2answers
1k views

Display form containing lookup field opens new window, how to change this?

On any list in SharePoint 2010, when you open the details view for a list item, you get presented with the display form. If the details view for a list item contains a lookup field, it is displayed ...
1
vote
1answer
66 views

How to retrieve documents from list?

I created a simple Custom List in WSS3. I also created a Document Library with an additional column field which is a lookup to the Custom List that I created before. Now when I am on the Custom List ...