A lookup column is a SharePoint list column that retrieves its available values from another column within another list in the SharePoint site.

learn more… | top users | synonyms (1)

8
votes
4answers
46k views

How to set ListItem Lookup Field value

How do I set a ListItem's Lookup field using code? SPFile file = list.RootFolder.Files.Add(destUrl, iStream, true); SPListItem item = file.Item; item["DocumentID"] = DocID.ToString(); ...
0
votes
3answers
12k views

Add values to lookupmulti field in c#

I want to add values to a lookupmulti field with c#. the form shows the field correctly but my code just won't work: SPList list = SPContext.Current.Web.Lists["testlist"]; SPListItem item = ...
2
votes
1answer
9k 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 ...
4
votes
2answers
15k 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 ...
3
votes
2answers
11k 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: ...
1
vote
2answers
5k views

Retrieving a lookup Value from a List using jquery and REST

I would like to get the lookup Value from a List item depending on it's Title. My List is set up similar to the following example: ColumnA : a | b | c lookupB : 1 | 1 | 2 The jquery: function ...
2
votes
5answers
10k 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 ...
1
vote
1answer
4k 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
206 views

caml query for filtered lookup column

My project uses the 2010 version of the Sharepoint Filtered Lookup Field, which has the option to filter a column using a caml query. So I have three lists: Categories, SubCategories and MainList. ...
0
votes
2answers
6k views

How to return field from specific workflow task as Data source in Lookup tool?

In short . . . How do I do this: ? In Step 1 of my workflow, the first action is to create/assign a task with Task ID of TaskID1. For the next action, how do I assign a field the value of a ...
0
votes
1answer
4k views

How do I update a lookup column from a dropdownlist?

I'm creating a custom web part in asp.net for SharePoint 2010 programmatically. When a user presses an Add button, the selected item from the dropdownlist is supposed to then be added to the Groups ...
3
votes
1answer
4k views

Maximum allowed values in a single sharepoint lookup column/ sharepoint list update

I am facing problem with my custom developed webpart which inserts data into a sharepoint list using excel sheet. I have a list with around 50+ columns in it, it has 10+ lookup columns in it, things ...
3
votes
1answer
3k views

How to sort SharePoint 2010 lookup combobox?

I have a lookup combobox whose source is another SharePoint list. By default, this combobox items are sorted by word order but I want to sort this items with another/custom order. How can I do this? ...
1
vote
1answer
3k views

How to add values from a multi-valued field from a list using SPD's Update an Item Action

I have a workflow that automatically updates the value of a multi-valued field in an item. This workflow is working as expected. BUT, when that field/column of an item has a value already, the current ...
4
votes
3answers
3k 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 ...
3
votes
2answers
4k 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 ...
3
votes
3answers
3k 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
1answer
2k 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 ...
1
vote
1answer
267 views

In SP Online, how to return the default HTML of a lookup field when overriding the Item Template in a list view

I've found various methods to return the default values for the field template override, including lookup, but I have been unable to find or successfully implement a method to do the same for fields ...
1
vote
1answer
3k views

Cross-site and SPFieldLookup

I've read a numbered time that SPFieldLookup is cross-site by its nature. But now I'm a little bit confused, here is my SharePoint structure: /SiteCollection /Site1 Projects /Site2 Customers ...
1
vote
2answers
14k views

Setting the value of a lookupfield(sharepoint dropdown formfield) in sharepoint 2010 list forms

