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
3answers
62 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
1answer
27 views

Using Additional fields of lookup in a worflow

For some reason, SharePoint saw fit that we would not be able to use a lookup in a lookup, so I have been doing the workaround where you use a workflow to copy the contents of the first lookup into a ...
1
vote
2answers
42 views

Filter lookup column based on another field value

Scenario: I have Tasks list with a (lookup) column Project. I have also a multivalue lookup column Predecessors pointing to the Tasks list itself. Question: Is it possible to filter available Tasks ...
0
votes
1answer
3k 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
1answer
63 views

Create a lookup field that is text instead of a drop-down (or similar)?

In SharePoint, I have a list (staff) and a document library and have successfully made a custom lookup column/field from the document library pointing to the staff list (staff id column). This ...
0
votes
1answer
24 views

Is it possible to craete a lookup field to your own list?

sp 2010: Is it possible to craete a lookup field to your own list? I try it now, but the lookup field is empty. My target is to have list items which refer to other list items. Like main and sub ...
1
vote
1answer
957 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 ...
0
votes
1answer
39 views

Pull multiple values through a lookup

I am rather new with SP so I apologise if I cant express myself too well. Problem at hand: Two lists - Shops and Managers with a many-to-many relationship between them. I.E. in Shops there can be ...
1
vote
2answers
31 views

Limit to the amount of values you can have in a lookup field?

Is there a limit to the amount of values I can lookup? When I search for the topic I only get hits on the number of lookup fields you can have in a list. I have tested this a bit and it was ...
1
vote
0answers
23 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 ...
1
vote
1answer
563 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 ...
3
votes
3answers
1k views

Migration tool for specific lists

I am looking for a migration tool that works at the list level, not for a full site or server. One specific requirement is to be able to migrate lists that are connected via lookups. For example, if ...
2
votes
4answers
58 views

Calculated column that updates daily

Is there a way to make a column in a list that updates daily with the current date? If not what's the best way to do this? I was thinking of using the 'Lookup' field to link to the calendar that's on ...
1
vote
3answers
358 views

How to link two lists using a multi-valued lookup column?

I have two lists, one contains files, each file has one or more ID(depending on its content). These IDs are lookups to another list. Now, I generate another list on fly, this list has the ID column as ...
0
votes
1answer
29 views

Get List Items from list linked by lookup

I'm making a JavaScript extension for form elements. The goal is to bind it to a lookup and react on change. Since I'm weak at webservices, I'm using SPServices. var lookupFieldInternalName = ...
1
vote
2answers
427 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
27 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 ...
0
votes
1answer
18 views

Insert list items contains lookup fields to each other from 2 different list

Currently I have two Share Point lists (supposed to A & B), each list contains look up fields to each other. I want to insert records to these lists, the problem is how can I reference the look ...
0
votes
0answers
4 views

Set item property depending on count of related child items

So I have classes (parent) with enrollments as the children (Enrollment is StudentID lookup, ClassID lookup, and Registered/Waitlisted choice box). Right now, I've successfully setup the forms for ...
1
vote
1answer
1k 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 ...
1
vote
1answer
847 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
1answer
496 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
16 views

Assigning a lookup value field, passes through as a blank string

I've currently got a new task list item for a certain content type (DMR) which fails to take through the lookup to the associated list. The statement prints the correct record number in the immediates ...
0
votes
1answer
53 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
51 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
0answers
29 views

How to get lookup field value in document template while editing in word application?

I have a document library whose content type has a document template. I am setting the field values while creating new document in word application where the fields are available to set. Among the ...
0
votes
1answer
1k 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 ...
0
votes
3answers
39 views

Get value of lookup

In js, i retrieve some items and inside there are lookup column and people column. When i print them, it's [object Object] Are there a way to determine if it's a lookup column? This one doesn't work ...
0
votes
1answer
10 views

Content Types Template problem with lookup column in template

I have a content type. When I want to create a new document from that content type the properties (Columns) for that content type also open in my document. The problem is that there is one lookup ...
0
votes
0answers
11 views

When I am using a look-up column, once I have used one value from another list, can this value be hidden for any subsequent entries?

I'm in the testing phase of setting up a database and a log on SharePoint. The log requires information from the database so I have set up a look-up column in the log and database to link the ...
0
votes
0answers
14 views

