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

learn more… | top users | synonyms (1)

0
votes
2answers
33 views

Alternative to Lookup Column

I have a list with a lookup column displayed as a dropdown menu in the NewForm allowing the user to pick a contact person retrieved by lookup to the contacts list, however this list will soon grow ...
0
votes
0answers
8 views

Sharepoint 2013 Foundation filtered value from other list

We have two lists- One for contacts and other is vacations. Our goal is following: When we open a contact card there would be a value from vacations list what would only display the vacations of the ...
0
votes
1answer
35 views

SharePoint 2010 Rest query for Lookup fields

I am writing a REST query to retrieve data from child parent list. States is the parent list with "Title" column. LocalGovernment is the child list with "State_Territory(InternalName) and State / ...
2
votes
1answer
26 views

Lookup column showing up properly when logged in as Full Control user, but not showing up properly when logged in as Contribute user

I have a SharePoint 2010 form with a couple lookup columns. The form looks normal to me with Full Control permissions, and the dropdowns for these items are showing up normally on the form, but ...
0
votes
0answers
13 views

Workflows - getting fields to populate look up fields before sending an email

I'm working between two sites (a) and site (b). I'm also using cross-site publishing. On site (a) each item from a document catalog on site (b) is displayed and the url contains the ItemID. On ...
0
votes
0answers
16 views

How to interact with a XsltListViewWebPart

Try to imagine this scenario: You have a list A with one field TitleA, and you have a List B with three fields: TitleB, FileAttachement, Lookup(A). From an Application Page you want to create a new ...
0
votes
0answers
15 views

List only shows id numbers and not the text when mapped with infopath

I have run into an interesting problem and was wondering if anyone else has experienced this and found a workaround. We have a list with several choice columns. The choices in those columns were kept ...
1
vote
0answers
26 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 ...
0
votes
0answers
6 views

Client side populate dropdown with lookup values

In the UI of SharePoint I've added a lookup to a child list. I now need a custom form where the user can set this value via a dropdown. Do I need to load the data from the parent list or is it all ...
1
vote
1answer
23 views

Create a Cross Site Lookup in a declarative way

I can declare a lookup field with this line: <Field ID="{3EA24157-1C11-41CB-AA01-5EEEF93C2603}" Name="NewField" DisplayName="New Field" StaticName="NewField" ...
0
votes
2answers
26 views

lookup another lookup

I've 3 lists. List B looks up List A and then I need to create a lookup in List C that lookups List B but also get values in List B that are lookups of List A. How is this achievable? Thanks
0
votes
0answers
18 views

Filtered lookup using SPServices

I have 3 lists: Schools, Interactions, Contacts In the new form for a Interaction item I have a lookup field displaying a long list of contacts, however I need to filter this list to only display ...
1
vote
1answer
53 views

Reasons why a Lookup field doesn't work

I'm struggling with the declarative creation of a lookup field: <Field ID="{3EA24157-1C11-41CB-AA01-5EEEF93C2603}" Name="NewField" DisplayName="New Field" StaticName="NewField" ...
0
votes
1answer
30 views

Set a Lookup reference to a Field that already exists

I need to set the lookup reference to a field that already exists (of type lookup) that is not pointing to yet. I can get the lists and the fields but I don't know how link to each other. Can you ...
2
votes
1answer
38 views

How to set image path to lookup column?

I have a custom list having lookup with a picture library. But when I am creating lookup it just gives some of the columns like Title, Created, Modified, etc. it do not gives any value like FileRef or ...
0
votes
1answer
31 views

How to show Created By and Modified By columns as lookup field?

When I want to add a lookup column to a document library, created by and modified by columns are not listed. Can I add these columns to another list or document library as lookup column?
0
votes
0answers
18 views

SharePoint 2013 List Error when selecting less than two Items in a Column Filter (Primary Lookup Column)

I have a SharePoint list with many columns, two of which are SRN and PN. SRN is a Primary Lookup Column (values to choose from are populated from source list), and PN is a Secondary Lookup Column ...
1
vote
0answers
17 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
32 views

Cascading functionality in quick edit mode in Office 365

I've sandbox solution in Office 365. I want cascading functionality of Country, State, City in SharePoint lists. I got that by using SPServices JavaScript but only in NewForm and EditForm. Want this ...
1
vote
1answer
26 views

Moving files between Libraries along with Lookup Columns?

Is it possible to move a file from one library to another along with the lookup columns associated with it?
1
vote
0answers
48 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 ...
0
votes
0answers
27 views

SharePoint 2010 Lookup IE more than 20 items no longer working

As opposed to almost everyone over the forums I looked, one of our internal client would like to have the complex lookup field to work back again. Since a month or two, apparently this feature stop ...
1
vote
0answers
34 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 ...
2
votes
1answer
68 views

Search Display Template Not Returning Values for Managed Property

Search results has no value for a custom site column. Ok, so I have a lookup column created as a site column in the root of my site collection. I found the field in crawled properties. NOTE: I am ...
2
votes
1answer
58 views

JSLink and lookup field problem

I am trying to make a cross site lookup field. So for now I made javaScript file and overrided the JSLink parameter. I want to made it clear for sharepoint and followed clientforms.debug.js ...
0
votes
1answer
21 views

how to lookup column that has versioning enabled in SharePoint Designer

