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
5 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
9 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}" ...
3
votes
4answers
841 views

Search Display Template Not Returning Values for Managed Property

Search results has no value for a custom site column. Ok, so I have a lookup column created as a site column in the root of my site collection. I found the field in crawled properties. NOTE: I am ...
0
votes
0answers
5 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
14 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
34 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
24 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 ...
2
votes
1answer
1k views

BDC List column picker filter - search/filter not working and exact entry says not found?

I'm working with MOSS 2007. Rephrasing the question. I have a BDC column to an external datasource in a custom list. Today searching and filtering is not in place and actually exact matches are not ...
0
votes
0answers
10 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
899 views

Document Information Panel contacted a data source but failed to receive data. The form will load without the requested data

The query cannot be run for the following DataObject: list_48985ACC-FDDD-4732-AA48-078CFE123F35 Document Information Panel cannot run the specified query. The SOAP response indicates that an ...
1
vote
1answer
37 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
20 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
2answers
1k views

Calculate Field with a Lookup Additional Column

Would like to ask some suggestion if i have 2 lists (Vendor List & Order List). Where Vendor List is contain with name & discount fields And i create new list "Order List" with field Items, ...
2
votes
1answer
1k views

content query web part with multi value lookup column

I am trying to work out how I can query a content type with a multi value lookup field using the content query web part. I know that natively this is not possible with ootb sharepoint 2010 however I ...
2
votes
3answers
28 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
22 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 ...
1
vote
1answer
98 views

Displaying multiple column data in a drop down menu

I'm using SP2010 unfortunately without SP Designer and only used InfoPath once. I have 2 lists: List A - Is a list of 'Event Codes' with a 'status' column displaying Active, Used or Reserved ...
2
votes
1answer
574 views

Add items to the lists having lookup relation using powershell?

I am trying to add items to the comments list based on the Post list having lookup relation ship between these two lists,can any one give me an example how to update the lookup column values using ...
0
votes
1answer
24 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 ...
3
votes
1answer
983 views

How to change the color of each column in a SharePoint chart?

How does one change the color of each column in a SharePoint Chart Web part? For example the "passed" column would be green, the "stopped" would be red. I am pulling data from this list: It ...
1
vote
3answers
3k views

Sharepoint 2010 - Workflow, return field as Lookup Values, Comma Delimited getting both lookup id and lookup value

I'm working on a simple workflow in SPD 2010 which is going to send an email to multiple recipients based on lookup values and even though I set the "Return Field As: Lookup Values, Comma Delimited" ...
0
votes
2answers
741 views

Drop down lookup field search

I've got the following scenario: List A contains several thousand items, List B has a lookup field to List A. When a user is creating item in List B she has to select the List A item via the mentioned ...
2
votes
1answer
521 views

SharePoint 2013 - Reverse Lookup

I am trying to achieve the following in SharePoint 2013. I have two (2) lists a server list and an application list. Each list contains a lookup column which a user can select which applications are ...
0
votes
1answer
2k views

Workflow Error: Coercion Failed: Input cannot be null for this coercion

I have a workflow that is assigning a task based on a lookup value. This workflow runs successfully the first time then fails on subsequent attempts. Here's how the data looks: Look Up Title ...
2
votes
1answer
2k views

set multiselect lookup column using jquery

I have a Multi select Look up column which as you all know is a control with two list boxes and "Add or Remove" Buttons. The user populates the right-hand side of the control with some values by ...
0
votes
1answer
32 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 ...
0
votes
1answer
663 views

Conditional formatting lookup column

I am attempting to do conditional formatting in a list view in SharePoint Designer. In this list I have a list that contains a lookup column, and other columns derived from the list of that lookup ...
1
vote
1answer
762 views

Secondary lookup columns for external content types not displaying data in list after refreshing from primary

I have created a SharePoint list that has a lookup column to an external list. I also have instructed SharePoint to display several secondary columns that are related to that primary external lookup ...
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
20 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 ...
1
vote
1answer
2k views

SharePoint 2013 - Remove the hyperlink from a lookup column in a list view

I've searched the web and found a solution.... IF I WAS USING 2010 or 2007. I have cascading selections referencing two different lists that hold the dependencies as lookup columns. My cascading ...
0
votes
0answers
32 views

Lookup field on 1 list doesn't update when the text field in another list changes value

