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)

1
vote
2answers
91 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
418 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
51 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
1answer
103 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
0answers
82 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
161 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 ...
4
votes
3answers
3k views

Deactivate the link of lookup-fields (2010)

On our solution (SP Foundation) we multiple lists with quite some lookup fields. Some of the lookup fields are user fields who link to the user info list, and we don't want that to happen. Of ...
0
votes
0answers
50 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
27 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
206 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
3answers
7k views

lookup field test if value is (none) from SPD Workflow

everything is in the title. I have a lookup field set to optional and I need from my Workflow to test this field. When you do not select any value, you have (none) in the interface but I cannot seem ...
0
votes
1answer
530 views

SharePoint 2013 lookups with more than 20 items as select or input?

So I was reading about doing some JavaScript to manipulate the default forms for our lists and came across this: ...
0
votes
1answer
755 views

linq query for lookup list column error - query uses unsupported elements

I'm trying to return the list item ID (s.ID), and the ID of a lookup column (s.VendorID). I get the following error: The query uses unsupported elements, such as references to more than one list, ...
0
votes
3answers
1k 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
1answer
38 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 ...
0
votes
1answer
29 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 ...
0
votes
1answer
413 views

SharePoint user group cannot access a certain field in a list

I want a certain group with contribute permission to be able to add and edit items into a list. One of these fields is a lookup value. This seems to cause trouble for the user, since the person cannot ...
1
vote
1answer
354 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 ...
1
vote
1answer
185 views

Displaying text in a Look-up column

Apologies for not being clear. I'm try to display a "multiple lines of text" column as a look-up field in a new view of the parent list. I have tried SP Designer and most of the standard webparts. ...
1
vote
0answers
965 views

How do I create a lookup field for a hyperlink field and display the URL?

I have a regular, out of the box, list of type "Links". I have created a custom list that includes a lookup field to the URL field of the "Links" list. I have created a custom xsl template file for ...
0
votes
0answers
235 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
66 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 ...
1
vote
1answer
118 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 ...
2
votes
0answers
43 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
47 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
57 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
98 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
0answers
31 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
1answer
100 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
242 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
111 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 , ...
0
votes
1answer
447 views

copy one column value to another column in a list

I have a list named ABC in MOSS 2007 List has 2 Views (All Details and Multi Location) 2 columns (BA-tech and BA for both views) BA- tech field is "Single line of text" type and BA field is "Look ...
1
vote
0answers
480 views

Filter a CQWP on a Lookup Column

I'm creating a custom page layout that contains a CQWP that I'd like to display documents related to the page. The document library has a lookup column that relates to the page title in the Pages ...
2
votes
0answers
54 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
120 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
17 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 ...
1
vote
1answer
942 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
36 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
86 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
21 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 ...
2
votes
1answer
196 views

JSLink and lookup field problem

I am trying to make a cross site lookup field. So for now I made javaScript file and overrided the JSLink parameter. I want to made it clear for sharepoint and followed clientforms.debug.js ...
0
votes
0answers
90 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 ...
0
votes
2answers
3k views

Create Lookup Field Powershell

I am using SharePoint 2013, I need to create a lookup field through PowerShell. I tried this code but is not working: $SiteUrl = "http://mySite" $WebObj = Get-SPWeb -identity $SiteUrl ...
1
vote
0answers
67 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
2answers
64 views

lookup another lookup

I've 3 lists. List B looks up List A and then I need to create a lookup in List C that lookups List B but also get values in List B that are lookups of List A. How is this achievable? Thanks
1
vote
1answer
28 views

Create a Cross Site Lookup in a declarative way

I can declare a lookup field with this line: <Field ID="{3EA24157-1C11-41CB-AA01-5EEEF93C2603}" Name="NewField" DisplayName="New Field" StaticName="NewField" ...
0
votes
0answers
17 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 ...
1
vote
1answer
158 views

Reasons why a Lookup field doesn't work

I'm struggling with the declarative creation of a lookup field: <Field ID="{3EA24157-1C11-41CB-AA01-5EEEF93C2603}" Name="NewField" DisplayName="New Field" StaticName="NewField" ...
0
votes
0answers
171 views

Filtered lookup using SPServices

I have 3 lists: Schools, Interactions, Contacts In the new form for a Interaction item I have a lookup field displaying a long list of contacts, however I need to filter this list to only display ...
0
votes
1answer
66 views

Set a Lookup reference to a Field that already exists

I need to set the lookup reference to a field that already exists (of type lookup) that is not pointing to yet. I can get the lists and the fields but I don't know how link to each other. Can you ...