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
0answers
10 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 ...
0
votes
0answers
11 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 ...
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 ...
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
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
0answers
13 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
26 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 ...
0
votes
1answer
19 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
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 ...
0
votes
1answer
36 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
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
32 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
27 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 ...
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? ...
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
18 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
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 ...
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
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
26 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 ...
3
votes
0answers
63 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
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
43 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
46 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
29 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
20 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 ...
0
votes
2answers
45 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 ...
1
vote
0answers
41 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 ...
1
vote
2answers
38 views

Lookup Column in Content Type hub

I had to create a Content Type in the Content Type Hub which has a Lookup column... I created the list of the lookup in the CTHub and published the CT. In my site collections I can see the new CT but ...
0
votes
1answer
87 views

Lookup field value is not getting set when using Client object model

I have a document library (contact). Have created a custom list (workstatus). Have added column to contact library which is lookup of workstatus. Below is my code using which i am setting the lookup ...
0
votes
0answers
25 views

My Deployed Site Column Lookup Isn't Referencing the List

I have a SharePoint list that was created through the SharePoint UI (i.e. not through code/features/packages). I'm trying to define a site column in my feature/package that is a lookup to this table. ...
0
votes
0answers
28 views

In O365, is it possible to create list item by setting Lookup Field in sub site list?

I have been implementing a workflow on a Parent Site List A. The workflow is then instructed to create a list item on an existing List B on a subsite. I have been able to create an item on List B ...
0
votes
1answer
41 views

Update List items using workflow - multiple items

I have two SharePoint lists, one list contains Tools and the other list contains Jobs. On the Jobs List, I enter a new job. I then will select the Tools needed for the job. The Tools are in a lookup ...
0
votes
0answers
19 views

How to populate lookup library field with value from list from the same page?

Essentially, I want to add document library to the custom list's "edit" child page. The goal is to replace basic custom list's attachments functionality with more sophisticated one. I can do that ...
0
votes
0answers
18 views

Filtered Lookup multiple selection

We have list A and list B. List B has a lookup column from the title field of list A. I created a data source with the designer to filtered the lookup values from list A (show lookup value if status ...
0
votes
1answer
32 views

Lookup column added to list created by importing Excel spreadsheet not working

I have a list on a site that was created by importing an Excel spreadsheet. I have several lookup columns that were deployed to the site using a feature. Going into the site columns gallery, I see ...
0
votes
1answer
55 views

How do I link two fields in a form so that when one field is filled out, the other autopopulates based on another list?

I have a form that is looking up a list It is pulling in all of the degrees When I enter a field into the field box, say Fireman, it still pulls down ALL of the Degrees options. I want it to ...
0
votes
1answer
20 views

Missing columns in look-up column

I created a new document list and enabled some column in the view: Afterwards a I created a custom list and added a look up column. In this column I would like to specify a column of my document ...
1
vote
1answer
70 views

Workflow error: The value 'Value' cannot be read as type 'Int32'

I've a list named APE - Opções with this values: Título | Nota Nunca | 1 Algumas vezes | 2 Frequente | 3 Sempre | 4 N/A | 0 And a list ...
0
votes
0answers
55 views

Multiple Column Lookup in SSRS expressions

Hi I am working in SSRS 2012. My dataset/table schema is as below. ID,Name,Age,Address In my report table this data set is the source. What I want to do is I want to filter my data set in ...
0
votes
0answers
33 views

Populate Data using SharePoint Lookup Column feature in Document Library from a SP List column data

I want to populate a Sharepoint Library column with data from a column of a Sharepoint List. My question is Is SP lookup possible on the following scenario SP List column data --> SP Library ...
0
votes
1answer
30 views

How to change lookup hyperlink to open in another tab instead of a dialog in SP2013

Currently when I click on the accounting projects link: This dialog box opens: Instead of a dialog box I want this page to open in a new tab: Any Ideas on how I can do this? I tried using ...
0
votes
1answer
30 views

Is there a way to add an item to a list by clicking a link in another list's view?

I am currently making a sharepoint Lists application for my company's recruiters to assist in their campus recruiting process. So far this consists of two lists, the first, Candidates, is a simple ...
2
votes
0answers
30 views

Lookup fields will be rendered as a list of checkboxes inside iphone safari web browser , instead of being rendered as a select list

I am working on an issue tracking list which have a lookup column named “Related Issues”, which is rendered as a select list inside IE on desktop browser as follow:- But when I access the list from ...
0
votes
0answers
21 views

Joins and ProjectedFields not working in SharePoint Online (wave 16)

I am creating a view with Joins and Projected fields and get no compilation nor activation errors/warns, yet when accessing the view in UI, I get field not found error. Lists I'm joining are: ...