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
1answer
15 views

SP2013: Calculated column returns 0 instead of “” when list items change

List has 3 columns; Employee Name, Status, and a calculated column. Status is a choice drop down between "Active" & "Inactive". The calculated column formula is =IF(Status="Active",[Employee Name],...
0
votes
2answers
41 views

Null Lookup column getting from REST API with Expand it give no key for expanded column

I am using REST API to for getting data from SharePoint. I have one list like category with three column Title and two lookup name like childcategory, parentcategory. I have some data in which there ...
0
votes
1answer
22 views

List Validation formula help!

I am creating a record center and am having issues trying to have one column (column1) get information from end user and that their answer (choice-dropdown) will determine next set of options that ...
0
votes
1answer
30 views

Sharepoint 2010 List Lookup values in ODATA

It's a common case that you use lookups in your list. When using ODATA, Is it possible to include the actual value of the lookup instead of the (other) SharePoint list item ID?
0
votes
1answer
28 views

How do I retrieve the value of a lookup-field in a workflow?

I'm very new to SharePoint, and I'm working through understanding lists, workflows, and relationships between the two. I'm working on a SharePoint page to keep track of tasks completed in a timeframe. ...
0
votes
1answer
19 views

Display a group of list items that are associated with a record in another list

For the project I'm working on, I've been tasked with creating a project and task tracking SharePoint site for my team. I've created lists and views for tracking the tasks, projects, and timelines (a....
0
votes
1answer
11 views

Lookup Column missing columns

I was trying to make a lookup column in share point but not all of the columns were available for me to choose. Is there a way to expand the number of columns to choose from? Below is a picture of the ...
0
votes
0answers
12 views

Nintex forms lookup problem [closed]

I am trying to use a lookup function in a calculated field to display the fields of one item from a different list in my form. The context is a dashboard that allows the users to make forecasts of the ...
0
votes
1answer
12 views

Lookup field incorrect list id

I have 2 lists a1 and a2 List a1 has lookup field which looks into a2 This was working fine Then I wanted to add more fields to a2 list. I decided to delete a2 list and created list with same name ...
0
votes
1answer
33 views

Migration of Lookup Columns in a Document Library

I have a subsite (and a document library in the subsite) that I need to migrate from development to testing. However, the lookup columns are defined differently in test (as well as in production). ...
0
votes
0answers
12 views

How to use a SOAP data service as the source for a lookup list?

I have created a SOAP data source using SP Designer 2010. Now I am trying to figure out how to use that data source as the source for a lookup field in a list? Is that possible?
0
votes
1answer
40 views

How to add hyperlink from other list with lookup

I gave up. The task looked simple: I have a list with clients with 2 columns: clientname, clientid, URL. I made another list where managers could collect clients from this list that they frequently ...
0
votes
1answer
19 views

Is it possible to search a list and filter the results by specific column items?

In relation to my example photo I searched "wonderware" which produced multiple result with that application name but now I would like to use the column filter to check off specific sites to get ...
0
votes
1answer
37 views

Get Highest Value from Multiple Value Column

Currently using SP Online Office 365 For simplicity let's say my list has 5 columns, The Lookup Date is linked to the lookup title so it pulls through the corresponding date based which title/s were ...
1
vote
0answers
12 views

Lookup column that auto filters bases on site pages.

I'm building a form that surveys user's opinion of the page the page viewed by the user. I have a list with a lookup-column that gets the ID from site pages. I'm looking for the ID to be ...
0
votes
1answer
30 views

Filter lookup field by date

I have two lists. First list is a list of courses with title and date. Second list is a registration list with name and lookup by course title. Is there a way to filter the lookup so that it only ...
0
votes
1answer
19 views

Lookup field populated, additional fields still empty

I added a lookup field to one of my custom lists and I selected a few additional fields to display. I then opened the list, created a test entry but the "additional fields" are still empty even though ...
0
votes
1answer
25 views

How to display entire list based off of lookup?

I have a list of project ID's. Each project ID has multiple app ID's. I need to create a form that list each app id as a field name so the user can submit allocation to each app id on the project ...
0
votes
1answer
17 views

List - Many to Many

Suppose you have a bunch of teams with members. I need: 1. A list that shows each team with all of its members. 2. A list that shows each person on a team and what team or teams they are a part of. ...
1
vote
1answer
47 views

Search based on lookup field relationship

Given the following lists and their lookup relationship. How can I search for "Sassy" and return the owner "David Wavid"? Searching for "Chihuahua" works fine, but the search doesn't seem to look at ...
0
votes
0answers
15 views

Unable to view or edit lookup property from the Document Information Panel (DIP)

I have recently added a new required lookup column to my Document library. Now when I can't save documents because I am unable to edit the field in the DIP. This occurs for both: new documents ...
0
votes
1answer
21 views

SharePoint InfoPath List Dropdown Lookup

There is a problem that I am experiencing with a InfoPath form I am creating. I have two SharePoint Lists. 1 - Contains the database of assets 2 - Will contain the test logs for each of the assets ...
0
votes
2answers
78 views

Customize Lookup form field (new, edit) with JSLink

How can I get the options for some LookUp field, in JSLink? Code: SPClientTemplates.TemplateManager.RegisterTemplateOverrides({ Templates: { Fields: { Initiative: { ...
0
votes
0answers
33 views

SP '13 - Calculated Column -> with Look up -> JavaScript with color output

I'm building a column that combines two Look up columns (CDF_oQ and CDF_oT) and one date (CDF_date) column. The result should be a column (the calculated Column = CDF) showing the date and the (...
0
votes
0answers
34 views

Show Lookup field result on an Infopath form

I´m stuck with this... I have 2 list: 1. One that has a product code and a product description. 2. And another one with more info, in this one I want to type the code and get the product ...
0
votes
1answer
46 views

Linking the answers of one list into another

I have 2 SharePoint lists, a List A and a List B. If someone Adds a new item, on List A, I would like certain columns to be able to populate in List B. For instance, List A has a question that is ...
0
votes
1answer
23 views

SharePoint list that connects and pull related information in multiple lists and libraries

I have a SharePoint list that has a unique column which is looked up in five other lists with related details pertaining to the items mentioned in the unique column I need to have a page with this ...
0
votes
2answers
113 views

Retrieve lookup field value using REST API

In my sharepoint site I have another sub-site. On the top level site there is a list to store 'document type'. Within the sub-site I have a document library which looksup the 'document type' list. I ...
0
votes
0answers
31 views

Lookup column in list not returning data

I have a task list in which I set up two Lookup columns. Each are pulling the title field, but from two different libraries. One is returning values, but the other is not. Any suggestions on getting ...
1
vote
0answers
27 views

Display Template lookup column additional fields

I have a search based solution where I work alot with Display Templates to render out results in a fancy way. It all works fine and dandy with Managed Properties mapped up etc. However, I've come ...
0
votes
0answers
18 views

How can I create dual lookup in Sharepoint?

The FBD library that has been created collect its metadata from the below document information panel when they select a particular content type. A second library has been created named 'APSA'. ...
0
votes
1answer
26 views

Trying to copy email from one list to another without adding formatting

So I'm having quite a big problem here. I'm trying to create one form for one user to fill out, as soon as the form is finished, copy that data to a second form, email the user specified in the first ...
0
votes
1answer
97 views

List lookup to list column in other Site Collection

I have an existing SharePoint custom list with various columns. I require an additional column that is a lookup to a list in another site collection which I'm aware is not possible OOTB. How can I ...
0
votes
0answers
13 views

retireve LinkFilename at MultipleLookupField tag in 2010 page layout

I want to get LinkFilename value from item's lookup field. Lookup field contains page library Title field. In page layout i show URLs in formatted string. <SharePoint:FormattedString FormatText=...
3
votes
1answer
27 views

How to insert new item with multi users ids using batch element?

I am getting issue while creating a new item with multiselection peoplepicker field named multiusers with ids, i am trying below code for stringbatch string strbatch="<Method ID='1' Cmd='New'>&...
0
votes
0answers
17 views

Resources field in Calendar converting link/html to plain text

We migrated a site from 2010 to 2013 which included calendar and resources. Because the group work list feature is depreciated we used the solution given here - enter link description here But our ...
0
votes
1answer
39 views

Cannot find folders created with Explorer…until I do this

In SharePoint Online, I use Windows Explorer to add and manage folders and the data within the folders. Accessing SharePoint via the browser for the amount of data I work with is far too cumbersome. ...
0
votes
0answers
32 views

Using SharePoint 2010 Lookup column multiple values/duplicate values

I'm using SharePoint 2010 and was wondering if there was anyway to play around from the UI without touching SharePoint Designer to search up more than one value associated with one lookup column value ...
0
votes
1answer
54 views

How to get lookup field in Search REST API?

How to retrieve the lookupId or lookupvalue in Search REST API results with other fields. http://server/_api/search/query?querytext='sharepoint'&selectproperties='Title,Age'
3
votes
1answer
41 views

Workflow doen's send email to person field

I need to configure a workflow which would send an email on item creation to the user in Person field of that item. So I've opened SPD, created a new workflow on that list, selected Send an Email ...
0
votes
0answers
27 views

SP 2010: How to display a lookup field as a projected field?

I have these setup: 1- Customer List: List of my valid customers. Among the columns, I have these: (a) Title (b) Short Name 2- Project List: Projects that I manage. Here's one of the important ...
0
votes
0answers
25 views

Sharepoint survey - Lookup type and branching

I am creating a survey to give feedback on various reports. The way the reporting platform is used is the following: we have different workbooks (eg WB1, WB2,WB3) and each workbook has various reports ...
0
votes
0answers
29 views

Get Multi user value from another list in infopath

Could anybody please help me to resolve this issue? I've designed an InfoPath form, with some controls. I have a second list which has the values like this If the current user trying to see a saved ...
0
votes
2answers
42 views

How to setup a lookup column refering to a document library's file url

I am using SP2013 on-premise. I have two document libraries. Some files in DocLibA have a relationship with DocLibB's documents. I would like to create a column in DocLibA and link to 0-1 files in ...
1
vote
0answers
17 views

Lookupfields in SharePoint hosted add-in

Is it possible to use Lookup fields in SharePoint Hosted Add-ins ? I can add them via GUI in VS, (similar to this http://www.enjoysharepoint.com/Articles/Details/add-lookup-field-type-column-in-list-...
0
votes
1answer
23 views

Workflow - How to get the ID of a lookup field?

I have a lookup field "Customer" in a list (Sales) from Customers List. I have a workflow on the Sales list. I need to get the ID from the lookup field. Is there a way to do that with workflow?
0
votes
0answers
38 views

Set a lookup column value from text column via 2013 Workflow

Using Workflow 2010 it is possible to set a lookup column value from either a text field, or calculated column or by using a workflow variable. If I have a calculated column value or variable inside ...
0
votes
0answers
34 views

Sharepoint add ID from list to task

I would like to add the ID from a list to a task list. I have created a column in the task list as lookup and SET field: ID (from list) to value: List ID However, the ID still does not appear in ...
0
votes
0answers
64 views

Update one list based on another in SharePoint

I am fairly new to SharePoint and just recently started to work on the feature called Limits. Basically, I have two lists: Source and Target. Target list have a column called SPR with unique ...
0
votes
1answer
35 views

How to have number of chosen Lookup field in another list?

I am working on SharePoint 2013 Enterprise. I am looking for a functionality so I can sum item chosen in a list. As an example I have a list call Bus which is the parent list. The second list is the ...