Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [lookup-column]

A lookup column is a SharePoint list column that retrieves its available values from another column within another list in the SharePoint site.

1
vote
0answers
73 views

Uploading file in a Sharepoint Library with a required lookup field with copy.asmx

I'm trying to upload a file in a document library. I'm doing it with the copy.asmx web service. I've no problem with document libraries that don't contain lookup field. But if the library includes a ...
1
vote
0answers
57 views

Master and child Sharepoint 2010 lists using look-up

I am process of creating a parent and child custom SharePoint lists. Going through the online forums I figured out how to create the parent and child list (relationship). However I am running into ...
1
vote
0answers
40 views

Lookup Field in List has no selection menu

I have created a list via Visual Studio and added a Lookup Field to an another list and which is looking for the ID of the other list. In fact this lookup field is the second one in this list. There ...
1
vote
0answers
573 views

How to prefill a lookup column in custom new item form: no JavaScript

The goal is to automatically fill a lookup value on a new item form, hidden from the user, based on a parameter value. Preferably without using JavaScript, since I am using a parameter passed from a ...
1
vote
0answers
111 views

External Content Type : How to display label on lookup columns (without unable edit / new form)?

I have a SQL Server Table A with a foreign key with reference to B : id_A [int auto_increment PK] name [varchar()] ref_B [int FK_ref_to_B] I try to display A in an External List based on External ...
1
vote
0answers
251 views

Limit Row Height on rows with Lookup Column

I have a SharePoint list in which there are three columns that are lookups from another SharePoint list. The list has custom CSS (below) that limits the row heights on all columns except the lookups. ...
1
vote
0answers
131 views

Change a lookup column's width without influencing other text boxes

I wanted my lookup column to be larger therefore I added a web part with code to my NewForm: <script src="http://code.jquery.com/jquery-latest.js" type="text/javascript"></script> <...
1
vote
0answers
58 views

receiving errors while working on Advance look up column in SP 2013

I am working in SharePoint 2013, I received errors while I was working on Advance look up. Two errors one after the other: System.InvalidOperationException: Sequence contains no matching ...
1
vote
0answers
115 views

Sort View based upon a specific order of a lookup column

Our standard setup when a department requires a document library with document types is to create a separate Custom List for the Document Types so a power user within that department can add new ...
1
vote
0answers
39 views

Create a button on list view page to copy items to another list

i guys, So my scenario is the following: We have list A and list B, I want to add a button to list A (maybe in content editor web part) to copy the selected list items (multiple items) to list B, I'...
1
vote
0answers
29 views

Lookup column lookups up link, not text

