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
548 views

XSLT Listview webpart not showing site column lookup values

The Problem: We have a top level site that contains various lists of data. The information in these lists are exposed to subsites using site lookup columns. In our subsites we have various lists that ...
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
27 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
116 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
97 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
122 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. ...
0
votes
0answers
73 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
335 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
757 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
64 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
518 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
76 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
178 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
914 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
228 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
171 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
120 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
328 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
47 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
138 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
92 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
47 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
40 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 ...
1
vote
1answer
96 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
80 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
111 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
275 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
239 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
40 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
576 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
223 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 ...
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
118 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
572 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 ...
1
vote
0answers
147 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
336 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
59 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
53 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
131 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
3k 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
66 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
286 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 ...
0
votes
1answer
135 views

Is it possible to populate a Lookup Field in a list with the List Content Types

What I'm trying to do is create a list-associated workflow that will start an Approval process with different Approvers, depending on Content Type. I cannot associate a workflow directly with each ...
2
votes
2answers
2k views

Autocomplete Lookup - Finding the Best Approach

In my past months learning the ins and outs of Sharepoint, I've had some difficulty finding a really good solution for creating an Autocomplete Lookup. I've explored a couple different options, each ...
0
votes
0answers
61 views

Look up field shows [object Object] on view

My list is custom code, which has a look up field to another list on same site. But when I create items, this field displayed as [object Object] on view (in display form, it still displays normally). ...