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)

1
vote
1answer
742 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
484 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
3k 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
578 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
369 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
210 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
236 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
107 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
282 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
590 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
541 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 ...
2
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
405 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
332 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
224 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
471 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.: ...
1
vote
1answer
678 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 ...
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 ...
1
vote
1answer
1k views

Set value in a lookup column during “Create List Item” workflow action

Here's the scenario, using SharePoint Designer 2007 and two simple lists in MOSS SP2: I create items in a list called "Code Snippets" with columns Title, Code and Author's CustID I track how many ...
14
votes
2answers
827 views

When deploying a site from custom site template, one lookup column in doclib has empty values for Office 2010 (docx, xlsx, pptx) files

I'm deploying sites using a custom site template (WSP) that is: Saved as WSP from customized Team Site Deployed as Farm Solution Has lists, libraries with content customized in Visual Studio ...
4
votes
2answers
5k views

How to retrieve lookup values using ClientContext?

What's the best way to retrieve lookup values using ClientContext? I'm accessing a list using ClientContext (let's call it ParentList). That list contains several lookup fields (let's call one of them ...
1
vote
1answer
1k views

Get related items from a parent list item through lookup

I've got 2 lists: Companies and Employees. In Companies I have a text field called Name and in Employees I have a lookup to Companies based on the company Name. What I'm trying to achieve is to get ...
1
vote
1answer
74 views

How to tell if a column is a valid lookup reference?

When creating a lookup column in SharePoint 2007 the user interface restricts the available columns to a subset of all columns in the list. How does SharePoint decide which columns are available? The ...
2
votes
2answers
623 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 ...
0
votes
1answer
294 views

Showing referencing items in list view

I need to create a list view in SharePoint where several foreign Items which are referencing the the actual item are beeing displayed. As example the actual list is called companies and for each ...
1
vote
0answers
1k views

Inserting new item in list with EntityRef field to User Information List using Linq to SharePoint

I have a list with SPFieldUser field type in it. I try to insert new item in this list using Linq 2 SP. So, I generated data context class using the following configuration file: <List Name="User ...
3
votes
2answers
1k views

Deactivate the link of lookup-fields! (2010)

On our solution (SP Foundation) we multiple lists with quite some lookup fields. Some of the lookup fields are user fields who link to the user info list, and we don't want that to happen. Of ...
0
votes
1answer
247 views

Looking for an additional feature - Cross site lookup field

We want to implement the cross site lookup in our environment and decided to use the solution available at http://sp2010filteredlookup.codeplex.com. Unfortunately, there is a missing feature that ...
1
vote
2answers
538 views

SharePoint 2010 Lookup IE more than 20 items

Is there a way to stop SharePoint lookups in IE from becoming a text input when there are more than 20 items?
0
votes
2answers
205 views

Is it possible to have a lookup column that points to a different site?

Is it possible to have a Lookup column that points to a different SharePoint site, hosted on the same SharePoint server?
3
votes
2answers
2k views

Client OM - setting lookup fails

I'm using client object model to migrate data from some external data source. The problem is that when I set lookup (normal list or user) I get: Value does not fall within the expected range. I set ...
1
vote
1answer
584 views

Add lookup field with object model?

I have an existing list "Country List", Column "COUNTRY" contains name of the all the countries. I would like to create a look up field "Origin Country" in a list "Order List" via OM. How do I do ...
0
votes
1answer
55 views

How to test lookup?

When creating a workflow, is there any way to test the look up values? For instance, I have a 4-level look up which finds the manager of a user who is entered on the form. I'd like to be able to see ...
3
votes
3answers
1k views

Export Import Library with Lookup column

I did export operation of custom library in Central Administration. Library has some custom fields and Lookup field on existing library on the site. After exporting main library and all dependecie ...
1
vote
0answers
517 views

Why does SPMetal ignore lookup columns in Farm Solution

I have content types and related lists (via lookup columns) in a Sandbox solution(.wsp). All my lookup column relationships come up fine in the SPMetal generated entity classes. I now have a ...
0
votes
1answer
365 views

Fix a lookup type site column when website is provisioned

The site column "Related Task" is lookup type. I would like to fix this column's "Get information from" table. The get information table is within the same site. Is it possible to fix this using using ...
0
votes
3answers
7k views

How to implement Cascaded lookup in SP 2010?

In sp 2007, I have used jquery to do the cascade. But now I hear sp 2010 provides cascaded lookup. I have 3 level to drill down (Country > State > City). Is/are there any good instruction on how to ...
2
votes
3answers
748 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 ...
1
vote
1answer
2k views

Allow multi-selection for a field based on an external content type?

The choice field and lookup field allow for multiple selections. I can't find that option for lookups to external content types. Is it possible to do this? (I want to assign documents to one or more ...
1
vote
1answer
405 views

Accessing Lookup Values fails with Exception when the connected user is not the SharePoint Site Collection administrator

In sharepoint 2010 Foundation, after we installed a simple event receiver that mainly runs when certain items are added/modified, we noticed, during manual testing, that if we logged in as a user ...
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 ...
0
votes
0answers
698 views

using list lookup Fields in SharePoint 2010 programmatically [duplicate]

Possible Duplicate: How to set ListItem Lookup Field value I have a SharePoint list with a lookup field and I want to add values to this list through the SharePoint Object Model. but I ...
7
votes
3answers
2k views

Multiple Lookup field , how to return better deliminators using object model?

I have a multiple lookup field, and when I do this: string myValue = oItem["MyLookupField"]; I get this string back: [id];#[displayText];#[id];#[displayText] or a real example: "5;#C3;#15;#P3" ...
4
votes
1answer
371 views

Lookup to list with permissions

i'm trying to achieve something that i'm not sure if it's possible or not. I have a News system that uses multiple lists, permissions etc. The permissions exist because only 1 person is able ...
2
votes
2answers
869 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 ...