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
5k views

access additional lookup fields using JavaScript and CSOM

In visual studio I have added lookup field (SubMenuItemIdRefTitle) to list definition listA that references ListB. I have also added <ViewFields> <FieldRef ...
2
votes
1answer
7k views

How can I pass a Parameter via Query String to populate a lookup field on a New Item Form/DVWP?

I have two lists: List A: Products List B: Requirements I'd like to have a nice Create Requirement page launched from the Product Listing page. I have a DVWP/Multi-Item View displaying all ...
2
votes
2answers
637 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
5answers
2k views

Cascading Dropdown

I am new to SharePoint 2013. What I need to figure out is based on the following situation. I have several school districts with multiple schools within the school district. I would like to create a ...
2
votes
1answer
309 views

Lookup field doesn't support some field types

Its looking more and more like you can't add additional fields that are anything other than string boxes (no person or yes/no etc) is there any work around for this?
2
votes
2answers
2k 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
5answers
4k 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
7k views

Add additional field to lookup field inside schema.xml

I'm following the steps in this article to setup a joined data view webpart joined on a lookup field: ...
2
votes
3answers
853 views

Sharepoint2010 Lists Lookup

I'm creating 3 lists using Sharepoint 2010 UI. The lists and relationship are as follows: Training (parent) -> Training Instance (child, look up Training ) -> Training Session (grandchild,lookup ...
2
votes
2answers
1k views

Create Site Column (lookup type)

Is there any solid (proven) method of creating Site columns (lookups) where list GUID is not known? I think this is where feature activation kicks in; getting the lookup list by its name and then ...
2
votes
3answers
276 views

How best to handle metadata lookup?

I have a query regarding how I should best handle uploading documents into SharePoint (currently WSS) where the Taxonomy asks for client code for all documents. The problem I have is that we have say ...
2
votes
1answer
135 views

Edit Lookup table programmatically via Project Server Interface (PSI)

I have a standard lookup table database table "LOOKUP_TABLE_VALUES" in a SharePoint 2013 solution with columns like: LT_UID - for the Lookup table GUID LT_VALUE_FULL - storing the values with the ...
2
votes
2answers
273 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
638 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
268 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
3k 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
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
2answers
124 views

Save Site as Template (with include content) does not accept LookUpSite Columns

After long search on the web i could not figure out why i have been facing wired behaviour today with my SharePoint Site. I explain, I have a Site Collection (Blank Site Template) which contains ...
2
votes
1answer
88 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
161 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
370 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
671 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
1k 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
1answer
538 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
384 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
800 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
4answers
131 views

Calculated column that updates daily

Is there a way to make a column in a list that updates daily with the current date? If not what's the best way to do this? I was thinking of using the 'Lookup' field to link to the calendar that's on ...
2
votes
2answers
982 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
480 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
92 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
3k 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
263 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
953 views

Issue with lookup column in subsite

I add lookup columns with a elements.xml file and like everyone else I had issues with them once deployed, i.e. "Get information from:" was empty for the lookup list. I found ...
2
votes
1answer
633 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
2k 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
2answers
1k 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
605 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
748 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
847 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
531 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
1answer
170 views

Lookup field is empty after List Item is added

Here is My Problem: I have a New Form in a list and I have added some custom JS code to it. In the form is a "Registration number" lookup field with more than 20 items in it. I need to populate it ...
2
votes
0answers
85 views

Join SPQuery in list

List 1 "Posts", fields Title body #comments modified in this list #comments fields is look up from another list Comments: List 2 "Comments", fields title body comments post ...
2
votes
1answer
176 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
71 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
122 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
233 views

Sharepoint 2013 - Add lookup column to key filters

I've got a document library of invoices. It has various columns (mainly choices) such as, Year, Status, Location, etc. and I've been able to add them to metadata navigation as key filters. However, ...
2
votes
0answers
204 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 ...