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
13 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 ...
1
vote
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
1answer
14 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
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
24 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
10 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 [on hold]

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
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 ...
2
votes
1answer
799 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 ...
0
votes
1answer
11 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
32 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
10 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
0answers
24 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
2answers
91 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
1answer
33 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 ...
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 ...
8
votes
3answers
2k views

Replace semicolon delimiter in a Lookup column on the list view

When selecting multiple values, the data is separated with semicolons. When many values are selected it starts looking cluttered. Is there any way to have each value on a new line? For example, ...
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
28 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
16 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 ...
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
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. ...
3
votes
1answer
1k 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 ...
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
12 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 ...
1
vote
1answer
922 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 ...
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
73 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: { ...
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" I'...
5
votes
2answers
16k views

How to retrieve lookup values using ClientContext?

What's the best way to retrieve lookup values using ClientContext? I'm accessing a list using ClientContext (let's call it ParentList). That list contains several lookup fields (let's call one of them ...
1
vote
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 ...
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
33 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 ...
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
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
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
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
17 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
90 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
16 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
38 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
2answers
576 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
1answer
53 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'