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
1answer
187 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
4answers
3k 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
3answers
824 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
273 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
2answers
1k 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
2answers
266 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
621 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
259 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
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
79 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
61 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
132 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
296 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
6k 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
2answers
644 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
943 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
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
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
369 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
765 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
58 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
488 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
296 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
91 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
2k 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
242 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
768 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
563 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
2answers
988 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
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 ...
2
votes
1answer
727 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
830 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
518 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
121 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
70 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
93 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
66 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
101 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
159 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
488 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
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 ...
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 ...
2
votes
1answer
903 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
761 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 ...