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
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 ...
3
votes
3answers
2k views

GridView lookups displaying as “id;#value”

I am using an ASP.net gridview. The datasource is SPList.Items.GetDataTable(). The gridview is working fine; however, lookup and multilookup columns display as "id;#value". Is there any way to just ...
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 ...
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 ...
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
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 ...
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 ...
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?
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
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
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 ...
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 ...
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 ...
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 ...
0
votes
1answer
736 views

Person/Group Lookup Field in Custom List custom new/edit form

In my Custom Newform.aspx I need a field that gives me the possibilty to insert a person or group known in the AD. How can I do this? Probably a kind of javascript or something like that. It would ...
0
votes
2answers
283 views

Lookup from list column?

Is it possible to look-up anything but single line text values when creating a lookup column? E.g. I have a list with some general data ind it, one of the columns contains numbers. They should form ...
0
votes
3answers
777 views

Cross site lookup in SharePoint 2007

I need to add a lookup column to an existing list in a sub-site in SharePoint 2007. The data would come from a sibling sub-site. How can I do that? I see the option to add a lookup column, but that ...
0
votes
1answer
1k views

Programmatically generated Lookup Field causes “System.ArgumentException: Value does not fall within the expected range” when creating new item

I created a content type TypeA that has a lookup field to basic ListB. Then I create a ListA that uses TypeA. Everything is created programmatically. An exception is thrown when ListA's 'add new ...
1
vote
4answers
872 views

Add existing list as a lookup column in User Profiles

I'd like to extend my user profile properties in my SSP by adding a new property which would render as a dropdownlist via a lookup column. Is it possible to reference a sharepoint list using a ...
0
votes
2answers
2k views

jQuery Set Lookup Column Value

When using jQuery, what is the syntax to set a lookup column to a value retrieved from another lookup column. I have been able to prepopulate a string column with a value retrieved from a lookup ...
1
vote
1answer
2k views

Sort By Descending upon lookup column

I have a lookup column in multiple lists that points to a list of dates. These dates go in ascending order, and since the list posts are sequential, the older dates start to become irrelavent, forcing ...
2
votes
1answer
687 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 ...
1
vote
3answers
2k views

Can a list be made available to column in subsite?

I am creating a project management site template. This template will be used to create PM subsites in our corporate PM site. In the subsite task list, I want to add a "Work Area" column that is a ...