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
7k 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
0answers
63 views

How to send email to a user referenced in a top-level lookup table in SPD workflow?

SharePoint 2010: I got a SharePoint Designer workflow attached to a custom list [A]. [A] has a lookup field [L] to a top-level (site collection root) list [B] which has a column of type "Person or ...
0
votes
1answer
34 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
0answers
60 views

Cusstom MultiLookup column

Im trying to create a custom field type of multilookup type to show lookup values of one particular content type, So I'm creating a customcontrol which extends the "MultipleLookupField" class. I ...
0
votes
1answer
242 views

linq query for lookup list column error - query uses unsupported elements

I'm trying to return the list item ID (s.ID), and the ID of a lookup column (s.VendorID). I get the following error: The query uses unsupported elements, such as references to more than one list, ...
0
votes
3answers
94 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; ...
0
votes
1answer
164 views

Help with SPCascadeDropdowns cascading lookup column

I have this jquery added to my editform.aspx in SharePoint. I want the childcolumn to also have unique values, although it may contain duplicates example below. Example. When I select mycountry, I ...
0
votes
0answers
69 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
0answers
249 views

2010 Workflow vs 2013 Workflow - Lookup columns

I tried to make a 2013 workflow and ran into exactly this issue: SharePoint 2013 Workflows List does not exist error Well, as a workarround I tried to make a 2010 workflow and noticed this: Why ...
1
vote
1answer
295 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
230 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
42 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
0answers
18 views

Can I configure Min/Max properties to be formula/lookup based?

I have a List with a lookup value and I'd like to configure the min/max properties on another column to be based on that lookup: <Field Name="ParameterName" ...
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
0answers
153 views

There was An error copying data to a SharePoint list. Cannot update 'Experience Code Lookup'; field not updateable

First, let me say that I am new to Access and especially to Sharepoint. I have made a very simple Access web database that I would like to put on Sharepoint. It has two tables. One table has an ...
0
votes
2answers
290 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 ...
0
votes
1answer
568 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 ...
0
votes
0answers
189 views

Setting value of a Sharepoint lookup column with more than 20 items

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 ...
3
votes
3answers
317 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
83 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
52 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
81 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
192 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, ...
2
votes
1answer
2k 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
461 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
0answers
15 views

Sever Lookup Column Connectivity to Source List

I have a Custom "List A" with a [Lookup Column] to another "Support List". I need a way for the selected value in List A to become “frozen”, or not able to be changed if the value in the Support ...
0
votes
0answers
85 views

Multi-select lookup column displaying as textbox in DIP

I am bringing up a knowledge base solution for a support team, and I am trying to allow the owners of these documents to maintain their documents' metadata through the DIP in word. One of my fields ...
0
votes
2answers
258 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 ...
0
votes
0answers
23 views

XML Code equivalent of “Add a column to show each of these additional fields” [duplicate]

I have the following XML to create a site column: <Field Type="Lookup" Name="FunctionalArea" DisplayName="Functional Area" Group="GROUP1" Required="FALSE" ...
5
votes
2answers
4k 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 ...
2
votes
2answers
3k 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
0answers
52 views

Deleting columns in Sharepoint still existing

I deleted three columns in Sharepoint Designer (by clicking "Delete") as well as a list workflow in order to decrease the number of lookup columns in the list. The columns seem to have been deleted ...
0
votes
0answers
56 views

Autopopulate a list column to show all documents associated with that list?

I have a document library named Documents. Each document has a column named feature which is a lookup of a list named "Features." When a new document is created, the user must select the feature ...
0
votes
0answers
43 views

Issue List RAG Rating for in/out of date

I have created an Issue List on SharePoint. One of the many columns is 'Raised On' in which the user will in put via Calender the date in which their issue is being Raised On, Example 17th July 2013. ...
0
votes
0answers
22 views

Add data programatically to a lookup column which references values from another list [duplicate]

I have a list which references a couple of other lists for lookup values. When I try to programatially insert data to that list it gives me the following error: Invalid data has been used to update ...
0
votes
1answer
97 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
0answers
52 views

DVWP Store and Display a specific list item version

Here is an interesting one that I have never tried to do before, hopefully someone has. I have 2 lists: - List A - List B List B contains a lookup column to List A. It is likely that items in ...
0
votes
0answers
91 views

Reference SharePoint in Access Lookup Field

I am trying to reference a SharePoint list from an Access table. I have linked the list in SharePoint, but when I try to create a lookup column in my Access table, the list is not shown in the lookup ...
0
votes
1answer
119 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 ...
11
votes
1answer
9k 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
0answers
42 views

mailto link not applying to lookup column?

I have a Custom List that I use to store vendor contact information (Names, emails, etc). I want to use some of that list data in a Document Library (same site collection). I setup a lookup column ...
0
votes
0answers
227 views

Unable to remove link to Lookup field in default DispForm

Here's the deal : I have a list, with several fields, including a Lookup and a LookupMulti fields. I display the items of the list in a Calendar View. Everything works fine. When I double-click on an ...
0
votes
1answer
79 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
71 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
854 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 ...
1
vote
2answers
3k 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
709 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
110 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
278 views

Clear all values in a multi-value lookup, via REST, SP 2010

Conditions: SP 2010, html/javascript, using REST to read/write to various lists. Im using a jquery multiselect plugin to set a multi-value lookup column. I need the selecting Groups of items, easy ...
0
votes
1answer
376 views

Change size of Multilookup field

I have a multi lookup just like this image, with 2 listboxes and Add and Remove buttons: ...