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
1answer
41 views

Lookup to Person Picker field

I'm trying to do a lookup to a person picker field in another list, but SP2013 won't show me that column. Any thoughts on how to bypass that?
0
votes
0answers
27 views

SharePoint 2013 Lookup field and workflow

I have currently the problem that I can not see in a workflow the additional fields from the lookup colum. Although I see my field lookup, but not the additional fields. Why the whole? I have on a ...
0
votes
0answers
39 views

List Add Form-Lookup column selection box cutting off options

I have a Sharepoint 2013 list with a multiple select look up column and the form fields for selecting and adding data items to a new or existing list item are cutting off the lookup text. See below: ...
0
votes
0answers
16 views

Connect an OOB DisplayForm WebPart to a DVWP on a lookup field

When trying to connect an OOB WebPart to a DVWP and send the value of a lookup field it sends the value like "ID;#Title". The problem is I cannot use this as a filter in the SelectCommand to filter on ...
0
votes
2answers
41 views

Lookup Column Question

I am new to SharePoint so please bear with me. My environment is Sharepoint 2103 standard (Planning upgrade to Enterprise soon) on premise with separate SQL server 2014 installation. I've built ...
1
vote
1answer
65 views

Create Lookup + Calculated column

I've an issue on calculating lookup value from other list.. I have List called "Product". in that I have column name "ProductCode"(Single line text) and "Unit Price"(number with 2 decimal). I've ...
6
votes
3answers
2k 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 ...
0
votes
0answers
59 views

How to update existing list lookup column reference through powershell

How to update existing list lookup column reference through powershell. I wrote the following code to add lookup column. Now I need to update column reference. $myCustomList =$_.Lists["Test A"] ...
1
vote
0answers
30 views

Auto generate sequence column + a look up info column from another list and calculate in Sharepoint 2013

I've an issue on calculating lookup value from other list.. I have List called "Product". in that I have column name "ProductCode"(Single line text) and "Unit Price"(number with 2 decimal). I've ...
0
votes
2answers
100 views

Set LookUp Value using Jquery in Default List Forms

I am trying to set Look Up Drop down using JavaScript/Jquery. I am able to set the value but while saving by default 1st option in drop down is Set. Thanks in Advance...!!!
1
vote
1answer
72 views

Sharepoint 2010 Workflow send email after list item creation

I'm creating a custom workflow for my team in SharePoint 2010. When someone edits a list item and sets a value to "New" then a new item is created a different list. I would like to email the user and ...
0
votes
0answers
27 views

make lookup option only available if status not completed

I'm creating a way to tag documents against projects, so I've created a list for the projects and numerous libraries that access the list as a lookup for tagging purpose. The list also has a status ...
0
votes
0answers
20 views

How to add addition column info to a lookup field's form dropdown

I have a Sharepoint List MyList, that has a Lookup Field to another sharepoint list, MyLookUpList In the dropdown, one of the MyLookUpLIst's field is displayed (say ID or Title) but I want more info ...
0
votes
0answers
30 views

lookup displaying (None)

I have a library with a lookup column, when I add a document a edit form is presented and the lookup is available however the first item in the lookup is (none). If I then try to make this a required ...
3
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 ...
1
vote
1answer
107 views

Create a LookUp Column using SPServices “UpdateList” operation

I want to dynamically add a new list ("AddList" operation), and then use the SPServices "UpdateList" operation to add "newFields". I was able to get the "Text" fields to add properly, but the LookUp ...
2
votes
0answers
58 views

How to use a lookup column's additional field in a workflow?

Background I have two lists. One is a list of voltages and their corresponding costs. This is to be used as a lookup for other lists. Voltage Cost 120 2.50 240 ...
0
votes
2answers
178 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. ...
1
vote
2answers
109 views

Filter Lookup from another lookup

I have a list of projects. Inside the project list you can select a Client. I have a list of Clients. I have another list, a list of Contacts, they have a lookup column called Client to specify from ...
1
vote
1answer
42 views

Function to run when drop down is clicked

I have a lookup field. I need to filter the values in that drop-down, so I thought of writing function when the drop down control is clicked. Something like. ...
0
votes
0answers
58 views

Get Lookup Value in SharePoint 2013 List

In Sharepoint 2013, I have 3 lists containing these fields: Part Data: Part Number (a lookup field) Supplier Number Buyer Number Parts : Part Number Supplier Number Suppliers : ...
0
votes
0answers
159 views

How to remove duplicates from a lookup field in SharePoint 2013 online?

I have a lookup field which is created from the same document library and it is a multi selection lookup field. The values in Lookup having duplicate values. Are these duplicate values are showing ...
0
votes
2answers
57 views

Different Users ID on each sites

I actually have a site we will call "Team" and one we'll call "Direction" And a list "Projects" in each of those sites. I wrote scripts to make save of each sites, looking if there are new entries in ...
1
vote
1answer
88 views

How to remove hyperlinks in the Look up field

How do you remove hyperlinks in the Look up field using jQuery in SharePoint?
2
votes
0answers
31 views

Does the total amount of lookups affect performance in a CAML query that has less than 8 lookup columns?

I have a large library with 12 lookup columns, and while I only use 6 of these columns when I retrieve data from this library (in a CAML query), the retrieval process often takes 20-30 seconds. Would ...
0
votes
0answers
37 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
46 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 ...
1
vote
2answers
4k views

Sharepoint 2010 and Infopath form : lookup fields are displayed by their ID instead of text value

I'm trying to build a custom Infopath form for a list that contains 2 fields that I would like to get auto-completed: Person: people picker field, filled with the current user Team: lookup to the ...
0
votes
1answer
147 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
72 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
91 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
25 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
135 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
49 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
62 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
38 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
239 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
24 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
814 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
79 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
47 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
71 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
32 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
36 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
60 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
64 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
61 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 ...