I have a custom list "Requests" which is used to capture user requests. There is a column "Comments" which I have enabled versioning to capture conversation exchange between the user and request ...
0
votes
0answers
12 views

Projected field value display in view

I have a bank list with bank id and bank name. I have another list with bank name as lookup. In server side code when I am getting the Customer list collection I am getting bankID projectfield ...
0
votes
0answers
31 views

Associated Lookup column

I have a SharePoint 2013 list that contains a lookup column, and additional columns associated to that lookup. For example lookup column 'Car' and the associated is 'Car:CarDescription'. I have a ...
0
votes
1answer
39 views

look up column error

I am getting into a null array - $spList = $webobj.Lists["Studentlist1"] Exception calling "update" with "0" argument(s): "This lookup field cannot enforce a relationship behavior because it is not ...
1
vote
1answer
30 views

Dynamic Column choices

I have a task to create a Document Library in Sharepoint. I have done this several times. This particular site have a bit of a complex index structure. I am stuck on figuring out if it is even ...
0
votes
1answer
35 views

PowerShell script to create a list and add a lookup column

I need a Script to create a custom list and add a look up column into it and add the column into a default view. The look up column should have relationship of Restrict delete.
0
votes
0answers
17 views

Can a content type item inherit sibling column values from lookup column item?

Here is how I have my lists structured - in case it matters, List A does not currently utilize Content Types. The problem is in the List B view of Site Column B. Since Content Type Y doesn't ...
0
votes
1answer
24 views

Lookup column, using one or two features?

I have 2 lists with a lookup column. I'm thinking about 2 choices. Even putting them in the same feature or separate them in 2 features. My question is : Does putting the lists in the same feature in ...
0
votes
0answers
35 views

Lookups are empty

I have a rule set with two content types A and B. Both content types have the same parent content type and nothing else more. They are identical except for their name and ID. I'm adding files to the ...
0
votes
0answers
17 views

LookupField isn't displayed in application page

I have a custom list which I have a SPFieldLookup in. I've created an application page with my own custom creation form for a new item of that list so I'm trying to put an LookupField but nothing ...
0
votes
1answer
27 views

Lookup Column Making Creating a New List Item Take Way too Long

We have a Sharepoint list that contains information based on a daily receiving log for our receiving department. When it was set up, there was no archive workflows created, so now this list has grown ...
0
votes
0answers
21 views

OrderBy on a lookupMulti

I need to order a Caml query result's on a lookupmulti. Is that even possible ? Thx in advance.
0
votes
0answers
36 views

Cascading dropdowns with 2 parents

I've used SPservices to create cascading dropdowns via lookup columns without issue. My question is if it is possible to create a cascading dropdown with two parents (without using infopath). ...
0
votes
0answers
58 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; ...
0
votes
0answers
39 views

Issue Tracking and Related Issues Lookup Field

I'm using the out of the box issue tracking list and I'm trying to find a way to filter a multi choice lookup field based on another multi choice lookup field. I'm on Sharepoint Online, on an Office ...
0
votes
0answers
59 views

How to remove link to Lookup field in default DispForm

I have a list, with several fields, including a Lookup field. I display the items of the list on a custom webpart. Everything works fine. When I click on an item in the web part, the default DispForm ...
0
votes
1answer
40 views

How to copy choice column values to lookup column values

I am using sp 2010. I have a column from type "choice" and is multiple. I have created a new column from type lookup field. Also this lookup column is multiple. I already have migrated the values to ...
0
votes
2answers
80 views

Using a calculated column from a lookup list

I am working with SharePoint 2013 at a hosted site (not Office 365). Most of the questions I see when I search relate to including a lookup field in a calculated column. That is not my issue (but it ...
0
votes
1answer
51 views

Lookup Column - Shows Some Additional Fields, But Missing Columns

I have created two related lists. The first list is keeps track of specific meetings, with the following: Name of meeting (Single Line Text) Date of meeting (Date and Time) Chair of meeting (Person) ...
1
vote
2answers
29 views

Sorting Lookup Values

I have a list that breaks down periods within our accounting calendar. P1, P2, P3,...P12. The problem I am having is when I perform a lookup on this column it's sorting by alphabetical order and it ...
1
vote
1answer
30 views

Weird formatting for Item lookup

I have a lookup column in a List (A) which gets its value from a Single line of text in another List (B) where there is only a Title column. When sending out emails and I try to look up the value of ...
0
votes
0answers
47 views

Problem while resetting the share point lockup value with 20+ items

I have a sharepoint lookup and a text box. On Text box changed event i want to reset the next lookup value to (None) and text box to empty. Below is the code for the same. This code is working ...
0
votes
1answer
54 views

How to Increasing Lookup column limit from 8

I am facing following problem: 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown. Detail: The query cannot be completed because the number of lookup columns it contains exceeds the ...
1
vote
2answers
69 views

Add a lookup field for a list in Sharepoint Client Model

This is what I've achieved do far: var listCreationInfo = new ListCreationInformation(); listCreationInfo.Title = "New List"; listCreationInfo.TemplateType = (int)ListTemplateType.CustomGrid; List ...
2
votes
1answer
183 views

Edit Lookup table programmatically via Project Server Interface (PSI)

I have a standard lookup table database table "LOOKUP_TABLE_VALUES" in a SharePoint 2013 solution with columns like: LT_UID - for the Lookup table GUID LT_VALUE_FULL - storing the values with the ...