0
votes
2answers
79 views

How do I remove duplicates from a drop-down list?

I have a field in a list with the type drop down. It is supposed to show available countries which works. However, there are a lot of annoying duplicates of the same country. How do I remove them?
0
votes
2answers
24 views

How to merge multiple lookup fields?

My scenario in a nutshell: Theres a list which contains some food for example. (2010 Server) Foods ID Name 1 Apple 2 Banana 3 Carrot 4 Potato Theres another list which contain food ...
1
vote
2answers
36 views

How to get LookupValue in ItemUpdating

I have a custom EventHandler for ItemUpdating on a list which has a Lookup column. If I look in the properties.AfterProperties for the column in the ItemUpdating event I get the LookupId value but ...
0
votes
1answer
43 views

How Do I Format A SharePoint 2010 Search Refiner Lookup

In SharePoint 2010 Search, I've added a new managed property that refers to a lookup column. I then added a custom refiner by modifying the Refinement Panel "Filter Category Definition". Basically, I ...
1
vote
3answers
86 views

Limiting permissions to list-items and library files without using folders

I have some files in a flat library, i.e., no subfolders, that need to have access restricted to a couple usergroups. I understand that one way to do this is by placing items in a subfolder in the ...
0
votes
0answers
34 views

Weird lookup column issue

I have process that I setup to summarize a list in a lookup column in another list and to automatically generate emails based on the lookup column. I noticed that things weren't behaving quite as ...
0
votes
1answer
34 views

Add dynamic link to InfoPath multi-selection field

I had to modify a form using InfoPath in order to achieve a feature that populates a multiple-selection field with data returned from a query (similar to what this tutorial outlines). Before making ...
1
vote
1answer
70 views

Example of a workflow pulling lookup column data for use in a calculated value column

I'm looking for an example of a workflow using SharePoint Designer 2010 that pulls information from a lookup list or via a lookup column and places it within a hidden field for use in a calculated ...
2
votes
0answers
77 views

Sorting a Lookup Column from Survey that pulls from Calculated Field SP 2010

I'm looking for a way to sort a Lookup question in a survey that pulls from a calculated field. Specifically, I have it lookup a calculated field that combines the date and name from a list. I want ...
1
vote
3answers
650 views

Get value of lookup field

I have a cascading lookup using two lists on my SharePoint 2010 site. I want to get the value of first selection made in the lookup and show/hide other fields on my custom form based on that first ...
0
votes
1answer
175 views

Conditional formatting lookup column

I am attempting to do conditional formatting in a list view in SharePoint Designer. In this list I have a list that contains a lookup column, and other columns derived from the list of that lookup ...
1
vote
1answer
695 views

SP2010 Search: Managed Property on lookup column returns “ID” instead of “Title”

I've got a document library named "Documentation" and a user defined list named "Suppliers". "Documentation" has a lookup column linked to "Suppliers": WAWI(text) -> linked to "Suppliers:Title" ...
0
votes
1answer
112 views

Specify Lookup list for the 'Title' Column of a Gantt chart view

I was hoping to use a lookup list as the title column for a Gantt chart view. The problem is when I go to the Gantt columns in the settings for the view it doesn't display any of the lookup list ...
0
votes
0answers
275 views

2010 Workflow vs 2013 Workflow - Lookup columns

I tried to make a 2013 workflow and ran into exactly this issue: SharePoint 2013 Workflows List does not exist error Well, as a workarround I tried to make a 2010 workflow and noticed this: Why ...
0
votes
0answers
300 views

Values missing for dependent lookup column from parent list when using linq

Situation I have 2 site content types defined that are deployed as a site feature: Customer Name Address Order Value There is a second web feature that deploys a list to the root site for ...
2
votes
2answers
89 views

Am I doing something wrong, or are these common pitfalls or limitations of using lookup lists?

I'm using (and limited to) OOTB Foundation 2010, and have been exploring lookup lists. I am discovering a few things that aren't working the way I'd like, seem to be working inconsistently, and are ...
0
votes
1answer
196 views

Access Lookup to Linked List

I am trying to create a lookup from one Access table to a linked list from SharePoint. I need to have a lookup between the two because in order to create the type of subform that I need, there has to ...
0
votes
1answer
446 views

Clear all values in a multi-value lookup, via REST, SP 2010

