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)

3
votes
2answers
2k views

lookup column in calculated column formula

I have a Lookup column(Discountfirst) which has Number. I also have another Calculated column(Finaldate) with Resulttype DateTime. One more column(DateofReceipt) in Date. My Calculated column formula ...
2
votes
1answer
31 views

If [LookUp] equals [String] doesn't always work. Sometimes I have to use [1;#String] instead, why?

I am using SharePoint Designer 2010. I created a workflow in which I needed to test the value of a lookup column. I (perhaps naively) simply tested if the lookup column equals the literal string I ...
2
votes
1answer
18 views

Library upload form Dropdown options order

I have a library to store files (obvious) with column "City" which is a lookup to list with two columns (CityName & Order). How to change ordering of options in dropdown field (which is in ...
1
vote
2answers
4k views

Workflow condition using a lookup column

I am sure this is something quite simple but I can't seem to figure this out (I am new to SPD and workflows in general). I am building a workflow to notify key individuals of a new item(s) being ...
0
votes
0answers
12 views

How do I create a workflow to input a date from one list to another on item create or edit?

I am new to SP workflows and cannot work out how to create a workflow for the below. Can anyone help? I have 2 lists, list A and list B. In list A, I have a unique identifier (UID) field and a number ...
1
vote
1answer
25 views

CAML query with OR returns no result, where single part of it returns results

I have a CAML query which queries 2 multi taxonomy (managed metadata) fields. I use the IN operator for this. The query should return items where in one of the fields a match was found, so either in ...
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 ...
3
votes
2answers
10k views

Add additional field to lookup field inside schema.xml

I'm following the steps in this article to setup a joined data view webpart joined on a lookup field: ...
0
votes
1answer
593 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
22 views

Need CAML query LookupMulti column help, Is it possible?

I am trying to create a CAML query for querying list, here is my problem. There is a list Employees and it has a LookupMulti column for Hobbies. I want to get all Employees who have selected Reading ...
1
vote
2answers
2k views

Default null value to a required Lookup Column

The title pretty well speaks for what I need. I have a lookup column on a list, getting data from a custom existing site column i created. I need it be null by default so they get an error if they ...
0
votes
1answer
580 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
1answer
701 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
0answers
8 views

Refreshing a lookup field in modal edit form via client side javascript

I have a list (list "Project") that on edit of a item opens a modal dialog for editing (editProject.aspx) The Project item has a lookup field "Document links" which points to a custom sharepoint list ...
2
votes
2answers
563 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
11 views

Sharepoint 2010 connect webparts using multilookup fields

I have one question. I have two generic SharePoint lists on my site. First list have lookup field that allows multiple values. Also I have web part page with two list view web parts from these lists. ...
0
votes
2answers
977 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 ...
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 ...
1
vote
1answer
948 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
20 views

SharePoint List CreateBy column storing date value

we discovered some very strange behavior in a list. within the last couple weeks, the Created By column for all items was replaced by a date: 35;#2014-12-23 23:17:51 I got this using powershell, ...
2
votes
2answers
94 views

Counting the number of items added in LookUp column

I have a lookup Column in my list which can take multiple values. So I need to count the total number of items added in that lookup field. What is the simplest way to do this?
1
vote
2answers
25 views

Get SharePoint user by email address

Is it possible to get the SharePoint user by email address? I'm writing a SharePoint 2013 workflow and the steps are : call a web service to get user email address look up SharePoint user using ...
3
votes
1answer
833 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
27 views

Restricting a lookup field in a list

I'm putting on SharePoint Lunch and Learn training for my company. I'm wanting them to sign up. In one list, I have title and date Lunch and Learn 1, January 15 Lunch and Learn 2, January 22 In ...
1
vote
0answers
20 views

Lookup doesn't work on field that has taxonomy field

Is there any reason why lookup field in one list would stop working when taxonomy field is added to other list that lookup is referenced to? Before adding the taxonomy field lookup was working just ...
1
vote
1answer
872 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
2answers
20 views

How to get the text, not the ID number, from an external look-up field with InfoPath?

I have an InfoPath form with a drop-down list that needs to be populated with a field from an external SharePoint list. However the field is a Look-up Field and when I get it to populate the drop-down ...
2
votes
2answers
1k 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
1answer
1k 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
2answers
4k views

How to return field from specific workflow task as Data source in Lookup tool?

In short . . . How do I do this: ? In Step 1 of my workflow, the first action is to create/assign a task with Task ID of TaskID1. For the next action, how do I assign a field the value of a ...
2
votes
0answers
43 views

Recurring Events in Calendar created from a template

Using SharePoint 2013 on-premise, I had a calendar working nicely in my test environment. I then Saved it to a template, moved it to another site collection and created a new calendar. It had lookup ...
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 ...
1
vote
2answers
2k 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
0answers
43 views

Set value of lookup field using JSLink

I am trying to use jslink to update the value of a lookup field in a quick edit view. I haven't been able to figure out how to do it. I have done a fairly exhaustive search online, but the closest I ...
3
votes
0answers
28 views

Is it possible to create a lookup column with a list of all lists on the site using a WSDL data source?

I have a list in which I want the user to be able to select the name of 1 or more lists/libraries that exist on the account. I know I can use _vti_bin/lists.asmx?op=GetListCollection to get a list of ...
0
votes
0answers
29 views

Set value in lookup field in workflow?

how can I set only the one value to required lookup field, when I create new item in workflow. I tried use workflow variable, ID but I do something still wrong. So I have one list A wiht values AB, ...
0
votes
0answers
48 views

Lookup to a column in a library having multiple hierarchical folder structure

I have a library A that has multiple folders and documents. I want to create a list B with a lookup column pointing to a column in Library A. The problem I face is that the lookup column fetches ...
0
votes
2answers
8k 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 ...
1
vote
2answers
983 views

Is it possible to iterate all lists in Sharepoint in search for a given Field?

Is it possible to itterate all Lists in SharePoint to find out which ones use a custom Lookup field? I have an application which is currently failing because the custom Lookup field was pointing to a ...
0
votes
0answers
17 views

Lookup field getting value instead of text

I have departments list ,I want to use departments list in another list by using visual webpart it works fine but I am getting values instead of text in the list after saving the list item. in ...
0
votes
1answer
49 views

Limit choices in (lookup or choice) field based on user

I have a list with a column 'Customer Code'. This code consists of a 5 digit number. I have another list of active customer codes and authorized users. Each customer code is also set up as it's own ...
0
votes
1answer
20 views

Look up additional column in InfoPath 2013

I have a list in SharePoint 2013 called 'Product'. I want to create a purchase form in InfoPath 2013. I have created to look up in infopath for product code from sharepoint list. But I want the unit ...
0
votes
0answers
29 views

Adding two columns from multiple lookups

Pardon for the confusing nature of this question. I have two different lists, Business Units and Campaigns, which are used to clarify the different aspects of my business. These are fluid and there ...
0
votes
1answer
33 views

Entire Lookup Row to Appear in Dropdown

I hope I can explain this clearly. I am working in SharePoint 2013 and created a custom list that I pulling the data from that list into another list using lookup columns. For example, ID# is one of ...
2
votes
0answers
36 views

Is cross-site lookup possible with a provider-hosted app?

I have following problem. I got two projects, one sharepoint-hosted app and another provider hosted app. Both contain a couple of lists. So far so good. Now I need the data from the sharepoint-hosted ...
0
votes
0answers
18 views

Selecting a lookup filter causes all lookup information to dissapear (Recent SP '13 Upgrade)

I have a list of project documents that I'm using lookup fields to tag information about the document. When I want to look at just one project, eg Varian Implementation," I select that column and ...
2
votes
2answers
48 views

Change GUID in lookup column

I have a sandbox solution in SharePoint . I have created number of site columns, Content Types , list definitions and list instances. Everything has individual feature. For Ex: Site column ...
3
votes
1answer
88 views

Document Library Lookup Column

I have a sharepoint list of communities. Each community has an owner (people column). I have a sharepoint document library and a view that joins the document to a community. I am not able to ...
1
vote
0answers
21 views

Adding fields to a list's existing lookup column won't add them to list's existing content types

I have created a custom list, in which I am not using any Site Columns or Site Content Types; I started with the OOTB Item content type and added various custom columns to the list using the "Create ...
0
votes
1answer
35 views

Lookup to Person Picker field

I'm trying to do a lookup to a person picker field in another list, but SP2013 won't show me that column. Any thoughts on how to bypass that?