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
140 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 ...
2
votes
1answer
76 views

SharePoint 2013 and O365: Lookup column Value ID missing

Okay, this is my first question so forgive me if this is long winded. TLDR: I cannot seem to be able to target or get the Value ID of the Category Column in a blog post rollup. Why is this? ...
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
65 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 ...
1
vote
3answers
255 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 ...
1
vote
1answer
98 views

Displaying multiple column data in a drop down menu

I'm using SP2010 unfortunately without SP Designer and only used InfoPath once. I have 2 lists: List A - Is a list of 'Event Codes' with a 'status' column displaying Active, Used or Reserved ...
0
votes
0answers
80 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
73 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
34 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
62 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 ...
0
votes
0answers
62 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 ...
0
votes
3answers
79 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
97 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
167 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
160 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
1answer
411 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
65 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
122 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, ...
2
votes
0answers
36 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
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 ...
1
vote
2answers
61 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
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
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 ...
1
vote
1answer
132 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 ...
1
vote
0answers
61 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 ...
0
votes
1answer
86 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 ...
2
votes
1answer
60 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 ...
0
votes
0answers
104 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
58 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 ...
0
votes
1answer
43 views

Order of Items in a single feature

Can we set order for items in a single feature? I was trying to create a site column of type lookup for which the lookup-list should be created first after that only we can create the column. In my ...
0
votes
1answer
46 views

Allow Posts and Discussions to use same Categories lookup field

I am creating a Community site and activating the BlogContent feature on that site. There are conflicting issues, because the Community Site and the BlogContent feature both create a Lookup List ...
0
votes
1answer
138 views

Invalid Lookup Values Found Error

I have a simple list with a non required lookup column. If I try to create a new entry in the list with the lookup column left as "none", I receive the error: The list item could not be inserted ...
0
votes
0answers
55 views

List information lookup from a different Site Collection

On one Site Collection, I have a directory (list) of all the other sites. Site Name, Primary Owner, Secondary Owner, URL, Date Created... I would like to have a web part on each site that would ...
1
vote
1answer
44 views

List form or Infopath filtered choice column

I'm about to start building a custom list to capture a number of different query types. I was intending to do this with some custom Site Content Types but I've realized that I'm going to need to ...
0
votes
0answers
61 views

Show only chosen options from multi choice column in another colum as choices

I have column 1, multichoice column and from that column I choose few choices which I want to be seen in another column 2 (choice field also) (it can be in same list or in different, doesn't matter). ...
0
votes
1answer
14 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 ...
1
vote
0answers
36 views

How can I change the Mobile View “lookup” list threshold?

I came across a limitation when using "Mobile View" where my lookups were displaying a maximum of 20 items. This only happens in mobile view. How can I change or remove this threshold limitation? ...
0
votes
1answer
62 views

Create a simple order list in 2010?

I am new to SharePoint 2010 but have some excel and access experience. I have a requirement to create an order list(List A) for storing products and quantities. The product field is a lookup column ...
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 ...
0
votes
0answers
94 views

Cascade delete from lists

I have 3 lists with a lookup field to a document library. This fields is created from XML (deployed) with this properties: Indexed="TRUE" RelationshipDeleteBehavior="Cascade" Now, what I would ...
1
vote
1answer
30 views

Programmatically add multicolumn lookup

For example, I have two lists: Users (Login, Password) and Profiles (Phone number, Email). So we have users and related info in their profiles. Now I want to create another view for users, that ...
0
votes
0answers
21 views

Lookup column displaying 0000000 in datasheet view

List A has a number column which has been looked up in List B. In datasheet view (only), the lookup column in List B displays 0's. For example, the value of List A is just 3, but in List B datasheet ...
1
vote
0answers
39 views

Sharepoint 2013, cascading lookup/dropdown what happens with old data if data changes

Situations tend to change, so sometimes cascading dropdown menu's get adapted because they are no longer relevant ... My question is: what happens with metadata based on the old cascading dropdown ...
0
votes
1answer
87 views

Version History does not update when lookup changes - how to fix?

The problem: I create a document library and a custom list, then use the custom list as the source for a lookup column in the library. Now I add a document to the library and set the value of the ...
3
votes
0answers
101 views

Creating cascading lookup columns in sharepoint 2013 foundation

I am trying to create cascading lookup columns in my library. I have already tried to use a jquery solution: http://www.codeproject.com/Tips/758909/Two-Level-Cascading-Drop-Down-in-SharePoint-using, ...