A lookup column is a SharePoint list column that retrieves its available values from another list in the SharePoint site.
1
vote
1answer
413 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
233 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
152 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
86 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 ...
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 ...
1
vote
0answers
57 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
97 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
1answer
247 views
Format List look-up column as text-only in data-view web part
I have a list that contains a lookup column.
Next, I created an empty .aspx page and added a dataview web part. Next, I linked the dataview web part to the previously mentioned list, which gave me ...
1
vote
1answer
100 views
How do I add a user column to a custom list?
I have created a custom list programatically. I want to add a field to it call User, this should be a lookup to the system Users. This will be like the default CreatedBy field.
How would I do this?
0
votes
2answers
94 views
Lookup between lists with additional data
I have two entities, Toolbox and Tool, where Toolbox contains a set of tools (hammer, saw, screwdriver).
The trick is that there can be several hammers in the same toolbox, so I need an amount, or ...
1
vote
1answer
576 views
Set value in a lookup column during “Create List Item” workflow action
Here's the scenario, using SharePoint Designer 2007 and two simple lists in MOSS SP2:
I create items in a list called "Code Snippets" with columns Title, Code and Author's CustID
I track how many ...
0
votes
1answer
59 views
Using a lookup to set the To: address on a sharepoint designer 2010 workflow email action
I have a sharepoint designer 2010 workflow with a email action. I want to set the value for the To: address to a field of the Current Item using a lookup ( [%Current Item:Vendor Contact%]. ...
0
votes
1answer
2k views
Problem with Sharepoint ContentTypeBinding and Lookup field
I have a problem with ContentTypeBinding when creating a new site. I have custom site template definition where I have referenced Publishing Server Feature, so list Pages is automatically created on ...
3
votes
1answer
293 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
...
0
votes
1answer
144 views
How can I create column in list which it able to change data (lookup column) in next column?
How can I create column in list which it able to change data (lookup column) in next column?
For example: I have three lists with datas(names, numbers and adress) and I have other list with two ...
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
1answer
346 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 ...
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>
...
3
votes
1answer
657 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 ...
1
vote
0answers
236 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 ...
0
votes
2answers
34 views
Find a field by its name in a Library
So I'm having an error:
The field "Document_x0020_Type" contains a lookup to list
"{D2589081-9361-4393-996B-7C156C7B8F5A}" that cannot be resolved. The
target list may not be part of this ...
1
vote
2answers
1k views
Lists with lookup columns aren't saving - read only?
I've got several list which have lookup fields, and I can't add new items to any of them. Every time I've clicked save, I get this error:
"Invalid data has been used to update the list item. The ...
1
vote
1answer
485 views
Lookup column of type “User” showing #ERR
I've defined two list definitions and instances in a feature in VS2010.
One list only contains a required field "Employee" which is of type User.
The second list has two fields, a simple text field ...
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 ...
0
votes
1answer
59 views
Pro grammatically adding choice field with another field relation
sorry about the title am not sure how i should name it.
I want to be able to create two columns for a list that have a division - subdivision relation.
If in the first field if i choose People the ...
0
votes
1answer
183 views
How can I make a filtered lookup view that doesn't remove the value in it as I delete items from the lookup list
I have a list of Projects. As they are completed I want to delete the item (or tag it as completed). The Project Library looks up "Project Name" from the list of Projects (so that it is easy to find ...
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 ...
0
votes
1answer
336 views
List as a look up value from another site
I would like to use a list from one site as a look up for another site. Can I do this with out using code. Only use OOTB or Designer? Or is there a better way?
0
votes
1answer
102 views
Multiple LookupField?
I have a couple of problems that i would need help with.
I need to create a list that has a lookup to multiple lists. Is there a way to do this without including third party.
I have a site, with a ...
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 ...
1
vote
2answers
570 views
lookup between two lists programmatically
i have two lists. the first list name is "cases" and the second list name is "issues".
in the cases list i have a text column that holds a case number. in the issues list i have lookup column name ...
0
votes
2answers
652 views
Defining Lookup Fields in CAML that pulls multiple fields
We have defined a number of lookup fields like so:
<Field ID="{81A578F2-8022-4083-8683-7F9BF039C82A}"
Name="NameLookup"
DisplayName="Navn"
...
2
votes
2answers
202 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 ...
1
vote
1answer
661 views
Conditional Sum of Data in Another List
I have two lists 'Projects' and 'Tasks' where 'Tasks' are associated with 'Projects' with a lookup column.
On the Projects list I would like to display the sum of all of the 'Actual Time' values (a ...
1
vote
1answer
80 views
Create a lookup column in a list to reference a column in a list on another site (SharePoint 2007)
Is this possible with an OOB solution:
I have list A on Site A and List B on Site B (site B is NOT a subsite of site A). There is a column in list A on Site A that I need to use in list B on site B. ...
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, ...
1
vote
2answers
386 views
A “throttling” exception for a lookup field
I have a large list (with item count > 5000) with invoice positions, which I want to be filtered by a lookup field (invoice header ID).
I tried to filter the list extending the URL, i.e.: ...
1
vote
1answer
284 views
Clear Multiselect Lookup
I am trying to add a button for my users to clear a multiselect lookup value using JQuery or Javascript.
I have found some information about setting a default value on a single select lookup, but ...
0
votes
1answer
235 views
Change the source on a lookup column?
Is it possible to change the data source on a lookup column?
I have the source set to list A but I want to change it to List B.
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
299 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 ...
0
votes
1answer
37 views
Is a list being used as a lookup for some web part in the site collection?
We're cleaning up our MOSS site collection in preparation for the migration to SP2010. As we work on the top root site of our site collection, we realize that some of these lists (often with invalid ...
0
votes
2answers
764 views
Retrieving a lookup Value from a List using jquery and REST
I would like to get the lookup Value from a List item depending on it's Title.
My List is set up similar to the following example:
ColumnA : a | b | c
lookupB : 1 | 1 | 2
The jquery:
function ...
1
vote
1answer
335 views
Can't delete List item after setting lookup deletion to restricted
I have a List Item and I wanted to delete it. It's nothing special at all, but it fails.
I have two lists, Company and Company Contacts. Each Company have 0...n contacts. A company can't be deleted ...
1
vote
1answer
156 views
Document library forces check-in upon adding custom lookup column
SharePoint 2007 Team Site
Add a Document Library with the Word 2003 template
Add a new item, save, close document, no problems
Add a (required) custom lookup field to the document library
Add a new ...
2
votes
3answers
178 views
Managing multiple related lists and lookups in SharePoint 2007
I have a custom solution, which has multiple related lists. Four of the Lists have a lookup field based on the field of one list. And, that list has a lookup based on the field of another list.
So, ...
1
vote
1answer
60 views
I need to have the data from a list in another site at the same level to be available as a lookup in sharepoint 2010
I have a parent team site (Services) that contains multiple sub sites.
One of the sub Teamsites is Call Inventory Containing our Stock List.
Another Teamsite is called Purchasing containing a purchase ...
1
vote
2answers
442 views
Simple SPQuery throws error
I am trying to pull populate a lookup field using a lookup value without the lookup ID. I am getting the error: "One or more field types are not installed properly. Go to the list settings page to ...
0
votes
2answers
167 views
How Can I create simple database in list Sharepoint Fundation?
How I can create simple database for example vacation request in SP list? It will looks like that: I create probably two list. In first list is vacation days people and on the second list is vacation ...