How can i set the value of sharepoint form field dropdown box(lookupfield) in sharepoint list form when the form gets saved (using jquery) note: the lookupfield (dropdown formfield renders as input if ...
0
votes
0answers
63 views

Using multivalue dropdown as a quickpart in word document

When using a lookup multivalue dropdown as a quickpart in a word document, creation of document fails. Using any other type, besides a multivalue dropdown, it works fine. When this error occurs, the ...
0
votes
1answer
2k views

How to Increasing Lookup column limit from 8

I am facing following problem: 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown. Detail: The query cannot be completed because the number of lookup columns it contains exceeds the ...
0
votes
2answers
1k views

SP2010: How to display a lookup column in a .aspx displayform

I have the two Lists Articles(A) and Serial Inspections(S). The Article-List has columns: Article-#, Name, DescriptionDE, DescriptionEN, somemore... The Serial Inspections: Inspection-#, Inspector, ...
0
votes
3answers
10k views

Lookup column to Documents library

Here's what I need to do for a SharePoint 2010 list: Allow users to select the filename from a dropdown showing the items in the Documents library. But the "Add new item" form of the list doesn't show ...
6
votes
3answers
5k views

BCS External Content Type with 20,000+ items (O365)

We have a large database of 20,000+ items on a local database that we need to get into Sharepoint Online 2013 in O365 to use as metadata for various documents in multiple locations. New entries and ...
6
votes
1answer
1k views

How to Combine IN-Opeator with LookupIds in a caml-query?

I want to build a CAML - Query using the IN - Tag. The queried Column is a lookup-field to a Title of another list. When I query using the text-property everything works fine: <Where> ...
3
votes
1answer
1k 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, ...
3
votes
1answer
4k 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 ...
3
votes
2answers
4k 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 ...
2
votes
2answers
6k views

Workflow condition using a lookup column

I am sure this is something quite simple but I can't seem to figure this out (I am new to SPD and workflows in general). I am building a workflow to notify key individuals of a new item(s) being ...
2
votes
2answers
1k 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 ...
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 ...
1
vote
0answers
492 views

Filter a CQWP on a Lookup Column

I'm creating a custom page layout that contains a CQWP that I'd like to display documents related to the page. The document library has a lookup column that relates to the page title in the Pages ...
1
vote
2answers
12k views

Is it possible to make a lookup column that looks up “Person or Group” type from another list?

I'd like to create a lookup column in my list (hopefully using OOTB functionality) that shows a column from another list. Sounds simple enough, but the available columns to choose to lookup from my ...
1
vote
1answer
706 views

Clear Multiselect Lookup

I am trying to add a button for my users to clear a multiselect lookup value using JQuery or Javascript. I have found some information about setting a default value on a single select lookup, but ...
1
vote
1answer
937 views

Lookup with a custom field type as target

I want to create a lookup field with the sharepoint ui which points to a field with a custom field type (parent field type is number). In visual studio with the object model this is not a problem but ...
1
vote
1answer
3k 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
2answers
651 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?
1
vote
4answers
1k 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 ...
1
vote
1answer
3k 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 ...
0
votes
1answer
693 views

Count number of rows in another list

I have two lists, A and B. I wish to find out the number of rows in list B that have a certain value in list A (through a lookup column) and display this in list A. Is this possible at all using a ...
0
votes
1answer
58 views

Lookup Column of a List Column

I have a requirement for a project site in SharePoint. The Site will have: 1st List: a Stakeholders List with the names of people involved (people/group type) in the project and their Project Role ...
0
votes
2answers
67 views

lookup another lookup

I've 3 lists. List B looks up List A and then I need to create a lookup in List C that lookups List B but also get values in List B that are lookups of List A. How is this achievable? Thanks
0
votes
1answer
326 views

Different sets of options in a lookup or choice column depending on the content type

I have a list content type and other content types that derive from it. I need to add a lookup or choice column to the content type (or the list itself) just so that each child content type or list ...
0
votes
1answer
553 views

SharePoint 2013 lookups with more than 20 items as select or input?

So I was reading about doing some JavaScript to manipulate the default forms for our lists and came across this: ...
0
votes
2answers
3k views

Create Lookup Field Powershell

I am using SharePoint 2013, I need to create a lookup field through PowerShell. I tried this code but is not working: $SiteUrl = "http://mySite" $WebObj = Get-SPWeb -identity $SiteUrl ...
0
votes
2answers
9k views

Coercion Failed: Can't get workflow to send notification to “Assigned To” user

I've created a simple workflow to send a notification email to the "Created By" user which works nicely. What I wanted to do is use the "Assigned To" built-in lookup instead, which is a "People ...
0
votes
2answers
995 views

Choose Username column in Content-Type

In my portal I have two lists. One (we'll call it the people-list) is a list of people's first and last names and their username (person column) if they have one. I have created a content type that ...
0
votes
1answer
1k views

How to get count related Lookup value programmatically?

Another day, another question ;) So, I have two custom Lists, "Attendees" and "Events". In the Events-List there's a Lookupfield "Registrations" which I want to fill programmatically on page_load. In ...