A lookup column is a SharePoint list column that retrieves its available values from another list in the SharePoint site.

learn more… | top users | synonyms (1)

0
votes
1answer
28 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 ...
1
vote
1answer
462 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
13 views

My Deployed Site Column Lookup Isn't Referencing the List

I have a SharePoint list that was created through the SharePoint UI (i.e. not through code/features/packages). I'm trying to define a site column in my feature/package that is a lookup to this table. ...
0
votes
1answer
45 views

How do I link two fields in a form so that when one field is filled out, the other autopopulates based on another list?

I have a form that is looking up a list It is pulling in all of the degrees When I enter a field into the field box, say Fireman, it still pulls down ALL of the Degrees options. I want it to ...
1
vote
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
1answer
776 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
0answers
16 views

In O365, is it possible to create list item by setting Lookup Field in sub site list?

I have been implementing a workflow on a Parent Site List A. The workflow is then instructed to create a list item on an existing List B on a subsite. I have been able to create an item on List B ...
1
vote
2answers
787 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
18 views

Update List items using workflow - multiple items

I have two SharePoint lists, one list contains Tools and the other list contains Jobs. On the Jobs List, I enter a new job. I then will select the Tools needed for the job. The Tools are in a lookup ...
0
votes
2answers
5k 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 ...
3
votes
3answers
2k views

Deactivate the link of lookup-fields (2010)

On our solution (SP Foundation) we multiple lists with quite some lookup fields. Some of the lookup fields are user fields who link to the user info list, and we don't want that to happen. Of ...
0
votes
0answers
10 views

How to populate lookup library field with value from list from the same page?

Essentially, I want to add document library to the custom list's "edit" child page. The goal is to replace basic custom list's attachments functionality with more sophisticated one. I can do that ...
0
votes
0answers
11 views

Filtered Lookup multiple selection

