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
9 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
12 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

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
8 views

Drop Down In List From Lookup Does Not show all items in Mobile View

In SharePoint 2013, I have a master "task" list that is linked to another "users" lists via lookup. The "users" list have over 30 items (tech's names and contact info). Everything is fine and dandy ...
0
votes
0answers
9 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
21 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
25 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
46 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
12 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
9 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
30 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
31 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
28 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
14 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
38 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
34 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
32 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
50 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
20 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
22 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
28 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
16 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
17 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
21 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
50 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
18 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
42 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
15 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
25 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
24 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
28 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
23 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
19 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: ...
0
votes
1answer
38 views

Lookup Column of a List Column

I have a requirement for a project site in SharePoint. The Site will have: 1st List: a Stakeholders List with the names of people involved (people/group type) in the project and their Project Role ...
0
votes
0answers
16 views

Using lookup to populate list and want Items select to update other list as checked out

Using lookup to populate list and want Items select to update other list as checked out. I have 2 lists with data. Using 3rd list to store select items from other lists. List 1 is a job list. List 2 ...
0
votes
3answers
143 views

Is it possible to have a lookup field with autocomplete feature

I have defined a lookup field with multiple values over a contact list inside my SP 2013 team site, and by default I got a select list as follow:- So is there a way to have the lookup field with ...
0
votes
0answers
23 views

Sorting lookup column by descending dates in list form in SP 2010

I have a lookup column (Date of Distribution) that pulls a list of dates from another list on the same site. When the lookup pulls the dates, they are in ascending order, so the oldest first down to ...
0
votes
1answer
46 views

Unable to create a look-up site column at the site collection level, then override it at the list level

I want to create a new Lookup site column named "List Attendees" which will contain unique values for each list. so i created the new lookup at the site collection level, but i faced the following ...
1
vote
1answer
62 views

In SP Online, how to return the default HTML of a lookup field when overriding the Item Template in a list view

I've found various methods to return the default values for the field template override, including lookup, but I have been unable to find or successfully implement a method to do the same for fields ...
0
votes
1answer
37 views

Mixing between “lookup” column type and “People or Group” column type

I want to create a site column that contain a list of “Project Managers”, where some project managers are already defined inside Active directory and are defined inside a SharePoint security group , ...
2
votes
0answers
24 views

Multiple Criteria Lookup in Parent List

I have a list of projects (Project List) and another list of periodic status updates (Status Update List) related to each project (one-to-many). I need a lookup column in the Project List that ...
0
votes
2answers
50 views

Alternative to Lookup Column

I have a list with a lookup column displayed as a dropdown menu in the NewForm allowing the user to pick a contact person retrieved by lookup to the contacts list, however this list will soon grow ...
0
votes
0answers
12 views

Sharepoint 2013 Foundation filtered value from other list

We have two lists- One for contacts and other is vacations. Our goal is following: When we open a contact card there would be a value from vacations list what would only display the vacations of the ...
0
votes
1answer
110 views

SharePoint 2010 Rest query for Lookup fields

I am writing a REST query to retrieve data from child parent list. States is the parent list with "Title" column. LocalGovernment is the child list with "State_Territory(InternalName) and State / ...
2
votes
1answer
32 views

Lookup column showing up properly when logged in as Full Control user, but not showing up properly when logged in as Contribute user

I have a SharePoint 2010 form with a couple lookup columns. The form looks normal to me with Full Control permissions, and the dropdowns for these items are showing up normally on the form, but ...
0
votes
0answers
24 views

Workflows - getting fields to populate look up fields before sending an email

I'm working between two sites (a) and site (b). I'm also using cross-site publishing. On site (a) each item from a document catalog on site (b) is displayed and the url contains the ItemID. On ...
0
votes
0answers
17 views

How to interact with a XsltListViewWebPart

Try to imagine this scenario: You have a list A with one field TitleA, and you have a List B with three fields: TitleB, FileAttachement, Lookup(A). From an Application Page you want to create a new ...
0
votes
0answers
31 views

List only shows id numbers and not the text when mapped with infopath

I have run into an interesting problem and was wondering if anyone else has experienced this and found a workaround. We have a list with several choice columns. The choices in those columns were kept ...
1
vote
0answers
40 views

Limit dropdown options when the lookup column is a site column and has more values than are relevant

I have a list of projects on my parent site with two columns: ` Project Category I would like to use Project as a site column that looks up values from the aforementioned list so I can maintain a ...
0
votes
0answers
10 views

Client side populate dropdown with lookup values

In the UI of SharePoint I've added a lookup to a child list. I now need a custom form where the user can set this value via a dropdown. Do I need to load the data from the parent list or is it all ...