A lookup column is a SharePoint list column that retrieves its available values from another list in the SharePoint site.
12
votes
1answer
686 views
When deploying a site from custom site template, one lookup column in doclib has empty values for Office 2010 (docx, xlsx, pptx) files
I'm deploying sites using a custom site template (WSP) that is:
Saved as WSP from customized Team Site
Deployed as Farm Solution
Has lists, libraries with content customized in Visual Studio ...
7
votes
1answer
5k 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 ...
7
votes
3answers
1k views
Multiple Lookup field , how to return better deliminators using object model?
I have a multiple lookup field, and when I do this:
string myValue = oItem["MyLookupField"];
I get this string back:
[id];#[displayText];#[id];#[displayText]
or a real example:
"5;#C3;#15;#P3"
...
6
votes
1answer
286 views
How to Combine IN-Opeator with LookupIds in a caml-query?
I want to build a CAML - Query using the IN - Tag. The queried Column is a lookup-field to a Title of another list. When I query using the text-property everything works fine:
<Where>
...
6
votes
3answers
3k views
How to get the ID of the list item just inserted using ecmascript
I am stuck at a place where I have to update a list which has a Lookup column. For example I am using this code to update my normal list
var clientContext = SP.ClientContext.get_current();
...
5
votes
2answers
121 views
Strategy Queston : how would you implement this calendaring use-case
At my organization there is a process that goes in to preparing for our Board of Director's Meetings that begins 6 weeks beforehand and involves about 9 different steps. We have a template document ...
4
votes
1answer
1k views
dropdown box on change event in SharePoint list forms
I am editing an SharePoint list form using SharePoint Designer. I need to have two drop down boxes one with the names of the countries and other with the names of appropriate state. How can I ...
4
votes
1answer
305 views
Lookup to list with permissions
i'm trying to achieve something that i'm not sure if it's possible or not.
I have a News system that uses multiple lists, permissions etc.
The permissions exist because only 1 person is able ...
4
votes
3answers
593 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, ...
3
votes
4answers
2k 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 ...
3
votes
4answers
10k views
How to set ListItem Lookup Field value
How do I set a ListItem's Lookup field using code?
SPFile file = list.RootFolder.Files.Add(destUrl, iStream, true);
SPListItem item = file.Item;
item["DocumentID"] = DocID.ToString();
...
3
votes
2answers
3k views
How to get lookup value only via REST (listdata.svc)
I am trying to retrieve a list of items including lookup fields via listdata.svc. My lookup points to a list of companies which has the following fields: Title, Address, Phone.
By default, listdata ...
3
votes
3answers
1k views
GridView lookups displaying as “id;#value”
I am using an ASP.net gridview. The datasource is SPList.Items.GetDataTable().
The gridview is working fine; however, lookup and multilookup columns display as "id;#value". Is there any way to just ...
3
votes
2answers
635 views
Migration tool for specific lists
I am looking for a migration tool that works at the list level, not for a full site or server.
One specific requirement is to be able to migrate lists that are connected via lookups.
For example, if ...
3
votes
2answers
493 views
Deactivate the link of lookup-fields! (2010)
On our solution (SP Foundation) we multiple lists with quite some lookup fields. Some of the lookup fields are user fields who link to the user info list, and we don't want that to happen.
Of ...
3
votes
1answer
656 views
Client Object Model - Update Document Library Metadata - Lookup Field with no required value
I am attempting to update metadata for documents in a document library (or List) using the client object model. I have whittled down a number of the error messages I was getting and now I am hitting ...
3
votes
2answers
2k views
Client OM - setting lookup fails
I'm using client object model to migrate data from some external data source. The problem is that when I set lookup (normal list or user) I get:
Value does not fall within the expected range.
I set ...
3
votes
3answers
811 views
Export Import Library with Lookup column
I did export operation of custom library in Central Administration. Library has some custom fields and Lookup field on existing library on the site.
After exporting main library and all dependecie ...
3
votes
1answer
436 views
AddLookup using the client object model?
Trying (desperately) to find the Microsoft.Sharepoint.Client equivalent of
SPList.Fields.Addlookup
My code:
ClientContext ctx = new ClientContext("http://sharepoint/");
Web website = ctx.Web;
...
3
votes
1answer
1k views
Can you have lookup column to rich text field
Can a SharePoint 2010 lookup column point to a multi-line rich text field in another list? From what I'm reading, it can only see single-line text fields in the other list, which limits its use in our ...
3
votes
2answers
2k 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 ...
3
votes
2answers
2k 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
1answer
292 views
Set a date/lookup in ListInstance elements.xml
I have two lists. The first one has customers and the second one has Orders. Now i want to add some (test) data in the elements.xml of the listinstances. For customers this works without a problem
...
3
votes
1answer
367 views
How can we use multiple fields from an external list in a survey?
We are trying to build a survey, that uses data from an external list.
It works fine for a single field.
But what we would like to do is to bring about 10 fields back from the external system and ...
2
votes
2answers
3k views
How to retrieve lookup values using ClientContext?
What's the best way to retrieve lookup values using ClientContext? I'm accessing a list using ClientContext (let's call it ParentList). That list contains several lookup fields (let's call one of them ...
2
votes
2answers
359 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 ...
2
votes
3answers
651 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
2answers
619 views
Create Site Column (lookup type)
Is there any solid (proven) method of creating Site columns (lookups) where list GUID is not known?
I think this is where feature activation kicks in; getting the lookup list by its name and then ...
2
votes
3answers
262 views
How best to handle metadata lookup?
I have a query regarding how I should best handle uploading documents into SharePoint (currently WSS) where the Taxonomy asks for client code for all documents. The problem I have is that we have say ...
2
votes
2answers
330 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
201 views
Lookup List and return data from within a Form
OK, I'm beginning to despair at SharePoint...please help restore some faith :)
Seems some very basic things are very hard to achieve?
1:
I have data in an SQL database table. 78,000 rows, but I want ...
2
votes
1answer
806 views
Maximum allowed values in a single sharepoint lookup column/ sharepoint list update
I am facing problem with my custom developed webpart which inserts data into a sharepoint list using excel sheet. I have a list with around 50+ columns in it, it has 10+ lookup columns in it, things ...
2
votes
2answers
234 views
Assign lookup list item with a quantity?
Parent List has a lookup with multiple promotional items. Once user chooses a promotional item, I want user to be able to add a quantity to that specific item. User should be able to select Multiple ...
2
votes
3answers
447 views
Department lookup from User Profiles - SharePoint 2007
We have some 30,000 user profiles . We'd like to build a custom list with lookup for Department from a unique list of departments in our User profiles.
Possible?
Was thinking of buildin a new ...
2
votes
3answers
2k views
Can someone provide examples and direction with relational list?
I'm trying to figure out the best course of action concerning relational lists. I have create several parent and child related lists but I'm having a bit of trouble understanding how to build my CAML ...
2
votes
2answers
2k views
How to automatically link parent in child list new form?
I would have thought this would be something I could find easily with a search, but not so far.
I have a parent/child relationship between two lists using a lookup column in the child. I have added ...
2
votes
2answers
372 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 ...
2
votes
1answer
205 views
How to improve performance of lists with multi-lookups
I have a list that includes several lookup fields. Some of these are simple lookups (only one value allowed), others are multi-lookups (the "allow multiple values" checkbox is selected).
I have ...
2
votes
2answers
286 views
Chart Web Part and lookup fields
How can I make my Chart Web Part look good when I use it with lookup fields?
The issue I have is that the chart displays the field id along with its value. For example, it displays "2;#Bing" when I'd ...
2
votes
1answer
963 views
Validate a date column against a lookupfields additional column
In a list you can create a lookup column which queries data from an other list, the fun part is that you can add "additional columns" which results in some sort of ghost column which is added to the ...
2
votes
2answers
683 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 ...
2
votes
1answer
134 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 ...
2
votes
1answer
344 views
Managed metadata vs lookup for column
I have a property content type. I'm wanting to add a property code column which will look up the codes from somewhere else on a SharePoint Online site, where it can easily be managed by end users.
I ...
2
votes
1answer
353 views
REST API Filter by multilookup property
Having an Activities list with a column called Engineer of type lookup that allow multiple values. How to build a call to listdata.svc in order to get only activities that are asigned to an Engineer ...
2
votes
2answers
1k views
Maximum lookup columns - the magic number 13
So I did create on an SPWeb 20 custom lists and then a tasks list.
For each of those 20 lists I've created 20 site lookup columns. I then created 20 Content Types based on Task content type. Then I've ...
2
votes
1answer
33 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 ...
2
votes
1answer
374 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 ...
2
votes
1answer
327 views
How to update metadata?
I have following code (didn't list the whole code) behind a button on a InfoPath Managed Form. and it works meaning I can submit data to a list. Now I have 2 controls on the form that is ...
2
votes
0answers
236 views
Multivalue and single value lookup issue
Let's assume that we have two lists - Foo which has some kind of information - no matter what, and second - Cities - which holds city names.
Now, we set up on Foo list lookup field to City list and ...
2
votes
1answer
484 views
How to create a lookup field that has a list column picker
How would I be able to create a list field in VS that would be a lookup to select columns from any list?
I would preferably like to have something like the PickerTreeView.aspx, but instead of ...