We have list A and list B. List B has a lookup column from the title field of list A. I created a data source with the designer to filtered the lookup values from list A (show lookup value if status ...
2
votes
1answer
134 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
1answer
14 views

Lookup column added to list created by importing Excel spreadsheet not working

I have a list on a site that was created by importing an Excel spreadsheet. I have several lookup columns that were deployed to the site using a feature. Going into the site columns gallery, I see ...
0
votes
3answers
4k views

lookup field test if value is (none) from SPD Workflow

everything is in the title. I have a lookup field set to optional and I need from my Workflow to test this field. When you do not select any value, you have (none) in the interface but I cannot seem ...
0
votes
1answer
2k 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
1answer
237 views

SharePoint 2013 lookups with more than 20 items as select or input?

So I was reading about doing some JavaScript to manipulate the default forms for our lists and came across this: ...
0
votes
1answer
427 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
1answer
550 views

linq query for lookup list column error - query uses unsupported elements

I'm trying to return the list item ID (s.ID), and the ID of a lookup column (s.VendorID). I get the following error: The query uses unsupported elements, such as references to more than one list, ...
0
votes
3answers
131 views

Is it possible to have a lookup field with autocomplete feature

I have defined a lookup field with multiple values over a contact list inside my SP 2013 team site, and by default I got a select list as follow:- So is there a way to have the lookup field with ...
0
votes
1answer
2k views

Add new item to child list and refresh the parent form - multiple lookup

I've created a parent list (Vendors) and a child list (software list). There can be multiple vendors for one piece of software. I've created a custom new form with a link which opens up a modal to add ...
1
vote
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
550 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
2k 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 ...
0
votes
1answer
28 views

Is there a way to add an item to a list by clicking a link in another list's view?

I am currently making a sharepoint Lists application for my company's recruiters to assist in their campus recruiting process. So far this consists of two lists, the first, Candidates, is a simple ...
0
votes
1answer
17 views

Missing columns in look-up column

I created a new document list and enabled some column in the view: Afterwards a I created a custom list and added a look up column. In this column I would like to specify a column of my document ...
0
votes
1answer
255 views

SharePoint user group cannot access a certain field in a list

I want a certain group with contribute permission to be able to add and edit items into a list. One of these fields is a lookup value. This seems to cause trouble for the user, since the person cannot ...
1
vote
1answer
33 views

Workflow error: The value 'Value' cannot be read as type 'Int32'

I've a list named APE - Opções with this values: Título | Nota Nunca | 1 Algumas vezes | 2 Frequente | 3 Sempre | 4 N/A | 0 And a list ...
1
vote
1answer
172 views

Displaying text in a Look-up column

Apologies for not being clear. I'm try to display a "multiple lines of text" column as a look-up field in a new view of the parent list. I have tried SP Designer and most of the standard webparts. ...
1
vote
0answers
740 views

How do I create a lookup field for a hyperlink field and display the URL?

I have a regular, out of the box, list of type "Links". I have created a custom list that includes a lookup field to the URL field of the "Links" list. I have created a custom xsl template file for ...
0
votes
0answers
9 views

Multiple Column Lookup in SSRS expressions

Hi I am working in SSRS 2012. My dataset/table schema is as below. ID,Name,Age,Address In my report table this data set is the source. What I want to do is I want to filter my data set in ...
3
votes
1answer
936 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
21 views

Populate Data using SharePoint Lookup Column feature in Document Library from a SP List column data

I want to populate a Sharepoint Library column with data from a column of a Sharepoint List. My question is Is SP lookup possible on the following scenario SP List column data --> SP Library ...
0
votes
1answer
20 views

How to change lookup hyperlink to open in another tab instead of a dialog in SP2013

Currently when I click on the accounting projects link: This dialog box opens: Instead of a dialog box I want this page to open in a new tab: Any Ideas on how I can do this? I tried using ...
2
votes
0answers
21 views

Lookup fields will be rendered as a list of checkboxes inside iphone safari web browser , instead of being rendered as a select list

I am working on an issue tracking list which have a lookup column named “Related Issues”, which is rendered as a select list inside IE on desktop browser as follow:- But when I access the list from ...
0
votes
2answers
681 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
11 views

Joins and ProjectedFields not working in SharePoint Online (wave 16)

I am creating a view with Joins and Projected fields and get no compilation nor activation errors/warns, yet when accessing the view in UI, I get field not found error. Lists I'm joining are: ...
1
vote
1answer
2k views

How to add values from a multi-valued field from a list using SPD's Update an Item Action

I have a workflow that automatically updates the value of a multi-valued field in an item. This workflow is working as expected. BUT, when that field/column of an item has a value already, the current ...
0
votes
1answer
35 views

Lookup Column of a List Column

I have a requirement for a project site in SharePoint. The Site will have: 1st List: a Stakeholders List with the names of people involved (people/group type) in the project and their Project Role ...
0
votes
0answers
21 views

Sorting lookup column by descending dates in list form in SP 2010

I have a lookup column (Date of Distribution) that pulls a list of dates from another list on the same site. When the lookup pulls the dates, they are in ascending order, so the oldest first down to ...
0
votes
0answers
14 views

Using lookup to populate list and want Items select to update other list as checked out

Using lookup to populate list and want Items select to update other list as checked out. I have 2 lists with data. Using 3rd list to store select items from other lists. List 1 is a job list. List 2 ...
1
vote
1answer
631 views

Clear all values in a multi-value lookup, via REST, SP 2010

Conditions: SP 2010, html/javascript, using REST to read/write to various lists. Im using a jquery multiselect plugin to set a multi-value lookup column. I need the selecting Groups of items, easy ...
0
votes
1answer
41 views

Unable to create a look-up site column at the site collection level, then override it at the list level

I want to create a new Lookup site column named "List Attendees" which will contain unique values for each list. so i created the new lookup at the site collection level, but i faced the following ...
1
vote
1answer
50 views

In SP Online, how to return the default HTML of a lookup field when overriding the Item Template in a list view

I've found various methods to return the default values for the field template override, including lookup, but I have been unable to find or successfully implement a method to do the same for fields ...
0
votes
1answer
31 views

Mixing between “lookup” column type and “People or Group” column type

I want to create a site column that contain a list of “Project Managers”, where some project managers are already defined inside Active directory and are defined inside a SharePoint security group , ...
0
votes
1answer
156 views

copy one column value to another column in a list

I have a list named ABC in MOSS 2007 List has 2 Views (All Details and Multi Location) 2 columns (BA-tech and BA for both views) BA- tech field is "Single line of text" type and BA field is "Look ...
1
vote
0answers
352 views

Filter a CQWP on a Lookup Column

I'm creating a custom page layout that contains a CQWP that I'd like to display documents related to the page. The document library has a lookup column that relates to the page title in the Pages ...
2
votes
0answers
23 views

Multiple Criteria Lookup in Parent List

I have a list of projects (Project List) and another list of periodic status updates (Status Update List) related to each project (one-to-many). I need a lookup column in the Project List that ...
0
votes
2answers
47 views

Alternative to Lookup Column

I have a list with a lookup column displayed as a dropdown menu in the NewForm allowing the user to pick a contact person retrieved by lookup to the contacts list, however this list will soon grow ...