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
0answers
2 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
15 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
45 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
31 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
27 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
40 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
22 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
1answer
46 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
26 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
25 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
16 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
21 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
45 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
12 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
14 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
31 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
28 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
43 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
32 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
21 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
21 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
28 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
20 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
34 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
29 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
58 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
33 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 ...
1
vote
2answers
23 views

How do I include a blank in a datasheet dropdown?

Using the datasheet view, I have a list setup and one of the columns has a dropdown. I want to include a blank space as one of my choice options.
0
votes
0answers
24 views

vLookup function in Sharepoint WebApp

This is very straight forward with a vLookup in Excel, but not sure how to do it on Access Sharepoint WebApp. I have a Customer_List table containing 'Customer_Account_Code', 'Customer_Name', '...
0
votes
1answer
38 views

Can a workflow populate values in a lookup field for all the items in the list?

I have a list called Contacts, with 4000+ entries. It currently has a dropdown choice column with four specified values for different offices (MAO, NHO, MEO and CTO). I want to convert this dropdown ...
0
votes
0answers
15 views

limit a lookup input field on a document upload form (SP2013)

I've created a project site with a tasklist and put a document library on it. The task list WebPart is filtered to show only My tasks Every added document requires a task list a title to be entered (...
0
votes
1answer
41 views

Create lookup column using AssignedTo column from Task List to Document Library

I made a task list, and some tasks are assigned to multiple people. A document webpart gets a filter view, of a selected task in the task list. When i add a new document to the document library, I'm ...
0
votes
2answers
31 views

Anonymous Access Users cannot see lookup values between lists and libraries

I have a document library which uses lookup fields from other lists in the properties of the of the document. I then use the lookup field to group the documents. For authenticated users, the list of ...
0
votes
1answer
17 views

SPListItem access to lookup column not work

I have one list definition like this: <ContentType ID="0x01..." Name="CNT_List" Group="List Content" Inherits="TRUE" Version="0"> <FieldRefs> <FieldRef ID="{guid}" Name="...
0
votes
0answers
9 views

Create a list column of Project Web Access project names

I'm trying to make a site column in Project Web Access which contains a list of the projects managed within that instance of PWA. There's a few types of data in the PWA that look like they should ...
0
votes
1answer
27 views

How to make Person/Group and Look-up column values non-clickable in SharePoint 2013 list views

I'm using SharePoint 2013 Enterprise. For a SharePoint 2013 XSL List View Web Part, I need for the person/group column value, as well as look-up column value to be non-clickable. I have seen multiple ...
0
votes
2answers
40 views

Lookup list with dependencies/permissions

Below is a drawing of a scenarium I want to create in SP2013. My question is wether this is possible OTTB, or possible at all. The main concern is, how possible is it to make drop-down depend on each ...
0
votes
0answers
27 views

lookup with criteria

I have three lists in Sharepoint: Customer Product Lizens A Customer has a unique Name and a Adress. A Product has a unique Name belongs to a specific Customer(can also be unasigned). A Lizens ...
0
votes
0answers
11 views

create custom field linking to library contents

Trying to create a change request list requiring the viewer to specify the artifact to change, based on the filenames in the artifact library (same sharepoint). The displayed control to select could ...
1
vote
1answer
74 views

Drop down list lookup field SharePoint Designer 2013

I would like to create a list with inventory on it. This would be just numbers like A1 through A24 (List A). Is there a way to create a lookup field in another list (B) with a column that shows those ...
0
votes
0answers
24 views

How do I get the linked to title field in a rest call?

How do I get the linked to title field in a rest call? Also, will there be an additional step if this field is on another list? I've already expanded and included the specific field in my current ...
2
votes
3answers
33 views

List Lookup Column - Select Library

I would like to add a lookup column in a SP list, which allows the user to select a specific library (rather than an item within that library). Is this possible? Many thanks
1
vote
0answers
26 views

SharePoint Designer Workflow create new item with lookup to current item

I have two lists, "customers" and "expense Sheets". The list "expense sheets" has a lookup column "related customer" to the "title" field of the "customer" list. I am trying to create a workflow for ...
0
votes
1answer
40 views

SharePoint 2013 Unexpected Error while creating lookup column to use external list

I am using SharePoint Server 2013. In that I am creating a custom column which lookup to an external list. My ECT is based on an SQL Server table and I have created the external list in the site. I ...
0
votes
1answer
41 views

Adding a many to many relationship, and having a form input data into two lists

I'm building a form for a Marketing Event list. The list would track name/type/location/date etc of the event and also those people associated with it (for example recipients or attendees) These ...
2
votes
0answers
34 views

Filtering Lookup Column By Expiration Date [duplicate]

Scenario: I have created a lookup column with two columns. A department column and Expiration Date column. Each Department has a Expiration Date. For example see the image. When the Department ...
0
votes
0answers
21 views

Pulling in a task field in lookup for string

Here's my scenario 1. I have a task which is asking a user to add details in a task field called 'Additional Details' 2. Once user fills in and submits the task, another task is created with approval ...