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)

0
votes
0answers
39 views

Look-Up a Multiple Line of Text Column

I am looking for a solution that allows me to refer a multiple line of text column to another list in the same Site Collection. I find a lot stuff about SharePoint 2010 where it wasn't possible to ...
2
votes
2answers
3k views

How to Find Lookup field list using Programmatically

How to find the list that a particular lookup column in a list is bound to, programatically?
1
vote
0answers
47 views

Auto Fill Lookup Column

I believe I am starting off on the right foot by using a lookup column. I am seeking a way for when a user enters in a order number the number auto populates in a choice column. So basically every ...
0
votes
1answer
174 views

Clear multi-value lookup via Jquery SP 2013

I am trying to clear a multi value lookup field using javascript when an item is re-edited. I have tried all the following combinations without success $("input[id^='Test'").removeAttr(); ...
0
votes
3answers
75 views

What is wrong with the lookup in my InfoPath Form?

I have SharePoint Online list which I am customizing with an InfoPath form. Two of the fields on the Form are lookup fields with a secondary Data Connection to a second SharePoint List with Fields ...
1
vote
1answer
115 views

Validate text column against [Me]'s Display Name

I have two lists in SharePoint 2013 Trips Drivers Drivers has a column called Active Driver that is a single line of text formatted "Lastname, Firstname". Drivers also has a separate column that ...
1
vote
1answer
26 views

Add column to new document library template

a was trying to found a way to add a new column to List / Document L template!? I want to add a lookuop column to this view, is it possible ?
0
votes
1answer
159 views

Lookup on same list

