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
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 ...
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
181 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
78 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
95 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
161 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
154 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
396 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
63 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
118 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
337 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
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
2answers
60 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
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 ...
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
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 ...
1
vote
2answers
634 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
123 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
85 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
58 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
103 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
56 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
23 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 ...
2
votes
2answers
2k views

SharePoint 2010 difference with lookup columns

I recently upgraded my site from SharePoint 2007 to SharePoint 2010. The first issue I noticed was that the "lookup" columns in "Display view" showed up as the hyperlink instead of the string. ...
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
136 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 ...
1
vote
0answers
35 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
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
2answers
293 views

Looking for an additional feature - Cross site lookup field

We want to implement the cross site lookup in our environment and decided to use the solution available at http://sp2010filteredlookup.codeplex.com. Unfortunately, there is a missing feature that ...
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
1answer
61 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
1answer
361 views

Look-up from library to task list

I'm having problem with field look-up from document library to task list. Task created automatically with workflow when I creating item in Library. Could you ple help me with this matter? Please refer ...
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 ...
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
38 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
85 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
99 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, ...
0
votes
0answers
65 views

Sharepoint 2010 List and Data Sheet Views show no data for “Lookup” column types

I have a created a custom list "Truck Check" that uses several lookup columns that refer to an "Asset Tag" list. When users add a new item to "Truck Check" they fill out an InfoPath web form ...
2
votes
1answer
322 views

SharePoint Online: How to configure search to enable refiners on a lookup column

I have a list of location names at the root of a site collection. I have a site column at the site collection level that is a lookup to the locations list. In sub sites I use the site column in ...
0
votes
1answer
570 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 ...
0
votes
0answers
31 views

Move sharepoint library to another site

I want to move a SharePoint library (2010) to another sitecollection. The problem is that this document library has lookups to other lists, has fields/contenttypes (some were deployed in a solution, ...
0
votes
0answers
76 views

Passing multiple checkbox values to other web part lookup?

I have a web part where the user can create a new item and select multiple checkboxes, displayed in a column with the following format: Choice 1; Choice 2; Choice 3 The issue that I'm having is ...
1
vote
0answers
67 views

SharePoint 2013 choice column DropDownlist

Is it possible to update a Choice column with workflow ? I have created a list and created a lookup column that displays the name Company. I have connected the column to a document the Library of ...