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)

3
votes
1answer
519 views

CAML Query on a Lookup Field that points to a Calculated Field throws Exception

I wrote some CAML Queries to get data from a List that has lookups on another List. All is working fine as long as I do not reference a Lookup Field which points to a Calculated Field. I tried ...
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 ...
1
vote
2answers
143 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 ...
0
votes
1answer
897 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
98 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, ...
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
99 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
30 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
62 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
133 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
135 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] ...
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
217 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
90 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
181 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
315 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
282 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
396 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
145 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 ...
0
votes
1answer
37 views

Is there any programmatic way to determine if a list has any relationships to other lists?

If list A has a SPFieldLookup to list B is there any thing in list B's SPList object to show the relationship with list A? While I can flip through list A's fields and find the relationship to List B ...
0
votes
1answer
124 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
0answers
194 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 ...
1
vote
1answer
842 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 ...
1
vote
2answers
4k 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: ...
1
vote
1answer
501 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 ...
0
votes
2answers
92 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 ...
0
votes
1answer
444 views

Change size of Multilookup field

I have a multi lookup just like this image, with 2 listboxes and Add and Remove buttons: ...
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
3answers
882 views

Calculated Formula Insert From Another List

I have List A which has all information. List B has Col 1 that looks up one of the List A's columns. Col 2 is a Calculated column that want to use Col 1 but SharePoint is not able to see Col 1 ...
0
votes
2answers
3k views

How can I combine multiple Lists into one view for editing

I had a list with 18 lookups which exceeded the SharePoint 2010 threshold. So I broke it up into 3 lists all having the same "ProjectID" column as a lookup to the first column so that there is only ...
1
vote
2answers
325 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
2answers
3k views

Is it possible to make a lookup column that looks up “Person or Group” type from another list?

I'd like to create a lookup column in my list (hopefully using OOTB functionality) that shows a column from another list. Sounds simple enough, but the available columns to choose to lookup from my ...
4
votes
2answers
997 views

SharePoint2010 Lookup Column Display issue

I have a simple list with three lookup columns in it. One LC has 5 items and displays as simple dropdown and there are no rendering issues (So ignore this column now). The other two columns has more ...
3
votes
3answers
969 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
578 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
202 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 ...
1
vote
2answers
680 views

Allow Fill-in For Lookup Columns

Is it possible to enable Allow Fill-in option for Lookup type columns, like Choice type columns.
2
votes
1answer
437 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
1k 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 ...
1
vote
0answers
260 views

FilterMultiValue on additional lookup column Skill:ID

I try to filter my sharepoint list based on some filters. Because the checkbox option "Allow Multiple Selections" does not work I am trying to build some own implementation using the QueryFilter ...
0
votes
1answer
102 views

Is Multiple Lookup API's supported JavaScript

Is Multiple Lookup API's supported JavaScript language? I need to create a new column, retrieve data from multi-lookup using JavaScript API's not sure if it's supported.
0
votes
2answers
558 views

Accessing LookupFieldValue throws error

I have a lookup field on a list (header) that looks up values on the same list. I am trying to read the value out of that lookup with this code: using (SPSite site = new SPSite (mySite.ID)) { ...
0
votes
1answer
686 views

How to get count related Lookup value programmatically?

Another day, another question ;) So, I have two custom Lists, "Attendees" and "Events". In the Events-List there's a Lookupfield "Registrations" which I want to fill programmatically on page_load. In ...
2
votes
2answers
1k 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 ...
1
vote
2answers
68 views

Calculated Column Question - maybe

I am pretty new to this, so apologies if it is a stupid question. Basically, I want to know if it is possible to create a column that references another column at the level below. Specifically, I ...
1
vote
1answer
346 views

How do I Filter a Lookup field based on a 2nd columns value

I have List_A = { Title, Type} & List_B = { Title, myLookUpField } I want myLookUpField = Title, IF(Type=="Red") I know.... List_B.Fields.AddLookUp("myLookUpField", List_A.ID, false); ...