A lookup column is a SharePoint list column that retrieves its available values from another list in the SharePoint site.
12
votes
1answer
670 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
275 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
119 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
301 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
588 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
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
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
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
610 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
481 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 ...
