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)

5
votes
3answers
3k views

BCS External Content Type with 20,000+ items (O365)

We have a large database of 20,000+ items on a local database that we need to get into Sharepoint Online 2013 in O365 to use as metadata for various documents in multiple locations. New entries and ...
0
votes
0answers
9 views

Choose a library view to add to item in calendar

We have a library for which we create views so that users can easily find documents. One of the regular views that we create (on a monthly basis) is a selection of documents for a meeting. We don't ...
0
votes
0answers
23 views

Can I implement “reverse” permissions?

I have got a SharePoint list that is going to be used as the data source for other pages, where people can look up information. It contains: Country (Short Text) Organization (Short Text) some data ...
0
votes
2answers
31 views

Lookup on a list with permissions

Is it possible to keep a list security trimmed to a small group, while allowing a list item column to be used as a lookup? The purpose would be for the larger audience to be able to create a task ...
7
votes
3answers
1k 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, ...
0
votes
1answer
101 views

SP2013: List with columns “Lookup (information already on this site)” display as URL's

I have several lists on a site that have dropdown columns that refer to other lists on the same site to keep things consistent (e.g. a department dropdown that should show the same values everywhere). ...
1
vote
1answer
81 views

How to update content type to include additional lookup fields for all instances of content type?

I have created a lookup field as a site column in my root site. The field also brings several additional columns showing information from the list. It is used in a root site content type. I have ...
0
votes
0answers
114 views

Updating a (calculated) field based on lookup field :: Workarounds

I am a site owner in SP2010 impl., at work. Not a farm admin / super admin. For one of my needs, I am designing a list using Datasheet View. I have columns of People, Lookup and Choice datatypes. ...
7
votes
5answers
9k views

Why is my column not shown under “Add a column to show each of these additional fields”?

In SP2010, I want to get 2 columns from another list and merge these columns. But when I am trying to do this via Lookup, they are not shown under "Add a column to show each of these additional ...
0
votes
0answers
63 views

How to add document to doc library with lookup columns

I am creating an upload program that needs to be able to upload documents to my document library. This document library is configured to allow content types, and I am getting all of the columns from a ...
1
vote
3answers
305 views

Limiting permissions to list-items and library files without using folders

I have some files in a flat library, i.e., no subfolders, that need to have access restricted to a couple usergroups. I understand that one way to do this is by placing items in a subfolder in the ...
2
votes
1answer
750 views

In a DVWP my Multilookup column is not returning IDs, only column values

I've added a DVWP to a page. The DVWP shows data from a list with a multi value lookup column. The value returned for this column is in the form: value1;value2;value3. Now I want to render this ...
1
vote
0answers
57 views

How to auto generate parent MMD columns based on child MMD columns?

This is the structure of one of my Term Sets. I have a Site Column called Record Type (Deeds, Agreements, Permits) I have a Site Column called Deed Type (D1, D2, D3) I have a Site Column called ...
1
vote
1answer
430 views

Lookup column to Picture Library

I've created a picture library called "Reusable icons" with all my icons. Then I created a new Custom List with a lookup column to the "Reusable icons"-library. Problem is that I don't get the url ...
0
votes
0answers
70 views

Filtered Lookup Column from other Lookup Column

Why is this so difficult! SharePoint Online Office 365 List 1 : Group - Title, Desc List 2 : Category - Title, Group-Title(Lookup) List 3 : Document - Title, Category-Title(Lookup), ...
0
votes
1answer
165 views

Specify Lookup list for the 'Title' Column of a Gantt chart view

I was hoping to use a lookup list as the title column for a Gantt chart view. The problem is when I go to the Gantt columns in the settings for the view it doesn't display any of the lookup list ...
0
votes
2answers
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
2answers
753 views

How do I remove duplicates from a drop-down list?

I have a field in a list with the type drop down. It is supposed to show available countries which works. However, there are a lot of annoying duplicates of the same country. How do I remove them?
2
votes
1answer
184 views

Lookup field is empty after List Item is added

Here is My Problem: I have a New Form in a list and I have added some custom JS code to it. In the form is a "Registration number" lookup field with more than 20 items in it. I need to populate it ...
2
votes
2answers
137 views

Save Site as Template (with include content) does not accept LookUpSite Columns

After long search on the web i could not figure out why i have been facing wired behaviour today with my SharePoint Site. I explain, I have a Site Collection (Blank Site Template) which contains ...
0
votes
0answers
106 views

Get Lookup field ID from DataTable

I have this code : SPListItemCollection CatList = LinkList.GetItems(query); SPListItem test = CatList .GetItemById(1); SPFieldLookupValue tmp = new SPFieldLookupValue(test["Category"].ToString()); ...
1
vote
1answer
325 views

Lookup Column - SharePoint 2010

Is there any way to link parent site and sub sites? Problem: I have one list on Parent site and I have a few other lists on sub sites. I am trying to create lookup columns in the parent site list to ...
0
votes
0answers
46 views

Cross site lookup columns

If I have site structure as per the below: Site Collection -Main Site -Site 1 -SS 1.1 -SS 1.2 -Site 2 -SS 2.1 -SS 2.2 If I have a list in SS 1.1 is there any way in which I can create a ...
0
votes
0answers
124 views

Import specific row column values into sharepoint list fileds based on a field value in the sharepoint list

I have a SharePoint list (Service List) and an excel document (all registered customers) in the same SharePoint 2010. The Customer list excel document has customer no, location, address, phone number ...
2
votes
0answers
85 views

Join SPQuery in list