Are there a way OOTB if i have a lookup on my own custom list. If i select an other item. The other item is automatically linked. For example. I have list "test" with a lookup on "test" (so same ...
0
votes
0answers
52 views

Validate over-20 dropdown lookup column

I have a lookup column with over 20 items so it displays the more complex (input element) dropdown menu. The trouble I'm having is that users can type anything into that input, even if it does not ...
2
votes
1answer
68 views

Multiple Choice Columns-Checkboxes. Is there a different format?

I have a column which uses a lookup to another library. I need the user to be able to make multiple selections based on this lookup, however the problem I have is that this library contains hundreds ...
0
votes
2answers
39 views

Searching a lookup list

I have a lookup which looks at a list of clients and project numbers, and is rather large (around 500 and growing), and I was wondering if there was anyway to search the results of the list lookup ...
1
vote
3answers
288 views

How to insert data into lookup column using javascript

I have created a custom drop-down list and inserting drop-down data into lookup column(in a list). How to insert drop down data into a look up column? I am trying below code but it is not working. ...
0
votes
0answers
25 views

Help with establishing list relationships between sites

I need some advice on allowing my lists to lookup information from parent lists. Parent Site: List: Employees List: Departments Employees primarily contains single lines of text. (fname, lname, ...
0
votes
0answers
28 views

CustomNew form additional lookup field

I'm not SharePoint developer, i'm just trying to add more info to my default new form but my knwledge is limited : Ok, i have list A called 'Service', and list B called 'Purchase'. I have lookup ...
2
votes
1answer
817 views

Clear all values in a multi-value lookup, via REST, SP 2010

Conditions: SP 2010, html/javascript, using REST to read/write to various lists. Im using a jquery multiselect plugin to set a multi-value lookup column. I need the selecting Groups of items, easy ...
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 ...
0
votes
0answers
84 views

Dynamically Show the values in Drop-down Menu based on user name

I have a custom task list with a column that is designed as a drop-down menu (values: a, b, c) and a column "Assign To". My design goal is when users try to edit this list via the form, SharePoint ...
0
votes
0answers
52 views

SPD13 - Need Calculated column to include a lookup column in formula - workflow option

I have created a custom list called Account Code (which has 2 columns) Account Description Account code I have created another custom list called Codes (which has a few columns). Users will be ...
0
votes
0answers
77 views

Associating content type containing lookup site column to custom list programmatically using CSOM ERROR: Value does not fall within the expected range

I have created a list using CSOM - works fine. & associated a content type(Without Lookup Column) - works fine but If there is any lookup column associated with Content Type & when I try to ...
0
votes
1answer
38 views

Columns missing in LookUp target list

I'm in a project using SharePoint Online and want to add a lookup column type, but when trying to relate it to a specific list, show me a few columns in the list which has more than 30 columns, I ...
0
votes
1answer
38 views

SP13: Lookup column with multiple selections

In SP10 and later this was not possible, but it's hard for me to find if Microsoft has made it possible in SP13. I have created a lookup column and wanted to be able to select multiple choices from ...
2
votes
1answer
67 views

Exporting a list with lookup fields

I'm in a situation where I need to export 2 lists from site Site A to Site B. The lists I'm exporting have a lookup relation. List X has a lookup to List Y. List Y gets imported to the new location ...
1
vote
0answers
68 views

display lookup multivalue in quickpart

I have a lookup field with multi value. I'd like using quick part in my template (i know how to use quick part) But i need displaying multiple value (lookup multisel) in a dynamic table. How can i do ...
0
votes
0answers
65 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 ...
2
votes
3answers
4k 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 ...
0
votes
1answer
197 views

How to remove link to Lookup field in default DispForm

I have a list, with several fields, including a Lookup field. I display the items of the list on a custom webpart. Everything works fine. When I click on an item in the web part, the default DispForm ...
0
votes
3answers
83 views

Best Practices to declaratively create Lookup Fields in a solution

I am often coming to the point that I need to create lookup fields pointing on lists which are also created in the solution. There are many ways to do it either by using feature receiver or by using ...
0
votes
0answers
106 views

Add multi valued lookup column into another list using sharepoint 2013 workflow

I have a requirement where I have two tables(say A and B) and one master table(say Tech). Both the list contains tech as multiple value lookup column and another column say status on which the ...
2
votes
1answer
176 views

Remove Hyperlink for Multi Value look up column in Sharepoint

How can we remove hyperlink from a multi value look up column in SharePoint 2010 list. There are article on removing hyperlink from Single Value look up column. But I am not able to get a way to ...
1
vote
1answer
174 views

Lookup With Picker Not Working

I have a document library on SharePoint 2013 that has a column that is defined as type "Lookup with Picker" that looks at a list within the sub site. I have no idea if this is a SharePoint ...
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 ...
1
vote
1answer
452 views

How to call SharePoint Rest Service with CAML and Lookup column [duplicate]

I am trying to query sharepoint list which is having Lookup columns. So to do so I am using below JavaScript function function getDataWithCaml(oDataUrl, caml) { var requestData = { ...
0
votes
0answers
69 views

Sharepoint Lookup List (Double lookup?)

Context: Duty manager list, changes weekly. I have two tables: Table 1 is a list of all managers, their department name, and their mobile. (Columns: Manager Name, Department, Mobile number) Table 2 ...
0
votes
3answers
128 views

CAML Lookup - get different value from lookup list using query

Say I have two lists: Support Pack ID : 1, SupportPackTemplateLookup:(ID#OtherValue), IsActive : True Support Pack Template: ID : 1, OtherValue: x, SuppType: 10 hr support pack ID : 2, ...
0
votes
2answers
350 views

Numeric field in SP displaying 10 as 10.000000 how do i remove that?

I have a list look up column which fetches values from another list which is number(int), but on loading it takes it as a flaoting number. for example the value in list firld in 10 but it is taken as ...
1
vote
1answer
48 views

How can I put a “Lesson number” in a column field based on time item created

I have a list being used for a school to record when a student is out of class. I want to create a column in this list called "Lesson" and have this automatically be filled based on the time that the ...
2
votes
0answers
38 views

Lookups in SharePoint Workflow Emails

I've created a workflow that sends an email to all users when any new item is added to my "Payroll Processing" list. I want to be able to display the Client Name in the email that gets sent. The ...
1
vote
2answers
66 views

How to determine which field is lookup field via REST API

I have to load data from various lists with various views via SharePoint 2013 REST API. I have no knowledge about fields that are configured in views (general fields, custom fields, lookup fields, ...
0
votes
1answer
15 views

Title of column/standard metadata links to list where metadata are managed

For a starting up site I would love to ad a link in the table to the location where I manage the metadata from that column (I use a lookup column, so the source is a list) The goal is to give my ...
0
votes
0answers
33 views

The additional field I have added to my Lookup Site Column isn't showing up in my list?

I am using a lookup site column in my LIST2 that also automatically picks up other fields from the original LIST1. I have now added an additional date field from LIST1 to my site column - but it isn't ...
1
vote
0answers
62 views

Secondary lookup columns missing in Display/Edit form view

I have one list that has a lookup column for 4 different lists. Each lookup column also brings in a secondary lookup column which is a Calculated Column. I can bring both the lookup column and the ...
1
vote
2answers
679 views

Extracting text from a lookup field in a SharePoint 2013

I switched from InfoPath to the Designer forms. In the list i have a Lookupfield that Points to another list. In the Control modes Edit and New the select boxes are created automatically using the ...
1
vote
1answer
158 views

Does SharePoint Online have a lookup column threshold?

My understanding is SharePoint Foundation, Server, and Server Enterprise have a default lookup column threshold of 8 to listview. I thought this would be an easy thing to locate online, but I haven't ...
0
votes
1answer
113 views

Get selected Value from Lookup Dropdown on ItemAdded

I am attempting to grab the text value of a lookup dropdown after an Item is Added. The way I'm currently doing this, gives me the string 23#ADMIN, which is the combined ID and text. I could go the ...
1
vote
1answer
2k views

Add new item to child list and refresh the parent form - multiple lookup

I've created a parent list (Vendors) and a child list (software list). There can be multiple vendors for one piece of software. I've created a custom new form with a link which opens up a modal to add ...
2
votes
1answer
62 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 ...
3
votes
2answers
3k 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 ...
0
votes
0answers
108 views

Advanced Search on a lookup column

I am looking to customize the advanced search web part to allow users to search on a property which is a lookup. I have managed to find the crawled property, mapped it to refinablestring00. Then I ...
1
vote
0answers
60 views

Why aren't the addition field columns populating when I select a value from a lookup column?

I have an Equipment List that looks like this: Number Description Mill Area 1 pump warehouse 2 motor outside 3 shaft yard 4 bearing ...
0
votes
1answer
24 views

Can I stop Filter Items from truncating on Column Filter Dropdown (…)

I have a Lookup field on a Library which is related to a List of Items. After these items reach a certain length, the items in the Filter Dropdown get truncated, and a '...' is added to the end of ...