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)

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
132 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] ...
1
vote
1answer
500 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
215 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
179 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
281 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
391 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 ...
2
votes
2answers
577 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
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
828 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
5k 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 ...
4
votes
4answers
5k views

Why is my column not shown under “Add a column to show each of these additional fields”?

In SP2010, I want to get 2 columns from another list and merge these columns. But when I am trying to do this via Lookup, they are not shown under "Add a column to show each of these additional ...
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
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 ...
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
674 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
324 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
199 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
431 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
259 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 ...
5
votes
3answers
906 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
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.
2
votes
3answers
778 views

Sharepoint2010 Lists Lookup

I'm creating 3 lists using Sharepoint 2010 UI. The lists and relationship are as follows: Training (parent) -> Training Instance (child, look up Training ) -> Training Session (grandchild,lookup ...
2
votes
1answer
811 views

REST: unable to retrieve lookup data from top level

At the top level of my site collection, I have created a list called "Markets", and a site column called "Market", defined as a lookup to the Markets list. In a subsite of this same site collection, ...
0
votes
2answers
551 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
681 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 ...
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 ...
0
votes
1answer
224 views

Setting a Lookupfield for current Item in List

my use-case: I'm trying to implement an event-management system to sharepoint using visual web part(s). I have two custom lists, one is called "events". Let's say it has a column "Title" which shows ...
1
vote
1answer
340 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); ...
1
vote
2answers
64 views

Library item “referencing” other content

Sorry for the nondescript title, it's a little hard to explain concisely. We are setting up SharePoint 2010 to act as a simple document management system, to store documents such as forms, ...
1
vote
0answers
246 views

How to copy Assigned to field from list A to List B on creation of item in List B?

Trying to solve a problem with moving data from one list to another. I have 2 lists. 1) a project list that contains Project info (project ID which is text, name, lots of details, and an "Assigned ...
1
vote
1answer
540 views

send email from workflow based on loopkup column

I have a workflow in visual studio and I need to send an email to a domain user whose name is entered into a sharepoint Person or Group lookup. The value will not be in a sharepoint group, it is from ...
0
votes
2answers
678 views

How to add a from lookup field value to the text

I think about how to add a from lookup value to the text ? How can I write it to another colum ? In the same list.
1
vote
0answers
213 views

How to get Dependant LookUp Column Values in Sharepoint 2010

I am trying to get the Dependant Lookup column values in sharepoint 2010 but unable to get the value so how can we read the values from Dependant LookUp Column. thanks in advance
1
vote
0answers
115 views

Related Item View - refered from child list

I'm working on a 2010 site at the moment and is asked to display all images to a news item (custom list). The problem is that the news don't have any reference to the Picture library, instead the ...
1
vote
0answers
106 views

Getting Error Access Denied when creating Filtered Lookup in SP2007 List

Using WSS SP2007 as a site curator. List A is a new list. List B is a resource list with a view showing active Project Managers. When I go to create a filtered lookup column in List A I immediately ...
1
vote
0answers
160 views

Displaying text in a Look-up column

Apologies for not being clear. I'm try to display a "multiple lines of text" column as a look-up field in a new view of the parent list. I have tried SP Designer and most of the standard webparts. ...
1
vote
0answers
159 views

Change column type from “Lookup (information already on this site)” to Person or Group

I have an issue after migration SharePoint 2007 to 2010. We had “Person or Group” which now somehow has transformed to “Lookup (information already on this site)”. This creates lots of troubles for ...