List 1 "Posts", fields Title body #comments modified in this list #comments fields is look up from another list Comments: List 2 "Comments", fields title body comments post ...
1
vote
1answer
42 views

SPLookup Filed extract only string values

How do you extract multiple string values in an SPlookup field? I tried the following but it didn't work SPFieldLookupValue LookUpValues = new ...
0
votes
2answers
39 views

How to merge multiple lookup fields?

My scenario in a nutshell: Theres a list which contains some food for example. (2010 Server) Foods ID Name 1 Apple 2 Banana 3 Carrot 4 Potato Theres another list which contain food ...
0
votes
1answer
74 views

How are additional fields stored in a lookup column?

When creating a lookup column it is possible to select additional fields. Does SharePoint store the values of these additional fields in the "child" list, or is a database join performed every time a ...
0
votes
1answer
73 views

List provision order on deployment

I have a generic list with just title fields. I'm trying to have another list use a lookup column to list each item. If I add the lookup to second list after deployment it works. But if I simply ...
1
vote
2answers
97 views

How to get LookupValue in ItemUpdating

I have a custom EventHandler for ItemUpdating on a list which has a Lookup column. If I look in the properties.AfterProperties for the column in the ItemUpdating event I get the LookupId value but ...
0
votes
1answer
211 views

More than one user not getting email alerts (SharePoint 2010)

I'm using SharePoint Designer 2010, and I'm creating an application which assigns tasks to other people. In the application, whenever a person is assigned a task, that particular person (or group of ...
0
votes
1answer
202 views

Send Email using Lookups from Workflows (SharePoint 2010)

I'm currently using SharePoint 2010 Designer, and the 2010 version of SharePoint. So I'm currently designing a SharePoint application which can assign tasks to other employees. Any tasks assigned ...
1
vote
0answers
39 views

Document Set lookup error

I have what seems like a minor bug when setting up a new document set. I've created a new content type based on a document set. One of the columns in the document set is a look up to a supplier list. ...
0
votes
1answer
555 views

Why is the associated lookup field not on the dispform.aspx?

I have three lists: Events (calendar) Customer1 (custom list from scratch) Customer2 (custom list from template) When I added the lookup of Customer1's ID and added the associated field "Title," ...
1
vote
1answer
158 views

SP 2013 REST API retrieve values from lookup library

I have a custom list 'MyList', containing a (single value) lookup field 'MyLookupField', which points to a library 'MyLibrary'. I now want to retrieve all items from 'MyList', including the Link to ...
2
votes
2answers
1k views

Invalid Look up Value . A look up field contains invalid data

I have a multi select Lookup column . I have to populate values to the lookup column from another column on a button click. I achieved it using below code but when i try to click ok/save it is ...
0
votes
0answers
25 views

Workflow Lookup Column in Site Workflow

I am using Sharepoint Designer 2013, and I am looking for a way to create a column lookup that looks up the current item and looks for the column Due Date. Can you do this and apply this workflow to ...
2
votes
2answers
2k views

Can text in a lookup column be displayed as text with no link?

SharePoint 2007 and have site curate access only. List-A has a column Name and that is a lookup to List-B, which only has names and no other information. Now when looking at lookup columns in views ...
2
votes
1answer
97 views

How does the look up function work?

I currently have two lists: List #1 have the fields country and colour (and several other fields that are irrelevant) List #2 have the field colour (and several other fields that are irrelevant) So ...
0
votes
2answers
1k views

Change the source on a lookup column?

Is it possible to change the data source on a lookup column? I have the source set to list A but I want to change it to List B.
0
votes
0answers
452 views

SPServices.SPCascadeDropdowns - Display Title rather than key

I'm using SPCascadeDropdowns to filter a child drop down which is working. However, I would like to display another column than the one in the relationship. I have created two lookup columns that ...
0
votes
1answer
214 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
0answers
120 views

Creating a survey with a question being lookup column with filtering

So I need to create a survey on a monthly basis with just one question. Possible answers should be the values from a lookup column, but limited only to those from the previous (calendar) month. Is ...
0
votes
1answer
334 views

lookup external list

I have two tables: Documents Project task What I am looking for is the following: I have a page with project tasks in a hierarchy list (done) Clicking on a task will open an edit screen (done) ...
0
votes
1answer
58 views

How to show/Hide Data in dropDown field in a list depending on other list boolean field

I have two lists; Cars{brand,color,price} and Colors{designation,disponibility}. I made the field color as a lookup field to display colors from colors list. My problem is that i ONLY want just to ...
0
votes
2answers
51 views

How do I get a lookup column to filter in 2013?

I have data in page view that places the information for "project" in a lookup column. When I try to filter this column I get the error "this column cannot be filtered." How to I get this column to ...
0
votes
1answer
113 views

Value does not fall within the expected range during itemupdating

I've an event receiver and in itemupating i check if i've a value for a lookup field but get an exception. If i look in powershell, the column exist so the first if is ok but he can't test if it's ...
0
votes
1answer
2k views

“Value does not fall within the expected range” for Lookup field and its relation to Resource throttling of the web application

I was querying a list having many columns, some of them being look-ups. My query was to return a SPListItem based on one ID. Now, when I want to bind the value of look-up field from the SPListItem to ...
0
votes
1answer
48 views

Linking two lists to update when one or the other is changed

I am a bit of a SharePoint novice and I am having a few problems getting it to do what I would like it to do I want to link two separate lists: for example if I check a check box for one of the ...
1
vote
1answer
232 views

SharePoint 2013 - Reverse Lookup

I am trying to achieve the following in SharePoint 2013. I have two (2) lists a server list and an application list. Each list contains a lookup column which a user can select which applications are ...