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
1answer
12k views

Setting the value of a lookupfield(sharepoint dropdown formfield) in sharepoint 2010 list forms

How can i set the value of sharepoint form field dropdown box(lookupfield) in sharepoint list form when the form gets saved (using jquery) note: the lookupfield (dropdown formfield renders as input if ...
0
votes
1answer
37 views

How to set value to fields of List item getting values from the folder that it is in?

I have some folders with some properties(Name of project, Project Number and etc.) When I create a item inside of this folder I need to fill out these information again for the item. I would like to ...
0
votes
3answers
334 views

How to design look up list for 20 sub-sites?

Say, I have 20 sub-sites under corporate sales. There are 3 lists that drives the look up columns. Country (USA, Mexico, Norway, Morocco, etc.) Regions (SW, NW, S, W, N, MW, etc) SalesArea (Service; ...
1
vote
1answer
417 views

Site Column as lookupfield creates false URL-Strings

I have a created a custom site column, which is a lookup field, on my rootsite. However, I use this colum now on a subsite in another list. The idea is, to have a central list with lets say Divisions, ...
0
votes
0answers
473 views

Values missing for dependent lookup column from parent list when using linq

Situation I have 2 site content types defined that are deployed as a site feature: Customer Name Address Order Value There is a second web feature that deploys a list to the root site for ...
0
votes
1answer
51 views

Menu control in sharepoint

Is it possible to have a top menu in sharepoint like when i click on the tab it should provide me a mega menu.Is it possible through OOB of sharepoint..please share your ideas..
0
votes
1answer
40 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
633 views

Add multiple items a SharePoint list

I am creating a suggestion list using SharePoint 2010 custom list. My issue is I want to give the login user the ability to add others users to the form. I am thinking of doing a parent Child ...
3
votes
3answers
691 views

SPSiteDataQuery and Look-up column

I have a requirement to iterate through multiple task lists under SharePoint sites and sub-sites. I am using SPSiteDataQuery to achieve this. I have an issue with fetching the data when the column is ...
0
votes
2answers
136 views

Updating List XML on Office 365

I'm trying to create a lookup column on an Office 365 SharePoint dev site through an app using SPServices but I'm not having any luck. function createLookupColumn(listGuid) { ...
0
votes
1answer
92 views

Filter Lookup from another lookup

I have a list of projects. Inside the project list you can select a Client. I have a list of Clients. I have another list, a list of Contacts, they have a lookup column called Client to specify from ...
2
votes
2answers
96 views

Am I doing something wrong, or are these common pitfalls or limitations of using lookup lists?

I'm using (and limited to) OOTB Foundation 2010, and have been exploring lookup lists. I am discovering a few things that aren't working the way I'd like, seem to be working inconsistently, and are ...
0
votes
2answers
792 views

SP2010: How to display a lookup column in a .aspx displayform

I have the two Lists Articles(A) and Serial Inspections(S). The Article-List has columns: Article-#, Name, DescriptionDE, DescriptionEN, somemore... The Serial Inspections: Inspection-#, Inspector, ...
3
votes
1answer
3k views

How to sort SharePoint 2010 lookup combobox?

I have a lookup combobox whose source is another SharePoint list. By default, this combobox items are sorted by word order but I want to sort this items with another/custom order. How can I do this? ...
1
vote
1answer
812 views

Fetch Username from Lookup-Column using Powershell

In my powershell script, I have a method that fetches a username from a sharepoint list. This works fine - my problem is that field is from a lookup column. The user chooses the username from a ...
0
votes
2answers
825 views

Choose Username column in Content-Type

In my portal I have two lists. One (we'll call it the people-list) is a list of people's first and last names and their username (person column) if they have one. I have created a content type that ...
7
votes
2answers
7k views

How to display lookup additional field in display form?

I have two lists: Projects and Tasks In the Tasks list, I have created a lookup field titled ProjectID which targets ID filed from the Projects list. Also, I have set for this field to display an ...
3
votes
2answers
5k views

Problem with Sharepoint ContentTypeBinding and Lookup field

I have a problem with ContentTypeBinding when creating a new site. I have custom site template definition where I have referenced Publishing Server Feature, so list Pages is automatically created on ...
0
votes
1answer
131 views

How do i declare array for the lookup column using jquery

How do i declare array for the lookup column using jquery. I have a column whose values should be declared as array. so that my requirements get it complete. I need that ID for every values to get ...
0
votes
1answer
391 views

Access Lookup to Linked List

I am trying to create a lookup from one Access table to a linked list from SharePoint. I need to have a lookup between the two because in order to create the type of subform that I need, there has to ...
14
votes
1answer
17k 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
200 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
129 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 ...
3
votes
2answers
9k 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
2k 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
257 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
698 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
233 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
1k 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
289 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
74 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
74 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
184 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
4k 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
180 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
2k 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
2k 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
174 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
9k 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
67 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
131 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
32 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
91 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
402 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
210 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] ...
2
votes
1answer
1k 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
1answer
99 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
7k 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
300 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 ...