A lookup column is a SharePoint list column that retrieves its available values from another list in the SharePoint site.
12
votes
1answer
680 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 ...
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
1answer
482 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 ...
2
votes
1answer
509 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 ...
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 ...
1
vote
0answers
36 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
40 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 ...
1
vote
0answers
136 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 ...
1
vote
0answers
133 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 ...
1
vote
0answers
81 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
0answers
112 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 ...
1
vote
0answers
170 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
0answers
150 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
84 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
56 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
134 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
94 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 ...
1
vote
0answers
233 views
Get value automatically similar to Excel's vlookup function
I want to get data from another list automatically based on a column from this list. Let's say the source list shows the ID A, B, C and the related values 1, 2, 3. In my list I show in a column one of ...
1
vote
0answers
76 views
Getting user's AD groups as lookup
I'm trying to make a simple reservation site, containing two lists: resources and reservations. Users are making reservations by creating a new item on Reservations list, specifying which resource ...
1
vote
0answers
435 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 ...
1
vote
0answers
85 views
Best way to create a list with hidden columns with Data pulling from InfoPath form
So I have been working on this for a little bit here is what I am trying to accomplish:
Using OOTB SharePoint 2010 Functionality I want to create an HR Referral System. Basically an InfoPath Form ...
1
vote
0answers
297 views
How do I create a lookup field for a hyperlink field and display the URL?
Ok, so there are a zillion posts related to and circling around this question, but that do not actually answer it to my satisfaction.
I have a regular, out of the box, list of type "Links". I have ...
1
vote
0answers
170 views
How to get lookup field text column to display as an image in a view?
Wonder if anyone can help. I want to add a category choice field to a SP2010 Announcements list. The category choice is a lookup field to another list. The other list contains the categories and a ...
1
vote
0answers
266 views
CAML Contains on a lookup field of a calculated column
I have some issue when using the CAML Contains statement when the field is a lookup field on a calculated column.
It basically does not work, the Equal works though.
here is the query, nothing ...
1
vote
0answers
860 views
set multiselect lookup column using jquery
I have a Multi select Look up column which as you all know is a control with two list boxes and "Add or Remove" Buttons.
The user populates the right-hand side of the control with some values by ...
1
vote
0answers
68 views
Lookup columns into document template
I've a DocLib with the lookup field Field01 and I want to display the associated lookup columns as Field01:FieldA, Field01:FieldB...
I already have them on the view, now I want the exact same ...
1
vote
0answers
100 views
How do I create a linked keyword index?
We have a 2000-document library that we use as a knowledge base. We're trying to create a hyperlinked index of keywords. In this simplified example, consider the following metadata for a document ...
1
vote
0answers
199 views
Content Organizer rule based on a Lookup Column with more than 20 selectable values
Does anybody have any experience making content organizer rule based on a Lookup column with more than 20 values in the list? (When you have more than 20 values, the view of the Lookup field changes. ...
1
vote
0answers
223 views
How to take a value from a single line of text field in one list and set it as a lookup field in another list?
I have SP 2010 and SPD 2010.
I have list A that has a single line of text column named Res ID #. This provides the source for List B as a lookup column. I want to create a WF that will put the info ...
1
vote
0answers
158 views
My custom form isn't saving lookup fields
I have a list with two content types. I've created two custom forms for creating new items (because one field I don't want until the 'edit' form). One works great. The other one doesn't. What's ...
1
vote
0answers
945 views
Inserting new item in list with EntityRef field to User Information List using Linq to SharePoint
I have a list with SPFieldUser field type in it. I try to insert new item in this list using Linq 2 SP.
So, I generated data context class using the following configuration file:
<List Name="User ...
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
10 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
8 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 ...
0
votes
0answers
42 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 ...
0
votes
0answers
36 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
0answers
44 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
0answers
15 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
0answers
31 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
0answers
87 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
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 ...
0
votes
0answers
25 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
19 views
Why Does a People Field Return a String by Default?
I recently "cleaned up" a chunk of code that was using SPFieldLookupValues like:
SPFieldLookupValue lookup = new SPFieldLookUpValue(listItem["Field"].ToString());
int itemID = lookup.LookupId;
string ...
0
votes
0answers
64 views
multiple column lists and lookup controls
I've created a List that has two columns a title (MyTitle) and a value (MyTitle), in my page I have a Lookup SharePoint Web Control that is currently just displaying the title, how can I set the ...
0
votes
0answers
174 views
Calculated field to split URL and update a list field
I wonder if you can help. Im wanting to find a way of storing the Parent Item within a child item entry. After doing some research ive been told that the only way this can be done is by the URL link ...
0
votes
0answers
199 views
“Linked Item” Lookup available in browser by not SPD2010?
When I create a Lookup site column in the Browser, this enables me to choose "linked to item"...which then means it pulls back all the related information.
However, if I do the same in SPD 2010, ...
0
votes
0answers
172 views
List validation using additional lookup column
Here's what I'm trying to do: In our company we have some bookable resources, like laptops and lab machines. All of them can be booked to work on one of our projects created by project leaders. While ...
0
votes
0answers
216 views
Bug in SharePoint 2010 Lookup Columns in parent Site
I think i found a bug in SharePoint 2010 + Visual Studio 2010, and it is simple to simulate. I Created a lookup column in a parent site with the following CAML:
<Field ...
0
votes
0answers
410 views
Lookup multiple-values on form-library sharepoint 2010 for InfoPath Form
I use InfoPath form template for a form library without coding. I want to get multiple-value of lookup to another list items. For lookup I should use sharepoint 2010 column due to no such data type in ...
0
votes
0answers
122 views
How to retain permissions for a user in Lookup field?
I have column level permission using a custom code. But I am unable to retain permissions for a user in Lookup field! Is there a way to do it?
