A lookup column is a SharePoint list column that retrieves its available values from another list in the SharePoint site.
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 ...
1
vote
1answer
451 views
Lookup with a custom field type as target
I want to create a lookup field with the sharepoint ui which points to a field with a custom field type (parent field type is number). In visual studio with the object model this is not a problem but ...
0
votes
1answer
737 views
SPLookUpField and Adding Values
I am creating a custom list programmatically. List has one Lookup field. Here is my code sample how I am creating LookUp field.
oList.Fields.AddLookup("Parent", oListGuid, false);
...
0
votes
1answer
3k views
How do I update a lookup column from a dropdownlist?
I'm creating a custom web part in asp.net for SharePoint 2010 programmatically. When a user presses an Add button, the selected item from the dropdownlist is supposed to then be added to the Groups ...
0
votes
1answer
185 views
How to use the Links list item as target column for a lookup field in SharePoint?
I have created a Links list in my SharePoint 2010 site. Also, I have created a default document library. Now I want to create a new column in the document library; the column should be a multiple ...
1
vote
2answers
103 views
Document look-up of PDFs
I have a look-up to the Documents list on the Title column, containing a mixture of DOCX and PDF files.
The DOCX files appear in the drop-down, but the PDFs seem to be ignored. I can open the PDF ...
2
votes
1answer
809 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 ...
1
vote
2answers
1k views
Is it possible to have a lookup field with multiple source lists?
I have two lists: list A and list B. List A should have a new multiple choice lookup column that allows the user to choose items from both list A and list B. Is this even possible? I have a kind of ...
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 ...
0
votes
0answers
414 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 ...
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?
...
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 ...
3
votes
1answer
437 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;
...
1
vote
1answer
429 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 ...
0
votes
1answer
244 views
lookup external list
I have two tables:
Documents
Project task
What I am looking for is the following:
I have a page with project tasks in a hierarchy list (done)
Clicking on a task will open an edit screen (done)
...
0
votes
1answer
257 views
Copy data from Lookup field to Filtered Lookup
I'm migrating a list up a level from the site to the site collection. After migrating the list via list template, I need to move the data from the Lookup to the new Filtered lookup field on the same ...
0
votes
1answer
585 views
How to pre-fill the look-up column in a child list?
How to pre-fill the look-up column in a child list item based on the parent item, from whose form the child is being created?
Is this possible?
0
votes
1answer
516 views
Filtered lookup field
I would like to apply filtering to existing out-of-the-box lookup fields (without InfoPath).
The solution should be limited to GUI only: when Backup/Restoring to a clean farm the filtering would be ...
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 ...
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 ...
0
votes
0answers
123 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?
1
vote
1answer
4k views
How can I pass a Parameter via Query String to populate a lookup field on a New Item Form/DVWP?
I have two lists:
List A: Products
List B: Requirements
I'd like to have a nice Create Requirement page launched from the Product Listing page.
I have a DVWP/Multi-Item View displaying all ...
0
votes
3answers
3k views
Add values to lookupmulti field in c#
I want to add values to a lookupmulti field with c#. the form shows the field correctly but my code just won't work:
SPList list = SPContext.Current.Web.Lists["testlist"];
SPListItem item = ...
0
votes
1answer
547 views
Lookupfields not showing up in customlist sharepoint 2010
I have a custom list on dev-int environment, now I saved it as a template and moved it over to the dev-vm environment and created a list (Listl1) based on the template. Now this list consists of few ...
1
vote
0answers
201 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. ...
0
votes
1answer
5k views
Setting the value of a lookupfield(sharepoint dropdown formfield) in sharepoint 2010 list forms
How can i set the value of sharepoint form field dropdown box(lookupfield) in sharepoint list form when the form gets saved (using jquery)
note: the lookupfield (dropdown formfield renders as input if ...
1
vote
0answers
228 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 ...
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
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 ...
2
votes
1answer
511 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 ...
1
vote
1answer
72 views
NewListItemForm with pre-defined values from selected Entry inside form
i got two lists. One is called 'Projects' the other one 'Reports'. When i insert a new report i got the following fields
Associated Project: <LOOKUP FROM PROJECTS_TITLE>
Current StartDate: ...
2
votes
3answers
476 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 ...
1
vote
1answer
3k views
Using an Additional Lookup Column Value in a Calculated Column
I have a lookup column based on another list's description (a 'Category' list) and have ticked the other list's 'Category ID' column to be shown at the same time (I note that this is a manually ...
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 ...
0
votes
2answers
490 views
Trigger workflow email when item created
We have a list called employee details, which has client name as one of the columns which is of the type lookup (from another list name columns value). So when the users create a new item in the ...
1
vote
1answer
773 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 ...
2
votes
1answer
592 views
REST: unable to retrieve lookup data from top level
At the top level of my site collection, I have created a list called "Markets", and a site column called "Market", defined as a lookup to the Markets list.
In a subsite of this same site collection, ...
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 ...
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 ...
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 ...
1
vote
0answers
159 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 ...
3
votes
2answers
637 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 ...
1
vote
1answer
307 views
SharePoint 2010, InfoPath and top-level list lookup
We want to have some lists (Suppliers, Projects, etc) at top-site level which can be reached by all child-sites.
Using InfoPath on child-sites we want to have a lookup field in the lists there so we ...
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 ...
0
votes
3answers
3k views
Lookup column to Documents library
Here's what I need to do for a SharePoint 2010 list: Allow users to select the filename from a dropdown showing the items in the Documents library. But the "Add new item" form of the list doesn't show ...
0
votes
1answer
705 views
Set lookup field value in infopath form on new Item(List Infopath form)
I have lookup field called project stage, on item created I'd like to set to its default value,(project start). Then this field can only be changed by the Workflow as the project moves to the next ...
1
vote
2answers
2k views
Sharepoint 2010 and Infopath form : lookup fields are displayed by their ID instead of text value
I'm trying to build a custom Infopath form for a list that contains 2 fields that I would like to get auto-completed:
Person: people picker field, filled with the current user
Team: lookup to the ...
1
vote
1answer
202 views
Association between a custom list and an external list
I have a very basic question.
I have a Custom List and I'd like to add a lookup column from an External List based on a WCF Service. Is it possible?
E.g. I have employers in a custom list. I'd ...
0
votes
1answer
254 views
Output of SharePointWebControls:LookupField inside an <a> Tag?
I have a lookupfield which is containing an E-Mail Adress and want to have it inside an Tag.
How is this Possible?
Like:
<a href="mailto:<SharePointWebControls:LookupField ...
1
vote
2answers
633 views
Compare two person columns in a list
I have a list which has a "Person or Group" column called as Reviewer. I want to notify the reviewers whenever he/she is added to the list item.
I created a custom workflow which sends a mail on ...