Conditions: SP 2010, html/javascript, using REST to read/write to various lists. Im using a jquery multiselect plugin to set a multi-value lookup column. I need the selecting Groups of items, easy ...
2
votes
1answer
214 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 ...
0
votes
1answer
31 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
1answer
141 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] ...
0
votes
1answer
191 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 ...
1
vote
0answers
286 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 ...
3
votes
2answers
3k views

Multiple fields to same list in join (CAML)

Current situation: ============= In my example, I've got 2 custom lists: Accounts Addresses In the "Accounts"-list I've created 2 lookup columns to the "Addresses"-list Address1 Address2 When ...
0
votes
1answer
126 views

Can I edit a LOOKUP column?

More concisely: How do I edit a lookup column? I have a custom list with columns [Name] and [Product] named 'MainList'. I would like a third column [Referral] which shows a name found in ...
1
vote
1answer
1k views

How to add values from a multi-valued field from a list using SPD's Update an Item Action

I have a workflow that automatically updates the value of a multi-valued field in an item. This workflow is working as expected. BUT, when that field/column of an item has a value already, the current ...
2
votes
2answers
4k views

Add additional field to lookup field inside schema.xml

I'm following the steps in this article to setup a joined data view webpart joined on a lookup field: ...
1
vote
3answers
962 views

Calculated Formula Insert From Another List

I have List A which has all information. List B has Col 1 that looks up one of the List A's columns. Col 2 is a Calculated column that want to use Col 1 but SharePoint is not able to see Col 1 ...
1
vote
2answers
341 views

Matching value from single line of text column to lookup column

I have a library containing a large amount of items. The library contains a column of type 'Single line of text' with a code in it. The code was taken from an external system and entered manually. ...
2
votes
2answers
597 views

SharePoint 2010 NewForm.aspx Lookup Fields Issue

I have a SharePoint 2010 Foundation site that has recently been upgraded from WSS 3.0. The upgrade was completed successfully with no glitches. However, ever since I have upgraded the site I have ...
2
votes
1answer
469 views

Use count-related column value as int in a SP Designer-workflow

I have another problem concerning the count-related column-value of SP2010 in a workflow(see also: How to get count related Lookup value programmatically? ). my use-case: I have a column "actual ...
0
votes
2answers
589 views

Accessing LookupFieldValue throws error

I have a lookup field on a list (header) that looks up values on the same list. I am trying to read the value out of that lookup with this code: using (SPSite site = new SPSite (mySite.ID)) { ...
0
votes
1answer
710 views

How to get count related Lookup value programmatically?

Another day, another question ;) So, I have two custom Lists, "Attendees" and "Events". In the Events-List there's a Lookupfield "Registrations" which I want to fill programmatically on page_load. In ...
0
votes
2answers
767 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
2answers
65 views

Library item “referencing” other content

Sorry for the nondescript title, it's a little hard to explain concisely. We are setting up SharePoint 2010 to act as a simple document management system, to store documents such as forms, ...
0
votes
2answers
195 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 ...
0
votes
1answer
68 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
106 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 ...
1
vote
1answer
793 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
1answer
1k 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 ...
2
votes
2answers
262 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
0answers
584 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
1answer
549 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 ...
1
vote
2answers
672 views

Add lookup field to list from a RootWeb

I have the site collection rootweb called Main Site. I have many subsites called according to the year, 2012, 2011, etc. In the rootweb, there is a list called Products. In the subsites there is a ...
0
votes
2answers
571 views

Lookup field on custom form does not save once deployed on testing

I have a custom form on a content type I've created. This content type has 3 site columns which are a lookup field from 3 lists. In the form I've created the user selects a dropdown box and chooses an ...
0
votes
2answers
2k views

Multi select Lookup column returns null in javascript client object mode;

I am trying to retrieve the selected values of multi select lookup column and store them in array and then set the lookup column with the same selected values after drop down value changes but always ...
1
vote
0answers
84 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
2answers
2k views

Modify existing lookup type column to managed metadata type

We are in process of migrating one of our big website which is built in WSS 3.0 to SharePoint 2010 Standard version. In the process we want to convert all lookup columns to managed metadata type. We ...
4
votes
1answer
621 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 ...
0
votes
1answer
1k 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); ...