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
17
votes
4answers
69k 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["...
7
votes
4answers
17k 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 , ...
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 ...
1
vote
3answers
16k 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....
3
votes
5answers
24k 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 ...
2
votes
2answers
18k 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 ...
0
votes
1answer
3k 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 ...
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 ...
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 ...
3
votes
2answers
12k 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....
1
vote
2answers
820 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?
1
vote
2answers
9k 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 ...
8
votes
1answer
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> &...
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.
2
votes
1answer
92 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 ...
2
votes
2answers
4k 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 ...
2
votes
1answer
1k 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='...
2
votes
1answer
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 ...
1
vote
1answer
431 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 ...
1
vote
2answers
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 ...
1
vote
2answers
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?
1
vote
4answers
29k 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 ...
0
votes
2answers
13k 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 ...
0
votes
2answers
2k 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. ...
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
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? ...
1
vote
2answers
5k 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
1answer
4k 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 ...
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 ...
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 ...
3
votes
1answer
11k 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 ...
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
529 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 ...
1
vote
1answer
2k views

Fetch Username from Lookup-Column using Powershell

In my powershell script, I have a method that fetches a username from a sharepoint list. This works fine - my problem is that field is from a lookup column. The user chooses the username from a ...
1
vote
2answers
18k 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 ...
1
vote
3answers
16k 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 ...
1
vote
1answer
1k 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 ...
0
votes
2answers
2k 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, ...
6
votes
2answers
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
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 ...
4
votes
3answers
22k 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
1answer
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 ...
3
votes
1answer
519 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 ...
3
votes
2answers
17k 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 &...
2
votes
1answer
1k 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 ...
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 ...
2
votes
1answer
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 ...
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
1answer
1k 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: http://geekswithblogs.net/SoYouKnow/archive/2011/04/06/setting-sharepoint-drop-down-...
2
votes
3answers
8k 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 ...