Questions tagged [lookup-column]

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

25
votes
1answer
38k views

How to get a SPFieldLookupValue from an SPListItem?

When you get an SPListItemCollection from a SPList.GetItems(SPQuery) request, and the items have SPFieldUser or SPFieldLookup fields, what is the sexy way to get typed values, not the item["Field"]....
20
votes
6answers
35k views

Why is my column not shown under “Add a column to show each of these additional fields”?

I want to get 2 columns from another list and merge these columns. But when I am trying to do this via Lookup, they are not shown under "Add a column to show each of these additional fields". But ...
17
votes
4answers
68k 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(); item["...
16
votes
2answers
1k 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 (...
12
votes
5answers
16k views

How to display lookup additional field in display form?

I have two lists: Projects and Tasks In the Tasks list, I have created a lookup field titled ProjectID which targets ID filed from the Projects list. Also, I have set for this field to display an ...
11
votes
2answers
31k 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 ...
11
votes
3answers
11k views

How to get the ID of the list item just inserted using ecmascript

I am stuck at a place where I have to update a list which has a Lookup column. For example I am using this code to update my normal list var clientContext = SP.ClientContext.get_current(); ...
10
votes
3answers
3k 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" ...
8
votes
2answers
3k views

Why can I not filter it inside my REST API end point

Inside my Projects list, I have a lookup column named ProgrammeRevissionId that is referenced to my Dept list. When I define the following REST call: http://.../_api/web/lists/getbytitle('Projects')/...
8
votes
1answer
2k 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> &...
8
votes
4answers
4k views

Replace semicolon delimiter in a Lookup column on the list view

When selecting multiple values, the data is separated with semicolons. When many values are selected it starts looking cluttered. Is there any way to have each value on a new line? For example, ...
8
votes
3answers
7k 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 ...
7
votes
3answers
11k views

Deploying List Instance - LookupMulti Type Column in XML

So I have been able to populate rows with Lookup type fields as such: <ListInstance ... > <Data> <Rows> <Row> <Field Name="LookupColumn">2;#...
7
votes
4answers
16k views

Cascading Drop down in SharePoint Online

I'm trying to implement cascading drop down for list in SharePoint online I have 3 different list with name Countries , States, cities. and the master list Address in which I have Fields Country , ...
7
votes
3answers
2k views

Single selection lookup column Vs Choice column of type dropdown

I can not really get my head on when to use these 2 options:- create a lookup column on a list. and set it as single selection. create a choice drop down column. now both will render a drop down ...
7
votes
3answers
877 views

Working around the “Lookup column threshhold”

To level-set, I'm working in a large enterprise with no Farm Admin access or access to SP Designer. I have out-of-the-box capabilities only as owner of a team site. I'm building a roster/schedule ...
6
votes
3answers
7k views

SP 2013 - Updating a multi-value lookup field via the REST API

When adding a new item to list via the Sharepoint 2013 REST API I want to populate one of its multi-value lookup columns. I've tried passing in an array of Ids or a string with separators but nothing ...
6
votes
2answers
14k 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 ...
6
votes
1answer
8k views

SharePoint 2013 - Remove the hyperlink from a lookup column in a list view

I've searched the web and found a solution.... IF I WAS USING 2010 or 2007. I have cascading selections referencing two different lists that hold the dependencies as lookup columns. My cascading ...
6
votes
1answer
199 views

Office 365 Security & Compliance Content Search not finding Keyword if among multi-selected Lookup column

Setup: I created the following: a list (named Category) at the top-level site, a Lookup site column (SC) (named Category) on Category, which allows multiple selections, and a Document-based content ...
6
votes
2answers
182 views

Strategy Queston : how would you implement this calendaring use-case

At my organization there is a process that goes in to preparing for our Board of Director's Meetings that begins 6 weeks beforehand and involves about 9 different steps. We have a template document ...
6
votes
0answers
787 views

SharePoint Online list view threshold error in a lookup column

I am facing an issue with lookup column in the list forms due to list view threshold limit (5000 items). The parent list is having more than 5000 items. Hence the lookup field is not getting ...
6
votes
3answers
3k views

SharePoint 2010 Lookup Column Display issue

I have a simple list with three lookup columns in it. One LC has 5 items and displays as simple dropdown and there are no rendering issues (So ignore this column now). The other two columns has more ...
6
votes
1answer
3k views

set multiselect lookup column using jquery

I have a Multi select Look up column which as you all know is a control with two list boxes and "Add or Remove" Buttons. The user populates the right-hand side of the control with some values by ...
6
votes
1answer
122 views

Custom field type from SPFieldLookup - item values are not appearing in List view

I have created custom field type with SPFieldLookup as a parent class. Using my custom field type, I can able to create custom lookup type columns where source columns are of types: Choice and User ...
5
votes
2answers
16k 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: http://deannaschneider.wordpress.com/2011/11/11/joined-subviews-with-linked-datasources-in-...
5
votes
1answer
13k views

How to increase 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 ...
5
votes
1answer
4k views

Online - Share list data between two sub sites

I'm using SharePoint Online and I have two subsites. One is called Customers and the second site is called Pvt Documents. I've a document library in Pvt Documents where I would like to "link" a ...
5
votes
2answers
584 views

Adding query to lookup the values of the list in search webpart

I have the main department as "Finance" and under that there are several sub departments like "Finance and Accounts","Economics",etc.,The SharePoint users are allocated with their specific department ...
5
votes
1answer
3k views

Client Object Model - Update Document Library Metadata - Lookup Field with no required value

I am attempting to update metadata for documents in a document library (or List) using the client object model. I have whittled down a number of the error messages I was getting and now I am hitting ...
5
votes
2answers
6k 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 ...
5
votes
2answers
10k 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 ...
5
votes
2answers
147 views

SharePoint 2013: Error while creating lookup column

We are using SharePoint 2013. We have two lists in our site: one custom list and one calendar list. We are trying to add lookup column in Calendar list and referencing the custom list. Adding ...
5
votes
4answers
5k views

Search Display Template Not Returning Values for Managed Property

Search results has no value for a custom site column. Ok, so I have a lookup column created as a site column in the root of my site collection. I found the field in crawled properties. NOTE: I am ...
5
votes
1answer
2k views

How to change the color of each column in a SharePoint chart?

How does one change the color of each column in a SharePoint Chart Web part? For example the "passed" column would be green, the "stopped" would be red. I am pulling data from this list: It seems ...
5
votes
1answer
1k views

Sharepoint 2013 - Add lookup column to key filters

I've got a document library of invoices. It has various columns (mainly choices) such as, Year, Status, Location, etc. and I've been able to add them to metadata navigation as key filters. However, ...
4
votes
3answers
18k 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 ...
4
votes
2answers
11k views

lookup column in calculated column formula

I have a Lookup column(Discountfirst) which has Number. I also have another Calculated column(Finaldate) with Resulttype DateTime. One more column(DateofReceipt) in Date. My Calculated column formula ...
4
votes
3answers
21k 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 ...
4
votes
4answers
2k views

How to create web-related lookup field to 'pages' list?

I have SharePoint site collection 'http://microsoft.com/' with few child webs ex: http://microsoft.com/news/ I want to create lookup field to 'Pages' list. On each child web lookup field should ...
4
votes
1answer
450 views

SharePoint 2016 : REST API issue

I have one list which contains cross-site lookup field. I need to filter with this field using REST API. Below is my URL var url = _spPageContextInfo.webAbsoluteUrl + "/_api/web/Lists(guid'" + listId ...
4
votes
3answers
3k views

How to populate Title column with name column content

In a doc library, the Title column is blank but the Name column contains the filename of the document uploaded. I want to concatenate (?) the Title column to auto fill-in what the Name column contains....
4
votes
1answer
2k views

Document Library Lookup Column

I have a sharepoint list of communities. Each community has an owner (people column). I have a sharepoint document library and a view that joins the document to a community. I am not able to ...
4
votes
2answers
6k views

Help with getting the value of a look up field

Currently, I am using an ajax request to access the list items. The fields that are not lookups come as expected but the lookup fields come across as an ID of the object that corresponds to its ...
4
votes
3answers
7k views

Change the source on a lookup column?

Is it possible to change the data source on a lookup column? I have the source set to list A but I want to change it to List B.
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 course,...
4
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 ...
4
votes
2answers
1k views

Expand nested lookups via REST

I know how to expand my lookup using this format: '/_api/web/lists/getbytitle('LookupList')/items?$select=LookupOneId,LookupTwo/Title,&$expand=Lookup' LookupOneId will give me an ID for the ...
4
votes
1answer
515 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' ...
4
votes
1answer
3k 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 ...