brand new oddity I have yet to see. I have two web parts, a picture library (projectPictures), and a list (projectProfile). On ProjectPictures, I have a nonworking workflow (it is supposed to copy ...
1
vote
0answers
34 views

End user picture choices

I am struggling to come up with a method to allow my end user to set up a "project page" as we call them. Basically, this is a parameter based page that filters using ProjectName for both the CQWPs ...
1
vote
0answers
74 views

Lookup Column in two lists

I have a situation on our team that requires us to redesign a set of lists. This directly relates to a client side development effort where we need to re-engineer a Custom Sharepoint Solution written ...
1
vote
0answers
25 views

Lookup column that auto filters bases on site pages.

I'm building a form that surveys user's opinion of the page the page viewed by the user. I have a list with a lookup-column that gets the ID from site pages. I'm looking for the ID to be ...
1
vote
0answers
28 views

Lookupfields in SharePoint hosted add-in

Is it possible to use Lookup fields in SharePoint Hosted Add-ins ? I can add them via GUI in VS, (similar to this http://www.enjoysharepoint.com/Articles/Details/add-lookup-field-type-column-in-list-...
1
vote
0answers
260 views

Using a lookup column to filter library web part

I want my users to select ID's in a list - those ID's have been contacted that day. The problem is: for future reference, the managers want to go back to that day and easily access all library items ...
1
vote
0answers
80 views

Lookup doesn't work on field that has taxonomy field

Is there any reason why lookup field in one list would stop working when taxonomy field is added to other list that lookup is referenced to? Before adding the taxonomy field lookup was working just ...
1
vote
0answers
581 views

Lookup to a column in a library having multiple hierarchical folder structure

I have a library A that has multiple folders and documents. I want to create a list B with a lookup column pointing to a column in Library A. The problem I face is that the lookup column fetches ...
1
vote
0answers
60 views

Auto generate sequence column + a look up info column from another list and calculate in Sharepoint 2013

I've an issue on calculating lookup value from other list.. I have List called "Product". in that I have column name "ProductCode"(Single line text) and "Unit Price"(number with 2 decimal). I've ...
1
vote
0answers
461 views

Auto Fill Lookup Column

I believe I am starting off on the right foot by using a lookup column. I am seeking a way for when a user enters in a order number the number auto populates in a choice column. So basically every ...
1
vote
0answers
112 views

display lookup multivalue in quickpart

I have a lookup field with multi value. I'd like using quick part in my template (i know how to use quick part) But i need displaying multiple value (lookup multisel) in a dynamic table. How can i do ...
1
vote
0answers
336 views

Secondary lookup columns missing in Display/Edit form view

I have one list that has a lookup column for 4 different lists. Each lookup column also brings in a secondary lookup column which is a Calculated Column. I can bring both the lookup column and the ...
1
vote
0answers
116 views

Why aren't the addition field columns populating when I select a value from a lookup column?

I have an Equipment List that looks like this: Number Description Mill Area 1 pump warehouse 2 motor outside 3 shaft yard 4 bearing ...
1
vote
0answers
78 views

How can I change the Mobile View “lookup” list threshold?

I came across a limitation when using "Mobile View" where my lookups were displaying a maximum of 20 items. This only happens in mobile view. How can I change or remove this threshold limitation? ...
1
vote
0answers
592 views

Cascade delete from lists

I have 3 lists with a lookup field to a document library. This fields is created from XML (deployed) with this properties: Indexed="TRUE" RelationshipDeleteBehavior="Cascade" Now, what I would ...
1
vote
0answers
64 views

Sharepoint 2013, cascading lookup/dropdown what happens with old data if data changes

Situations tend to change, so sometimes cascading dropdown menu's get adapted because they are no longer relevant ... My question is: what happens with metadata based on the old cascading dropdown ...
1
vote
0answers
83 views

SharePoint 2013 choice column DropDownlist

Is it possible to update a Choice column with workflow ? I have created a list and created a lookup column that displays the name Company. I have connected the column to a document the Library of ...
1
vote
0answers
107 views

Limit dropdown options when the lookup column is a site column and has more values than are relevant

I have a list of projects on my parent site with two columns: ` Project Category I would like to use Project as a site column that looks up values from the aforementioned list so I can maintain a ...
1
vote
0answers
108 views

How to filter lookup field by site name

I have a list like this: Title Site AAA Site1 BBB Site2 CCC Site2 which is referenced in a lookup column. Requirements are to filter in the lookup column only the items whose "Site" property is ...
1
vote
0answers
2k views

SharePoint Online Lookup Dropdown Autocomplete/Combobox

I have a list in Sharepoint Online, which has a lookup to an other list. No matter what, on the form it will always render as a dropdown value. When this list of values becomes huge, it's hard to find ...
1
vote
0answers
185 views

How to Update/Set Field values by LookUpId in a sharepoint list?

I have a list called ResourceCheckList which contains following columns with lookup fields as below : Here Resource:ID is a lookup column which contains unique ID of another list. So, I want to ...
1
vote
0answers
740 views

CSOM retrieve List Item doesn't show some Lookup Key Value pairs

I try to load a ListItemCollection from my SiteCollection using CSOM C#. Therefore I use the following List rr = web.Lists.GetByTitle("MyTitle"); context.Load(rr); FieldCollection fcol = rr.Fields; ...
1
vote
0answers
61 views

SP 2013 : Specific item in a lookup field cannot be filtered

the list A has a lookup field connected to list B in field Title. One of the items in list B has title "CCAA". On A/ViewAllitems, i can filter in column lookup:listB:Title for every item, except for ...
1
vote
0answers
43 views

How to develop an event receiver on selecting item from dropdownlist

In my SharePoint list,I have a lookup column. When I select one item from the lookup,I need to show the information from the selected one(like title,ID...). I think that developing an event receiver ...
1
vote
0answers
130 views

How to auto generate parent MMD columns based on child MMD columns?

This is the structure of one of my Term Sets. I have a Site Column called Record Type (Deeds, Agreements, Permits) I have a Site Column called Deed Type (D1, D2, D3) I have a Site Column called ...
1
vote
0answers
51 views

Document Set lookup error

I have what seems like a minor bug when setting up a new document set. I've created a new content type based on a document set. One of the columns in the document set is a look up to a supplier list. ...
1
vote
0answers
573 views

Creating a survey with a question being lookup column with filtering

So I need to create a survey on a monthly basis with just one question. Possible answers should be the values from a lookup column, but limited only to those from the previous (calendar) month. Is ...
1
vote
0answers
266 views

SPD 2010 workflow, update (add and delete) lookup column

I have a list (with a custom InfoPath form) in which I have items that have a Parent / Child relationship with two lookup column to the title column of same list. The two lookups are "Child of" single ...
1
vote
0answers
26 views

Display deactivated items in lookup column

We have a list of projects. One column is named Status (a choise Active or Finished) One column is Active Projects (a calculated column which shows only the actieve projects) One column is named ...
1
vote
0answers
2k views

Site Lookup Column As Managed Property

Please let me know if my logic here is incorrect or suggest better alternative. This is hosted on Office 365. I have a Site Lookup column (EventLookup) that is linked to a list on my Root Site --> ...
1
vote
0answers
338 views

how do I create search in sharepoint list edit form using infopath

I have a list called Tasks in sharepoint 2013 that has a number of lookup fields. It was initially created by exporting data,tables and relationships from Access 2013. The client wants to be able to ...
1
vote
0answers
384 views

Count number of references in a multi-value lookup column

I'm using SharePoint Online, and I have one list of meetings, and one list of people. Meeting has a multi-value lookup column of people, so that several people can be added to a meeting. How would I ...
1
vote
0answers
522 views

Multiple Column Lookup field from Access to Sharepoint

I have two fields called "Tool ID" and "Tool Name" in my main "Tools" table in Access. "Tool ID" is set as the primary key, in that it gives each tool a unique autogenerated number. When I ...
1
vote
0answers
74 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
210 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
506 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
286 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
683 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
516 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 to"...
1
vote
0answers
411 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