I have a target list with Employee Status: Pre Hire by default. Once items are completed that changes to Active Employee. I have a field in list #2 with Employee Status as a lookup field pointing to ...
0
votes
2answers
1k views

Problem copying lookup column data from one list to another via PowerShell

I have the below script that works for moving list data between two lists on sites next to each other that have the same schema. Everything works perfectly bar a column of type LOOKUP named "Name of ...
0
votes
0answers
7 views

Cross Site Collection Boundary for SPFieldLookup

I am looking for a solution similar to this post, Cross-site and SPFieldLookup, but I need to cross a site collection boundary. Is this possible with modifications to the powershell on the posted ...
7
votes
5answers
8k views

How to display lookup additional field in display form?

I have two lists: Projects and Tasks In the Tasks list, I have created a lookup field titled ProjectID which targets ID filed from the Projects list. Also, I have set for this field to display an ...
0
votes
1answer
24 views

The lookup that you defined is not guaranteed to return single value

Error: The lookup that you defined is not guaranteed to return single value. If more than value is returned only the firs value will be used How to return multiple values from a lookup column?
0
votes
0answers
18 views

What is the best way to Manage meeting attendees in custom list?

I am trying to manage a custom list for a large meeting in SharePoint 2013 . I already have a contact list with all information, this will be my basic invitation list. The person who call for ...
0
votes
1answer
753 views

Export and Import the lookup relationship data in SharePoint 2013

In SharePoint 2013 having a blog site with Posts and Comments list, these 2 lists having the lookup relation ship, I export and import from one site to another site but in comments list PostTitle ...
3
votes
1answer
197 views

How to have a calculate column that compares the difference between the current item and the previously submitted item?

I have a list with the columns Room Number, Temperature, and a column Temperature Change. What I would like, is for Temperature Change to be a calculated like so: When the user fills out a new ...
0
votes
0answers
21 views

Auto populate a multiline column based on a lookup one

I am an absolutely beginner. I am creating a IT support ticketing system based on Sharepoint online. I do not have access to "InfoPath" or "SharePoint Designer". I have added the "Incidents" vanila ...
0
votes
0answers
20 views

Link on lookup field go to filtered list

I currently have a List A with a lookup column called "Category" that is using a list of categories in List B. The column is currently hyperlinked and when clicked it shows the item from List B. Is ...
0
votes
2answers
9k views

Coercion Failed: Can't get workflow to send notification to “Assigned To” user

I've created a simple workflow to send a notification email to the "Created By" user which works nicely. What I wanted to do is use the "Assigned To" built-in lookup instead, which is a "People ...
0
votes
1answer
27 views

Creating an interactive form with a custom list with lookup fields

I have a list that we are using to order new computers for staff members. They fill out all their information, like name department and cost centre. Then I want them to select from a list of ...
2
votes
2answers
2k views

Help with SPCascadeDropdowns cascading lookup column

I have this jquery added to my editform.aspx in SharePoint. I want the childcolumn to also have unique values, although it may contain duplicates example below. Example. When I select mycountry, I ...
0
votes
0answers
20 views

Sorting dropdown of a lookup to another column

I have a column that looks up it's values from another column (Single Line of Text). The users would like the order of the lookup dropdown reversed (currently displaying as 1,2,3 they want it as ...
9
votes
6answers
17k views

Why is my column not shown under “Add a column to show each of these additional fields”?

In SP2010, I want to get 2 columns from another list and merge these columns. But when I am trying to do this via Lookup, they are not shown under "Add a column to show each of these additional ...
1
vote
2answers
33 views

Filter items based on lookup

I have an SP list with 6000 items.It contains 10 lookup columns. I want to filter,retrieve and display a set of items in a page based on these lookup value. I tried using REST API & CSOM but I am ...
0
votes
1answer
53 views

SharePoint 2013 Workflow with many variables

I got stuck with the problem of lookup workflow. I need to fill the SharePoint list based on the 2 variables introduced earlier to another list. After some searching lookup workflow seems to be the ...
0
votes
1answer
45 views

Updating a lookup type field

I have 2 lookup fields on a form. I have the following code and it's populating the 2 lookup fields. However, when I click on save button it complaints about field is required but I see both are ...
2
votes
3answers
62 views

How to change the output of a Multi-value Lookup column in a View?

Could I edit the way the Lookup column displays information, if possible without code? (Or an easy explanation as to how to do it?). Currently it is displaying as "Name; Name; Name; Name". I would ...