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)

4
votes
2answers
834 views

Set a date/lookup in ListInstance elements.xml

I have two lists. The first one has customers and the second one has Orders. Now i want to add some (test) data in the elements.xml of the listinstances. For customers this works without a problem ...
0
votes
1answer
139 views

Can a Lookup list field point to web property bag?

In my subwebs I have a 1 row list called "Details" that contains various bits of data that are meant to be web-level metadata. Image field, AssignedTo field, couple of string columns, etc. On top of ...
3
votes
0answers
480 views

Query string filter on an InfoPath lookup field

I am trying to use a query string filter to filter data on an InfoPath form using this guide. The column that I'm trying to filter is a lookup field and it is not available in the list of Consumer ...
0
votes
1answer
195 views

Trying to get lookup (Title) value, but returns null only in Client Object Model

I have this query: <View> <ViewFields> <FieldRef Name='Title' /> <FieldRef Name='itlgCategoria'/> </...
0
votes
3answers
4k views

Displaying value in infopath not the number

Infopath. In my infopath form. I want to show the teamName as "team 1" value but it is displaying "1" number instead of "team 1". The TeamName is a lookup column in the ProjectList.
2
votes
5answers
11k views

Cascading Dropdown

I am new to SharePoint 2013. What I need to figure out is based on the following situation. I have several school districts with multiple schools within the school district. I would like to create a ...
0
votes
1answer
157 views

How do I lookup string value from another list?

I'm having trouble using a "Lookup" type field to lookup values from another list. I have two lists. 'Invoices' list shows all the invoices' being entered by colleagues with all the general ...
0
votes
1answer
252 views

How to submit multi-checkbox items in a formatted string to SharePoint lookup column

I'm new to InfoPath and SharePoint and i also use the trial version of qRules, i have 2 sharepoint lists, with one (let's call it "list1") having a lookup column to the second ("list2"), and this ...
0
votes
1answer
78 views

Lookup list filter only future events

I have a task list that assigns tasks to specific future events. The custom task has a lookup column that is based on an events calendar. Is there any way I can cleanup this lookup list to only show ...
0
votes
1answer
95 views

New list column is not displaying in dropdown list when creating a lookup column

I have an existing list called Employees and I have added a new column "Company". I would like to create a lookup column using Company but Company is not displaying as an option in the dropdown list ...
2
votes
0answers
325 views

Filtering LookupMulti by FilterMultiValue SP2010

I can't filter LookupMulti's column using FilterMultiValue. My Url contain this fragment FilterName=Tags&FilterMultiValue=Flower;Sword Three is nothing, apart correlation ID. I found in ...
0
votes
3answers
726 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 ...
6
votes
3answers
5k 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
2answers
33 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
2k 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
217 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
225 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 ...
1
vote
3answers
543 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
787 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
86 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
1k 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
1answer
235 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 ...
1
vote
2answers
2k 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
441 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
391 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 ...
1
vote
1answer
350 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
58 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
266 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
107 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
62 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 SPFieldLookupValue(oPage.ListItem["TaggingKeywords"]....
0
votes
2answers
46 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
148 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
110 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
190 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
662 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
373 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
43 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
635 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
503 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
2k 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
192 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
0answers
1k 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
254 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
340 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
60 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
59 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
229 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 ...
1
vote
1answer
5k 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
203 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 item'...