A lookup column is a SharePoint list column that retrieves its available values from another list in the SharePoint site.
2
votes
1answer
510 views
In a DVWP my Multilookup column is not returning IDs, only column values
I've added a DVWP to a page. The DVWP shows data from a list with a multi value lookup column.
The value returned for this column is in the form: value1;value2;value3.
Now I want to render this ...
0
votes
1answer
10 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 ...
1
vote
1answer
445 views
content query web part with multi value lookup column
I am trying to work out how I can query a content type with a multi value lookup field using the content query web part.
I know that natively this is not possible with ootb sharepoint 2010 however I ...
0
votes
1answer
373 views
Why is the associated lookup field not on the dispform.aspx?
I have three lists:
Events (calendar)
Customer1 (custom list from scratch)
Customer2 (custom list from template)
When I added the lookup of Customer1's ID and added the associated field "Title," ...
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 ...
1
vote
1answer
562 views
BDC List column picker filter - search/filter not working and exact entry says not found?
I'm working with MOSS 2007.
Rephrasing the question. I have a BDC column to an external datasource in a custom list. Today searching and filtering is not in place and actually exact matches are not ...
1
vote
1answer
463 views
Why does SPMetal ignore lookup columns in Farm Solution
I have content types and related lists (via lookup columns) in a Sandbox solution(wsp). All my lookup column relationships come up fine in the SPMetal generated entity classes.
I now have a ...
0
votes
1answer
16 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
48 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 ...
0
votes
1answer
19 views
Retrieve reference for list from Lookupfield
I have a sharepoint 2007 and in a document library eventhandler: in ItemUpdating, i would like to be able to retrieve the value by id's from lookupfield. So with other words i have to get the ...
1
vote
1answer
22 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
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 ...
0
votes
0answers
14 views
Retrieving the SPLookupFieldCollection with particular ID's
The situation is following:
I have this kind of string = 58;#value;#59;#value2;#60;#value3;....
So as you see this is just if i do:
SPFieldLookupValueCollection collection= new ...
0
votes
0answers
11 views
not all columns appearing in edit in datasheet
I have a customized work order view with the following fields:
ID#, Title, Assigned To, Client, Status, Priority, Due Date, +8 other fields
When I got to Edit in Datasheet, the Client field doesn't ...
0
votes
0answers
9 views
Disable lookup item link
I am looking for how to disable a link of lookup field i.e. when a user clicks on lookup item of source list it opens Target list instead of opening source list even though he was selecting an item ...
1
vote
2answers
346 views
Invalid Look up Value . A look up field contains invalid data
I have a multi select Lookup column . I have to populate values to the lookup column from another column on a button click. I achieved it using below code but when i try to click ok/save it is ...
1
vote
1answer
769 views
Copy lookup value from one list to another with SPD workflow
I have two lists and a workflow that copies items from list A, if they get approved, to list B.
Problem is that a field in list A uses a lookup list, if I select Dog in the Field Animal and save the ...
12
votes
1answer
683 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 ...
1
vote
1answer
428 views
set or update multiple values cascading lookup field using client object model
I'm struggling since a couple of weeks with setting a multiple values cascading lookup field using a client object model,
I could set the first value but then It show me an error of invalid lookup ...
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 ...
1
vote
1answer
1k 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?
...
2
votes
3answers
472 views
Binding lookup fields to document library template
I have features that define site content types and a document library template that uses these content types. Now, when I create a document library from the template, all the content types appear ...
0
votes
0answers
44 views
SharePoint Online - Use Site Column Lookup Value In Workflow
I am trying to generate a unique ID for items in a document library based on values from other fields. I have several lists located at the root of my site, and have created lookup site columns for ...
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 ...
0
votes
1answer
511 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 ...
1
vote
2answers
44 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
155 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
0answers
38 views
List view group by Lookup field only grouping by string value of Lookup, ignoring ID part
I have custom lookup field of my custom list definition:
<Field Name="MyLink"...Type="Lookup" Mult="FALSE" ShowField="Title"../>
Then I have list view in SharePoint Foundation 2010, created ...
0
votes
1answer
423 views
Extending Content Types from Content Type Hub
I have defined a content type in content type hub. I would like to use this content type on a site (other than the hub) but also to extend it with an additional (lookup) column. Is it possible to do ...
0
votes
1answer
352 views
Is it possible in LINQ to SharePoint
I have a task to make a WSP, which should provide definitions of custom list and library, but not instances. List definition has a lookup column to library item
<Field ...
0
votes
1answer
33 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
46 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
477 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
1answer
406 views
Document Information Panel contacted a data source but failed to receive data. The form will load without the requested data
The query cannot be run for the following DataObject: list_48985ACC-FDDD-4732-AA48-078CFE123F35
Document Information Panel cannot run the specified query.
The SOAP response indicates that an error ...
0
votes
1answer
345 views
Modifying XSL for multi lookup field
I'm trying to create custom XSLT for a multi lookup field, based on this article.
When changing disable-output-escaping to yes I can see the html I want to modyify:
<a ...
1
vote
0answers
38 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
43 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
0answers
48 views
Creating Word document with tables from template
I found this blogpost about automatically creating Word documents from a list item using workflows in SP2010.
...
0
votes
1answer
29 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
0answers
18 views
Access additional user information column keyed by “Created By” in SPD workflow
In SharePoint Foundation 2013, I would like to create a SPD list workflow that takes different action based on the value of a custom column in the User Information List (keyed by who created the list ...
0
votes
1answer
22 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
38 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
0answers
34 views
Grouping in lookup multi
I have Lookup field in the list, with multiple choice. On NewForm I have JS code which groups items in 2 listboxes of this field (SelectCandidate and SelectResult).
Problem: I need to group items ...
0
votes
1answer
38 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
260 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
0answers
91 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
57 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 ...
0
votes
0answers
121 views
Use JS to add new list item with lookup where multiple items in lookup list have same title
I'm trying to add a new ListItem using the client object model.
Scenario:
List I am adding to has Title, Team (lookup) and Date fields.
The list that contains the teams has Team Name, Department and ...
2
votes
2answers
355 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
104 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 ...
