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)

2
votes
0answers
28 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 ...
1
vote
0answers
42 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
1answer
42 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 ...
0
votes
2answers
47 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
23 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
112 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
58 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 ...
0
votes
1answer
83 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
0answers
50 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
42 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
50 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
112 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
21 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
26 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 ...
0
votes
0answers
67 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 status ...
0
votes
0answers
51 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
41 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
39 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
25 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
33 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
42 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
49 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
56 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
57 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
101 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
97 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
238 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
46 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
104 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
33 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
53 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
28 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
57 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
56 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
53 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
51 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
45 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
73 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
50 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
18 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
32 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
40 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
104 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
47 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
43 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
55 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
30 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
55 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 ...