A lookup column is a SharePoint list column that retrieves its available values from another list in the SharePoint site.

learn more… | top users | synonyms (1)

0
votes
1answer
2k views

Workflow condition using a lookup column

I am sure this is something quite simple but I can't seem to figure this out (I am new to SPD and workflows in general). I am building a workflow to notify key individuals of a new item(s) being ...
0
votes
0answers
9 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
13 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
298 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 ...
0
votes
0answers
9 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
11 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
21 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 ...
1
vote
1answer
19 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
1answer
578 views

Secondary lookup columns for external content types not displaying data in list after refreshing from primary

I have created a SharePoint list that has a lookup column to an external list. I also have instructed SharePoint to display several secondary columns that are related to that primary external lookup ...
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
12 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
24 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
11 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 ...
1
vote
1answer
1k views

Sharepoint 2010 - Workflow, return field as Lookup Values, Comma Delimited getting both lookup id and lookup value

I'm working on a simple workflow in SPD 2010 which is going to send an email to multiple recipients based on lookup values and even though I set the "Return Field As: Lookup Values, Comma Delimited" ...
0
votes
1answer
18 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
14 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 ...
3
votes
1answer
965 views

BDC List column picker filter - search/filter not working and exact entry says not found?

I'm working with MOSS 2007. Rephrasing the question. I have a BDC column to an external datasource in a custom list. Today searching and filtering is not in place and actually exact matches are not ...
0
votes
2answers
753 views

Problem copying lookup column data from one list to another via PowerShell

I have the below script that works for moving list data between two lists on sites next to each other that have the same schema. Everything works perfectly bar a column of type LOOKUP named "Name of ...
0
votes
1answer
35 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
18 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? ...
2
votes
1answer
578 views

How to change the color of each column in a SharePoint chart?

How does one change the color of each column in a SharePoint Chart Web part? For example the "passed" column would be green, the "stopped" would be red. I am pulling data from this list: It ...
2
votes
1answer
1k views

content query web part with multi value lookup column

I am trying to work out how I can query a content type with a multi value lookup field using the content query web part. I know that natively this is not possible with ootb sharepoint 2010 however I ...
1
vote
1answer
656 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 ...
0
votes
0answers
21 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
31 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
25 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
0answers
10 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
2answers
288 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 ...
0
votes
1answer
2k views

How to return field from specific workflow task as Data source in Lookup tool?

In short . . . How do I do this: ? In Step 1 of my workflow, the first action is to create/assign a task with Task ID of TaskID1. For the next action, how do I assign a field the value of a ...
1
vote
2answers
906 views

Help with SPCascadeDropdowns cascading lookup column

I have this jquery added to my editform.aspx in SharePoint. I want the childcolumn to also have unique values, although it may contain duplicates example below. Example. When I select mycountry, I ...
1
vote
1answer
25 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
2answers
6k views

Coercion Failed: Can't get workflow to send notification to “Assigned To” user

I've created a simple workflow to send a notification email to the "Created By" user which works nicely. What I wanted to do is use the "Assigned To" built-in lookup instead, which is a "People ...
1
vote
1answer
800 views

Document Information Panel contacted a data source but failed to receive data. The form will load without the requested data

The query cannot be run for the following DataObject: list_48985ACC-FDDD-4732-AA48-078CFE123F35 Document Information Panel cannot run the specified query. The SOAP response indicates that an ...
0
votes
1answer
39 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
0answers
17 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
1answer
456 views

Conditional formatting lookup column

I am attempting to do conditional formatting in a list view in SharePoint Designer. In this list I have a list that contains a lookup column, and other columns derived from the list of that lookup ...
0
votes
2answers
44 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
14 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
14 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
25 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
37 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 ...
1
vote
1answer
2k views

set multiselect lookup column using jquery

I have a Multi select Look up column which as you all know is a control with two list boxes and "Add or Remove" Buttons. The user populates the right-hand side of the control with some values by ...
3
votes
0answers
59 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, ...
7
votes
5answers
12k views

Why is my column not shown under “Add a column to show each of these additional fields”?

In SP2010, I want to get 2 columns from another list and merge these columns. But when I am trying to do this via Lookup, they are not shown under "Add a column to show each of these additional ...
0
votes
0answers
16 views

Website Content Type Lookup Column

I'm looking for a way to add a column (Column2) to my custom Website content type which can lookup a column (Column1) and based on the content display different values in a dropdownmenu: Column 1 ...
0
votes
0answers
14 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 ...
1
vote
1answer
584 views

SharePoint 2013 - Remove the hyperlink from a lookup column in a list view

I've searched the web and found a solution.... IF I WAS USING 2010 or 2007. I have cascading selections referencing two different lists that hold the dependencies as lookup columns. My cascading ...
1
vote
1answer
42 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 ...