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)

13
votes
1answer
11k views

How to get a SPFieldLookupValue from an SPListItem?

When you get an SPListItemCollection from a SPList.GetItems(SPQuery) request, and the items have SPFieldUser or SPFieldLookup fields, what is the sexy way to get typed values, not the ...
0
votes
1answer
107 views

Lookup fields blank after dialogue

I have a problem on a SharePoint 2010 site. I have lists which contain Lookup fields. When I perform any action on the site that causes a custom dialogue to be displayed, the lookup fields become ...
0
votes
2answers
89 views

How in Setting List call from one list to another by fields in list

I know how call elements in the same list. It can be done by: And then i take a copy from another list. Now a question how to colect a copy of field value, but from another list?
3
votes
3answers
1k views

How to create web-related lookup field to 'pages' list?

I have SharePoint site collection 'http://microsoft.com/' with few child webs ex: http://microsoft.com/news/ I want to create lookup field to 'Pages' list. On each child web lookup field should ...
2
votes
2answers
5k views

Add additional field to lookup field inside schema.xml

I'm following the steps in this article to setup a joined data view webpart joined on a lookup field: ...
0
votes
1answer
1k views

Populate MultiLookupList : Remove Item

On http://weblogs.asp.net/bsimser/archive/2013/02/20/defaulting-values-in-a-multi-lookup-form-in-sharepoint.aspx I found some nice code to pre-populate a multilookuplist (and remove the selected ...
1
vote
0answers
145 views

Multiple Column Lookup field from Access to Sharepoint

I have two fields called "Tool ID" and "Tool Name" in my main "Tools" table in Access. "Tool ID" is set as the primary key, in that it gives each tool a unique autogenerated number. When I ...
0
votes
1answer
488 views

Change size of Multilookup field

I have a multi lookup just like this image, with 2 listboxes and Add and Remove buttons: ...
0
votes
1answer
131 views

Numeric field in SP displaying 10 as 10.000000 how do i remove that?

I have a list look up column which fetches values from another list which is number(int), but on loading it takes it as a flaoting number. for example the value in list firld in 10 but it is taken as ...
0
votes
1answer
664 views

Editing rendering of Lookup Field - XLST

Let's say I have a simple text column named MyCustomName with four fields in it: REMOVE one REMOVE two three REMOVE four ...and I want them to display like one two three four in my list View. In ...
2
votes
1answer
215 views

Self Referencing Related Documents Library Through Lookup Column

I am trying to create a single document library that links to documents in the same library in SharePoint 2010 Server. I've created a multi-value lookup column that references the same library to ...
0
votes
1answer
43 views

Cross site cross database lookup field SP2010

SiteCollection 1 in ContentDB 1 has List 1 with custom lookup field. This lookup field returns all text fields from any selected list in a site collection specified. Each site collection is in a ...
1
vote
1answer
67 views

How to retrieve documents from list?

I created a simple Custom List in WSS3. I also created a Document Library with an additional column field which is a lookup to the Custom List that I created before. Now when I am on the Custom List ...
1
vote
1answer
125 views

Include additional fields with Person Site Column

When I create a column of type Lookup, there is a section at the bottom labeled "Add a column to show each of these additional fields:" I want to do this same thing with a Person column. It seems ...
3
votes
2answers
3k views

Lookup Column Values With and Without ID;# in SPD with DVWPs

I see this difference when I'm working with lists in Data View Web Parts and manipulating the values in XSL. Why do some Lookup column values look like '1;#text' and others just have the text? I've ...
1
vote
2answers
148 views

Lookup field two projects

I've got two Sandbox Solution projects in visual studio that I want to use in SharePoint online. The first project has a list and a lookupfield. The other project has an other list and I want to use ...
1
vote
3answers
1k views

Lookup Field programmatically in FeatureActivated

I've created a lookup field programmatically in the featureactivated method. This is the code snippet. public override void FeatureActivated(SPFeatureReceiverProperties properties) { using (SPWeb ...
0
votes
1answer
1k views

Default null value to a required Lookup Column

The title pretty well speaks for what I need. I have a lookup column on a list, getting data from a custom existing site column i created. I need it be null by default so they get an error if they ...
1
vote
1answer
101 views

Filter a parent list by a particular child list item's lookup field value

I have two lists, Activities and Objectives. The Activities list has a multi-value lookup field that references the Objectives list. I am trying to create a filtered view on the Objectives list that, ...
0
votes
3answers
5k views

Get value from drop down using jQuery (lookup column)

I feel like this should be an easy one but am having trouble finding the answer here and via Google. Using jQuery, how do I retrieve the currently selected value from a dropdown in an ...
1
vote
0answers
61 views

Find all lists that look up a Contacts list

I have a Contacts list in my site collection, and it is used in lookup columns by multiple other lists. Is there an easy way to get all the lists that have a lookup column pointing to the Contacts ...
1
vote
0answers
102 views

Lookup column automatic selection in list form upon adding new item

I have a site page with two related lists, this relation being established via the webpart option "insert related list", and I'm using ID column in my child list as the lookup column. The child list ...
0
votes
1answer
31 views

quick way to access splistitem in different list?

I have 2 lists: listA and listB listA has 2 fields: Title (text) PortalID (text) listB has 3 fields: Title (text), listAField(lookup to listA Title field) UserID (text) I have a UserID value ...
0
votes
1answer
66 views

Lookup Field searchbar

I have this lookup field which is coupled to a customlist of artists. I use this lookup field as a column for another list. So when someone creates a listitem in this second list he or she can choose ...
0
votes
1answer
162 views

Restricting number of selections on a multiple lookup column

