Skip to main content
The 2024 Developer Survey results are live! See the results

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.

Filter by
Sorted by
Tagged with
27 votes
1 answer
41k 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"]....
Alexey Krasheninnikov's user avatar
21 votes
6 answers
50k 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 ...
alicanbatur's user avatar
21 votes
4 answers
79k 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["...
John Hansen's user avatar
16 votes
2 answers
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 (...
Dan Tshin's user avatar
  • 505
12 votes
2 answers
39k 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 ...
David's user avatar
  • 131
12 votes
5 answers
21k 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 ...
Boris's user avatar
  • 1,410
11 votes
3 answers
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(); ...
Haseeb Akhtar's user avatar
10 votes
3 answers
4k 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" ...
JL01's user avatar
  • 1,169
9 votes
1 answer
3k 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> &...
Ole Albers's user avatar
8 votes
3 answers
13k 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;#...
RJ Cuthbertson's user avatar
8 votes
2 answers
5k 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')/...
John John's user avatar
8 votes
4 answers
29k 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 , ...
Akshay Dattatray Nangare's user avatar
8 votes
4 answers
5k 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, ...
user avatar
8 votes
3 answers
8k 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 ...
Brent Ellis's user avatar
7 votes
3 answers
11k 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 ...
Phil Laliberte's user avatar
7 votes
3 answers
3k 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 ...
John John's user avatar
7 votes
2 answers
1k 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 ...
Ganesh Sanap - MVP's user avatar
7 votes
3 answers
953 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 ...
Jim Davis's user avatar
  • 261
6 votes
2 answers
11k 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 ...
Allen Rufolo's user avatar
6 votes
2 answers
18k 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-...
Kyle Trauberman's user avatar
6 votes
2 answers
16k 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 ...
Christophe's user avatar
  • 5,301
6 votes
1 answer
18k 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 ...
SPBeginer's user avatar
  • 2,547
6 votes
1 answer
8k 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 ...
Pepozzo's user avatar
  • 1,073
6 votes
1 answer
629 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 ...
Jim Bob Howard's user avatar
6 votes
4 answers
6k 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 ...
Arknev's user avatar
  • 333
6 votes
2 answers
185 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 ...
temporary_name's user avatar
6 votes
1 answer
2k 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 ...
Shekar's user avatar
  • 193
6 votes
3 answers
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 ...
Surendra Chatakondu's user avatar
6 votes
2 answers
4k 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 ...
Ranjani's user avatar
  • 63
6 votes
1 answer
203 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 ...
Dikesh Gandhi's user avatar
5 votes
2 answers
677 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 ...
NivethaSri's user avatar
5 votes
1 answer
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 ...
Matt's user avatar
  • 1,414
5 votes
3 answers
11k 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.
Jjp's user avatar
  • 255
5 votes
2 answers
10k views

How to automatically link parent in child list new form?

I would have thought this would be something I could find easily with a search, but not so far. I have a parent/child relationship between two lists using a lookup column in the child. I have added ...
David Culp's user avatar
  • 1,309
5 votes
2 answers
3k 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 ...
Dinerdo's user avatar
  • 769
5 votes
2 answers
7k 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 ...
Boris's user avatar
  • 1,410
5 votes
2 answers
1k views

Too many lookup columns error - stable list with no new lookups being created or used

Users & 'Full Control' site collection admin are unable to EDIT items. Error message reads: The query cannot be completed because the number of lookup columns it contains exceeds the lookup ...
Tally's user avatar
  • 2,255
5 votes
2 answers
11k 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
1 answer
2k views

Changing the sort order in a lookup field

I'm in an Office 365 SharePoint environment using a custom list. I have a lookup field that displays the title of courses. I'd like to sort it by the date of the course, but it sorts only ...
Steve Morley's user avatar
5 votes
1 answer
5k 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 ...
Mike's user avatar
  • 51
5 votes
1 answer
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, ...
user1416564's user avatar
4 votes
3 answers
21k 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 ...
adhoclobster's user avatar
4 votes
2 answers
14k 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 ...
user1514428's user avatar
4 votes
1 answer
800 views

What limitations should I keep in mind when choosing between single line of text or choice columns?

I have a SharePoint online list that will be populated with data from a Form (MS Forms) via Power Automate. I have some choice (single select, multi-select and yes/no) fields in the form, but before I ...
Darryl's user avatar
  • 146
4 votes
2 answers
874 views

To overcome threshold error on lookup fields, is it recommended/supported if i only store the parent ID inside the child records inside numeric field

I have 2 lists Child and Parent inside a SharePoint online site, where the child list has a lookup field to the parent list. Currently the parent list has 8,000++ items as follow:- so now when i ...
John John's user avatar
4 votes
3 answers
27k 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 ...
Logan2847's user avatar
  • 149
4 votes
4 answers
3k 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 ...
Ievgen's user avatar
  • 360
4 votes
1 answer
487 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 ...
DRS's user avatar
  • 722
4 votes
1 answer
3k 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 ...
user49852's user avatar
4 votes
2 answers
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 ...
user24005's user avatar

1
2 3 4 5
24