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
28 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
25 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
37 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
19 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
37 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
20 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
24 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 ...
2
votes
1answer
785 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 ...
1
vote
0answers
21 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
12 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
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
34 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
24 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'>&...
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, ...
0
votes
0answers
11 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
27 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
535 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
39 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'
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 ...
3
votes
1answer
29 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 ...
3
votes
2answers
88 views

Get lookup from REST API

REST API url is /sites/MySite/_api/web/lists/getbytitle('MyList')/items?&$top=100 I have a lookup column called Sector in the list. How to retrieve this lookup value from the success call of ...
0
votes
0answers
20 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 ...
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 ...
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 ...
1
vote
3answers
3k views

Can a list be made available to column in subsite?

I am creating a project management site template. This template will be used to create PM subsites in our corporate PM site. In the subsite task list, I want to add a "Work Area" column that is a ...
0
votes
0answers
26 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 ...
1
vote
1answer
914 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 ...
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
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
2answers
822 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 ...
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'...
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

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 ...
1
vote
1answer
704 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 ...
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 ...
3
votes
1answer
326 views

Cascading functionality in quick edit mode in Office 365

I've sandbox solution in Office 365. I want cascading functionality of Country, State, City in SharePoint lists. I got that by using SPServices JavaScript but only in NewForm and EditForm. Want this ...
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.
6
votes
2answers
9k views

How to get lookup value only via REST (listdata.svc)

I am trying to retrieve a list of items including lookup fields via listdata.svc. My lookup points to a list of companies which has the following fields: Title, Address, Phone. By default, listdata ...
1
vote
1answer
2k views

Set lookup field value in infopath form on new Item(List Infopath form)

I have lookup field called project stage, on item created I'd like to set to its default value,(project start). Then this field can only be changed by the Workflow as the project moves to the next ...
1
vote
2answers
5k views

Sharepoint 2010 and Infopath form : lookup fields are displayed by their ID instead of text value

I'm trying to build a custom Infopath form for a list that contains 2 fields that I would like to get auto-completed: Person: people picker field, filled with the current user Team: lookup to the ...
0
votes
0answers
21 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
33 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 ...
1
vote
4answers
8k views

How do you connect a Calendar List to a Project Tasks list using Web Part Connections?

I created a Calendar List and a Project Tasks list. Then I added a lookup from the Tasks list to the Calendar list. However, when I try to connect the two with the related field visible on both List ...