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
21 votes
4 answers
78k 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
8 votes
4 answers
28k 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
1 vote
3 answers
17k 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 = list....
domueni's user avatar
  • 427
12 votes
2 answers
38k 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
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
3 votes
5 answers
25k 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 ...
newtosharepoint2013's user avatar
3 votes
2 answers
36k views

Use a LookUp field in a Calculated Column

I have a SP2013 Server but have not been authorized to install SPD2013. I have a list [Web Team Tasker] which has a lookup column containing data from a list on a parent site as well as some ...
TroyPilewski's user avatar
0 votes
1 answer
10k views

Autofill column values of a list based on another list column value

I am an newbie to JS, SP Services and JQuery. I am on SharePoint Online environment. I have a List A with columns Title (Text Field), Location (Choice field) and Event Date (Date field). I have a ...
AXA240778's user avatar
  • 499
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
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
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
3 votes
2 answers
14k 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 Products....
Cory M's user avatar
  • 354
2 votes
1 answer
2k views

How to get Lookup ID from Search API with REST

I'm trying to get the ID of a lookup field when using search api. My query looks something like this: /_api/Search/query?querytext='ListId:12345678-1234-1234-1234-123456789012'&selectproperties='...
eirikb's user avatar
  • 7,405
2 votes
2 answers
6k views

Drop down lookup field search

I've got the following scenario: List A contains several thousand items, List B has a lookup field to List A. When a user is creating item in List B she has to select the List A item via the mentioned ...
Lukasz's user avatar
  • 23
2 votes
1 answer
1k 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 ...
Aamir's user avatar
  • 411
2 votes
1 answer
725 views

restore sharepoint list lookup value

I have simple Sharepoint list named Alist with lookup value column. the lookup value column returns fields from other list named Blist. accidentally I have deleted this Blist and in Alist all lookup ...
Vaso Miruashvili's user avatar
1 vote
2 answers
3k 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. ...
bgmCoder's user avatar
  • 3,581
1 vote
2 answers
1k views

Making SharePoint lookup field auto complete

Can we make a SharePoint field which is a lookup drop down box on the editform.aspx. have the functionality so that user can type in and select from the options based on the values of the types?
SandeshR's user avatar
  • 1,992
1 vote
4 answers
44k 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 ...
Alex's user avatar
  • 1,089
1 vote
1 answer
819 views

Copy value from Lookup (CountRelated) column to another 'Number' column

I'm trying to visualise data using Google charts, but it won't work with Lookup (count related) columns, so I'm trying to convert those values to Numbers using workflow and that won't work either ...
Maciek's user avatar
  • 115
1 vote
2 answers
11k 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 ...
Ben McDougall's user avatar
1 vote
2 answers
7k 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?
Arun's user avatar
  • 41
1 vote
2 answers
2k 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 ...
JadedEric's user avatar
  • 523
0 votes
2 answers
14k views

How to implement Cascaded lookup in SP 2010?

In sp 2007, I have used jquery to do the cascade. But now I hear sp 2010 provides cascaded lookup. I have 3 level to drill down (Country > State > City). Is/are there any good instruction on how to ...
Roxanne 's 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
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
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
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
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,273
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
2 answers
19k 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 &...
Humble Val's user avatar
4 votes
1 answer
5k 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 ...
Alex C's user avatar
  • 4,395
3 votes
1 answer
4k 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? ...
newbie's user avatar
  • 1,737
3 votes
1 answer
684 views

Workflow doen's send email to person field

I need to configure a workflow which would send an email on item creation to the user in Person field of that item. So I've opened SPD, created a new workflow on that list, selected Send an Email ...
Gintas K's user avatar
  • 1,227
3 votes
0 answers
13k 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 ...
Kris Van den Bergh's user avatar
3 votes
2 answers
7k views

Limit to the amount of values you can have in a lookup field?

Is there a limit to the amount of values I can lookup? When I search for the topic I only get hits on the number of lookup fields you can have in a list. I have tested this a bit and it was ...
Jordan's user avatar
  • 2,804
3 votes
4 answers
9k views

Calculated column that updates daily

Is there a way to make a column in a list that updates daily with the current date? If not what's the best way to do this? I was thinking of using the 'Lookup' field to link to the calendar that's on ...
PT_C's user avatar
  • 269
3 votes
2 answers
965 views

Self Referencing Related Documents Library Through Lookup Column

I am trying to create a single document library that links to documents in the same library in SharePoint 2010 Server. I've created a multi-value lookup column that references the same library to ...
Rob's user avatar
  • 31
3 votes
3 answers
4k 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 ...
user avatar
3 votes
1 answer
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 ...
Deepak Semwal's user avatar
2 votes
3 answers
7k views

How To Update Multi-value Lookup Column in SharePoint List using Power Automate

How we can update SharePoint list Multi-value Lookup Column using Power Automate Flow?
vandana agrawal's user avatar
2 votes
3 answers
9k views

Can a SharePoint 2010 lookup column point to a multi-line rich text field from same list

Can a SharePoint 2010 lookup column point to a multi-line rich text field in same list? i dont find multiline column while creating a lookup column. Is there any way to achieve this. Because my ...
Arul's user avatar
  • 133
2 votes
1 answer
1k views

Access lookup Site column from subsite

Is it possible to create a lookup site column at root site and access it from its subsite? I created it using site column template at root site and it was accessible at root site when added it to a ...
Sooraj's user avatar
  • 33
2 votes
2 answers
470 views

How to add a lookup column to a Sharepoint list?

I have 2 Sharepoint Lists: Entidades: Entidade_ID | Nome 1 | ABC 2 | DEF And Diario: Diario_ID | Entidade_FK 1 | 2 2 | 1 3 | 2 I want to add a ...
Delete my account's user avatar
2 votes
2 answers
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 ...
suresh's user avatar
  • 21
2 votes
1 answer
2k 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 ...
hrezs's user avatar
  • 301
2 votes
1 answer
2k views

If [LookUp] equals [String] doesn't always work. Sometimes I have to use [1;#String] instead, why?

I am using SharePoint Designer 2010. I created a workflow in which I needed to test the value of a lookup column. I (perhaps naively) simply tested if the lookup column equals the literal string I ...
S. Melted's user avatar
  • 123
2 votes
2 answers
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 ...
user avatar
2 votes
2 answers
2k views

Sharepoint REST API empty value on expanded lookup columns causes error

I have a list with lookup columns. When I get an item from the list and expand the lookup columns, I get an error if any of the lookup column values are empty. For example if I have a list with the ...
Frank's user avatar
  • 241