How can I restrict the number of values a user can select from a lookup column? It doesn't seem to have the same column validation settings as some of the other column types. I only want a user to be ...
0
votes
1answer
145 views

List GetRelatedFields() returns field ID that doesn't exists in dependant list

I have got list item exception. [ArgumentException: Invalid Field Name.] [ArgumentException: Invalid Field Name. {01b89bed-bbe3-4bcb-9b92-c64183ffe135} /Lists/AcceptanceAgreements] ...
1
vote
1answer
602 views

Issue with lookup column in subsite

I add lookup columns with a elements.xml file and like everyone else I had issues with them once deployed, i.e. "Get information from:" was empty for the lookup list. I found ...
1
vote
0answers
246 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 ...
0
votes
1answer
91 views

Possible to lookup a Sharepoint list in Access?

I am trying to make a very large list of records with about 1,000 items or more added monthly, and I was told that it would be better to use an Access table instead of a Sharepoint list for so many ...
2
votes
2answers
3k views

access additional lookup fields using JavaScript and CSOM

In visual studio I have added lookup field (SubMenuItemIdRefTitle) to list definition listA that references ListB. I have also added <ViewFields> <FieldRef ...
0
votes
1answer
197 views

Adding the other fields in addtional to lookup field in CAML

I have a custom field definition in VS2010 that contains a lookup field (Title). All is well and I can use the Title ref to add items in the SharePoint list UI. in the instance UI, I can also check ...
0
votes
2answers
324 views

How to call a c# method in my XSL File

I have two lists Client and Project, each Client has from 0 to N Project stocked in his SPLookupField where multi values are allowed. And I created a new computed Column in the Client List where it ...
1
vote
0answers
292 views

Calculated columns supporting all column types

I would like to develop a column which will allow the end user to do the calculations based on values of other columns of the same item (SharePoint 2010). I need it to work also with people, look up ...
3
votes
2answers
3k views

Multiple fields to same list in join (CAML)

Current situation: ============= In my example, I've got 2 custom lists: Accounts Addresses In the "Accounts"-list I've created 2 lookup columns to the "Addresses"-list Address1 Address2 When ...
1
vote
1answer
480 views

SPQuery on null lookupfield

I have a contact list with a company lookup field and I need to retrieve those without any company associated so I was thinking can I put it like this: <Query> <OrderBy> ...
1
vote
0answers
147 views

user lookup field for external lists

Guys please don't beat me too much, I want to add user lookup field into my external content type to use sharepoint people picker in my external list, the price doesn't stand up. So is it ever ...
2
votes
2answers
614 views

SharePoint 2010 NewForm.aspx Lookup Fields Issue

I have a SharePoint 2010 Foundation site that has recently been upgraded from WSS 3.0. The upgrade was completed successfully with no glitches. However, ever since I have upgraded the site I have ...
0
votes
1answer
129 views

Can I edit a LOOKUP column?

More concisely: How do I edit a lookup column? I have a custom list with columns [Name] and [Product] named 'MainList'. I would like a third column [Referral] which shows a name found in ...
1
vote
1answer
1k 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 ...
1
vote
1answer
1k views

How to get users/usergroups from an lookup column from SPField

I have a custom list for example "MyCustomListA" I have created a custom ListForm template and overide the ListFieldIterator. I have overide the ListFieldIterator and CreateChildControls to implement ...
0
votes
3answers
6k views

Lookup column to Documents library

Here's what I need to do for a SharePoint 2010 list: Allow users to select the filename from a dropdown showing the items in the Documents library. But the "Add new item" form of the list doesn't show ...
1
vote
2answers
2k views

Modify existing lookup type column to managed metadata type

We are in process of migrating one of our big website which is built in WSS 3.0 to SharePoint 2010 Standard version. In the process we want to convert all lookup columns to managed metadata type. We ...
0
votes
2answers
94 views

Sorting out lookup values while getting them

I have two lists, List A [Document Number, Name, Title,...] (document library) List B [Information Number, Name, Title, Document Number] (simple list) Now List B is getting all documents from List ...
0
votes
1answer
30 views

Checking if a list is consuming lookup value column or not

I have two lists, List A [Document Number, Name, Title,...] (document library) List B [Information Number, Name, Title, Document Number] (simple list) Now List B is getting all documents from List ...
1
vote
1answer
2k views

Updating SharePoint List with Linked Access Database - New List Created Instead of Updating Old List

When you've linked an Access Database to SharePoint lists, how do you make sure that saving the database updates the existing list instead of creating a new one, so that lookup columns pull from the ...
1
vote
2answers
763 views

Allow Fill-in For Lookup Columns

Is it possible to enable Allow Fill-in option for Lookup type columns, like Choice type columns.
1
vote
2answers
350 views

Matching value from single line of text column to lookup column

I have a library containing a large amount of items. The library contains a column of type 'Single line of text' with a code in it. The code was taken from an external system and entered manually. ...
0
votes
1answer
220 views

How to access User Information Columns in a Workflow

I need to access a custom column of User Information List in a work flow. I've create a new column named MyCol in User Information List and now in a workflow I want to access to in when I lookup ...
2
votes
1answer
488 views

Use count-related column value as int in a SP Designer-workflow

I have another problem concerning the count-related column-value of SP2010 in a workflow(see also: How to get count related Lookup value programmatically? ). my use-case: I have a column "actual ...
1
vote
2answers
2k views

What columns count as lookup column concerning the “List View Lookup threshold”

I got the following entry in my SharePoint 2010 log file: "Some lookup fields were omitted from the query results because the list exceeds the lookup column threshold." I checked the setting (Central ...