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
1answer
39 views

Lookup Column of a List Column

I have a requirement for a project site in SharePoint. The Site will have: 1st List: a Stakeholders List with the names of people involved (people/group type) in the project and their Project Role ...
0
votes
0answers
18 views

Using lookup to populate list and want Items select to update other list as checked out

Using lookup to populate list and want Items select to update other list as checked out. I have 2 lists with data. Using 3rd list to store select items from other lists. List 1 is a job list. List 2 ...
0
votes
3answers
164 views

Is it possible to have a lookup field with autocomplete feature

I have defined a lookup field with multiple values over a contact list inside my SP 2013 team site, and by default I got a select list as follow:- So is there a way to have the lookup field with ...
0
votes
0answers
26 views

Sorting lookup column by descending dates in list form in SP 2010

I have a lookup column (Date of Distribution) that pulls a list of dates from another list on the same site. When the lookup pulls the dates, they are in ascending order, so the oldest first down to ...
0
votes
1answer
49 views

Unable to create a look-up site column at the site collection level, then override it at the list level

I want to create a new Lookup site column named "List Attendees" which will contain unique values for each list. so i created the new lookup at the site collection level, but i faced the following ...
1
vote
1answer
78 views

In SP Online, how to return the default HTML of a lookup field when overriding the Item Template in a list view

I've found various methods to return the default values for the field template override, including lookup, but I have been unable to find or successfully implement a method to do the same for fields ...
0
votes
1answer
45 views

Mixing between “lookup” column type and “People or Group” column type

I want to create a site column that contain a list of “Project Managers”, where some project managers are already defined inside Active directory and are defined inside a SharePoint security group , ...
2
votes
0answers
29 views

Multiple Criteria Lookup in Parent List

I have a list of projects (Project List) and another list of periodic status updates (Status Update List) related to each project (one-to-many). I need a lookup column in the Project List that ...
0
votes
2answers
56 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
14 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
164 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
34 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
28 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
17 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
39 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
44 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
10 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
24 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
35 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
59 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
75 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
46 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
61 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
99 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
30 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
26 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 ...
2
votes
0answers
87 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
39 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
127 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
32 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
63 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
202 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
104 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
25 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
22 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
38 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
123 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
45 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
184 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
22 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
25 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
47 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
19 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
32 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
30 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
51 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
112 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
58 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
83 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
63 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 ...