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)

0
votes
1answer
827 views

Lookupfields not showing up in customlist sharepoint 2010

I have a custom list on dev-int environment, now I saved it as a template and moved it over to the dev-vm environment and created a list (Listl1) based on the template. Now this list consists of few ...
1
vote
0answers
283 views

Content Organizer rule based on a Lookup Column with more than 20 selectable values

Does anybody have any experience making content organizer rule based on a Lookup column with more than 20 values in the list? (When you have more than 20 values, the view of the Lookup field changes. ...
1
vote
0answers
422 views

How to take a value from a single line of text field in one list and set it as a lookup field in another list?

I have SP 2010 and SPD 2010. I have list A that has a single line of text column named Res ID #. This provides the source for List B as a lookup column. I want to create a WF that will put the info ...
3
votes
2answers
308 views

Assign lookup list item with a quantity?

Parent List has a lookup with multiple promotional items. Once user chooses a promotional item, I want user to be able to add a quantity to that specific item. User should be able to select Multiple ...
1
vote
1answer
113 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
1answer
76 views

NewListItemForm with pre-defined values from selected Entry inside form

i got two lists. One is called 'Projects' the other one 'Reports'. When i insert a new report i got the following fields Associated Project: <LOOKUP FROM PROJECTS_TITLE> Current StartDate: ...
0
votes
2answers
657 views

Trigger workflow email when item created

We have a list called employee details, which has client name as one of the columns which is of the type lookup (from another list name columns value). So when the users create a new item in the ...
4
votes
1answer
2k views

dropdown box on change event in SharePoint list forms

I am editing an SharePoint list form using SharePoint Designer. I need to have two drop down boxes one with the names of the countries and other with the names of appropriate state. How can I ...
3
votes
1answer
430 views

How can we use multiple fields from an external list in a survey?

We are trying to build a survey, that uses data from an external list. It works fine for a single field. But what we would like to do is to bring about 10 fields back from the external system and ...
2
votes
3answers
272 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 ...
3
votes
2answers
5k views

How to get lookup value only via REST (listdata.svc)

I am trying to retrieve a list of items including lookup fields via listdata.svc. My lookup points to a list of companies which has the following fields: Title, Address, Phone. By default, listdata ...
1
vote
0answers
195 views

My custom form isn't saving lookup fields

I have a list with two content types. I've created two custom forms for creating new items (because one field I don't want until the 'edit' form). One works great. The other one doesn't. What's ...
1
vote
1answer
240 views

Association between a custom list and an external list

I have a very basic question. I have a Custom List and I'd like to add a lookup column from an External List based on a WCF Service. Is it possible? E.g. I have employers in a custom list. I'd ...
3
votes
2answers
1k views

Migration tool for specific lists

I am looking for a migration tool that works at the list level, not for a full site or server. One specific requirement is to be able to migrate lists that are connected via lookups. For example, if ...
1
vote
1answer
364 views

SharePoint 2010, InfoPath and top-level list lookup

We want to have some lists (Suppliers, Projects, etc) at top-site level which can be reached by all child-sites. Using InfoPath on child-sites we want to have a lookup field in the lists there so we ...
3
votes
1answer
2k views

Can you have lookup column to rich text field

Can a SharePoint 2010 lookup column point to a multi-line rich text field in another list? From what I'm reading, it can only see single-line text fields in the other list, which limits its use in our ...
1
vote
1answer
1k views

Set lookup field value in infopath form on new Item(List Infopath form)

I have lookup field called project stage, on item created I'd like to set to its default value,(project start). Then this field can only be changed by the Workflow as the project moves to the next ...
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 ...
0
votes
1answer
471 views

Output of SharePointWebControls:LookupField inside an <a> Tag?

I have a lookupfield which is containing an E-Mail Adress and want to have it inside an Tag. How is this Possible? Like: <a href="mailto:<SharePointWebControls:LookupField ...
1
vote
2answers
1k views

Compare two person columns in a list

I have a list which has a "Person or Group" column called as Reviewer. I want to notify the reviewers whenever he/she is added to the list item. I created a custom workflow which sends a mail on ...
0
votes
1answer
201 views

lookup field to display content types

Is there a way to add a lookup field column to display all the content types sitting at the site collection level?
2
votes
2answers
544 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
3answers
603 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 ...
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?
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 ...
1
vote
1answer
1k views

SharePoint 2010 difference with lookup columns

I recently upgraded my site from SharePoint 2007 to SharePoint 2010. The first issue I noticed was that the "lookup" columns in "Display view" showed up as the hyperlink instead of the string. ...
1
vote
1answer
604 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 ...
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 ...
0
votes
1answer
260 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
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
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
479 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
362 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
242 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 - ...
1
vote
1answer
754 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 ...
0
votes
1answer
943 views

Problem with SPFieldLookupValue in SharePoint 2010

I have an SPListItem object from a list based on a custom content type. Many of the fields in that content type are lookup types that point to other lists. When I get back the SPListItem object for a ...
1
vote
1answer
2k 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
966 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
77 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
58 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
574 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
206 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
419 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
394 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
406 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 ...