How get current user login name and populate his records in a lookup field

I have a library 'Download Asset' in which different user will upload files. In this library there is a column 'AssetName' . Now I am creating another list 'feedback'. In the feedback list there is ...
2
votes
1answer
487 views

How to update metadata?

I have following code (didn't list the whole code) behind a button on a InfoPath Managed Form. and it works meaning I can submit data to a list. Now I have 2 controls on the form that is ...
0
votes
1answer
16 views

Columns not displaying value

I've added some columns (name, ID etc ) to the document library after the documents have been uploaded, and got no value displayed. Is there any way to fix this or I'll have to recreate the library?
0
votes
2answers
48 views

SharePoint 2013: How to find orphaned lookup values

I've got a projects list in SharePoint 2013 that connects to two document libraries by way of a lookup column. Each document set in the libraries should ideally have its lookup column pointing to a ...
0
votes
0answers
12 views

MultiValue Send an Email Lookup

Is there a way for the Lookup that is in the body of the email to send multiple values. I have a repeating section in my form and it currently will send a seperate email for email repeating for I want ...
0
votes
0answers
29 views

Display error - web parts with look up columns

as seen below I have a display error with my dropdown arrow from the look-up columns. I have basically put two appparts on a webpart page on Sharepoint 2013. Appart 1 contains of two lookup columns A ...
1
vote
1answer
705 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
190 views

get an error while exporting access database to sharepoint 2007 lists: lookup contains values that do not exist in the related table

I try to export a table in a access database to sharepoint 2007. All related tables are automatic exported to SharePoint as lists. SharePoint creates lookup fields for each relation. Under the export ...
0
votes
0answers
38 views

Lookup Columns and Web Part Connections

I'm working on creating a Page Template which will display various content from different lists together based on a common lookup field which is in each list. I've created a new Content Type based ...
0
votes
2answers
50 views

Cascading Lookup columns

I have a project where I need to create a form. In that form I have several columns. The columns that I have questions about are assignment category Assignment type I have questions because the ...
0
votes
1answer
429 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
21 views

Accessing individual elements of a field that has multiple values in a workflow

So I have a Class and the class has a field Students. Students is a lookup to the Students List that accepts multiple values. I want to build a workflow that, on item creation, will make a row in ...
2
votes
1answer
296 views

Calculated field shows seemingly random number when set to be empty

I'm trying to set up this solution for creating a filtered lookup: How to make a filtered lookup field I have set up an ItemAvailable column like this: The column "Availability" is a choice ...
0
votes
2answers
41 views

Lookup in SharePoint

I'm using Sharepoint 2010. I have a List "Discipline" with 3 columns Discipline Code Discipline Des.-Site 1 Discipline Des.-Site 2 A A1 ...
1
vote
3answers
1k views

Compare two person columns in a list

I have a list which has a "Person or Group" column called as Reviewer. I want to notify the reviewers whenever he/she is added to the list item. I created a custom workflow which sends a mail on ...
0
votes
0answers
23 views

Can't use additional fields from lookup column in workflow

I have a list with name, department, email and summary column (which is a calculated column from name/email/department). Then i have a document library. Here i have a lookup column called Guarantor ...
1
vote
0answers
36 views

SP 2013 : Specific item in a lookup field cannot be filtered

the list A has a lookup field connected to list B in field Title. One of the items in list B has title "CCAA". On A/ViewAllitems, i can filter in column lookup:listB:Title for every item, except for ...
0
votes
0answers
25 views

Rootfolder=* in lookup-link causing troubles

I've got 2 lists, a User- and an Issue-list. On the Issue-list I've got a single-lookup to the User-list, so 1 Issue can have 1 User assigned for it. The column in the User-list that's being looked ...
1
vote
1answer
29 views

Update list item once library item is created

We have a list that is used to notify people that they need to create an item in a library. We want to update a field in the list once the item in the library is created. We tried to use the method ...
1
vote
0answers
26 views

How to develop an event receiver on selecting item from dropdownlist

In my SharePoint list,I have a lookup column. When I select one item from the lookup,I need to show the information from the selected one(like title,ID...). I think that developing an event receiver ...