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.

6
votes
0answers
744 views

SharePoint Online list view threshold error in a lookup column

I am facing an issue with lookup column in the list forms due to list view threshold limit (5000 items). The parent list is having more than 5000 items. Hence the lookup field is not getting ...
4
votes
0answers
726 views

Query string filter on an InfoPath lookup field

I am trying to use a query string filter to filter data on an InfoPath form using this guide. The column that I'm trying to filter is a lookup field and it is not available in the list of Consumer ...
3
votes
0answers
199 views

Calculated site columns/Lookup site columns - cannot add calculated numeric fields

I have a list with broken down data that is aggregated to some kind of combined ID data format that references a certain file. (Say, there is a file called 123-1. I have a field then that stores "123" ...
3
votes
0answers
424 views

Word 2016 show details button not working

I have Sharepoint 2013. In one of my document libraries I have a lookup column that references a list on the same Sharepoint site. We have just recently upgraded from Office 2010 to Office 2016. ...
3
votes
0answers
53 views

Is it possible to create a lookup column with a list of all lists on the site using a WSDL data source?

I have a list in which I want the user to be able to select the name of 1 or more lists/libraries that exist on the account. I know I can use _vti_bin/lists.asmx?op=GetListCollection to get a list of ...
3
votes
0answers
318 views

Creating cascading lookup columns in sharepoint 2013 foundation

I am trying to create cascading lookup columns in my library. I have already tried to use a jquery solution: http://www.codeproject.com/Tips/758909/Two-Level-Cascading-Drop-Down-in-SharePoint-using, ...
3
votes
0answers
89 views

Lookup fields will be rendered as a list of checkboxes inside iphone safari web browser , instead of being rendered as a select list

I am working on an issue tracking list which have a lookup column named “Related Issues”, which is rendered as a select list inside IE on desktop browser as follow:- But when I access the list from ...
3
votes
0answers
651 views

CAML Contains on a lookup field of a calculated column

I have some issue when using the CAML Contains statement when the field is a lookup field on a calculated column. It basically does not work, the Equal works though. here is the query, nothing ...
3
votes
0answers
498 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 ...
2
votes
0answers
126 views

Large Dropdown Lookup with Autocomplete

Wondering if anyone can point me in the right direction. Requirement is a drop-down field in a SharePoint Online list that references a customer table in SharePoint Online. Of course, the customer ...
2
votes
0answers
163 views

Filtered lookup based on lookup

My situation is this: I'm trying to set up a review site for the publishing house I'm working for. Basically, the editors should be able to pick reviewers for new books based on certain categories. ...
2
votes
0answers
91 views

Link to related documents in another list

I have two sharepoint lists. List 1 has a list of projects and includes a geolocation column. This allows me to view the projects on a map. List 2 is a document library where up to 3 documents are ...
2
votes
0answers
240 views

Sharepoint REST API empty value on expanded lookup columns causes error

I have a list with lookup columns. When I get an item from the list and expand the lookup columns, I get an error if any of the lookup column values are empty. For example if I have a list with the ...
2
votes
0answers
142 views

How to get the attachment files of an expanded lookup column

I am trying to get the attachments from a lookup column. A loose example: ListA has a column LookupColumnName and I am trying to do something like this: _api/web/lists/GetByTitle('ListA')/Items? $...
2
votes
0answers
53 views

Solution deployed to a web application errors when not using FQDN

EDIT: using SP2010, with Enterprise and Publishing features enabled at the WebApp and site where intend to use the feature. We have a 3rd party solution (Lookup with Picker [ilovesharpoint.fields....
2
votes
0answers
645 views

Online - Filter the options of a lookup column

I'm using SharePoint Online. In the "Contact" list have a calculated column with this formula: IF([Active],[Last Name]&" "&[First Name],"") This formula is working fine. In another list I ...
2
votes
0answers
81 views

Selecting nullable property of an expanded object

Symptoms I have a list, call it Questions, that has a multi-lookup to another list, call it Answers. To get a single question by Id with its Answers, my query would look something like this... $...
2
votes
0answers
457 views

Display Template lookup column additional fields

I have a search based solution where I work alot with Display Templates to render out results in a fancy way. It all works fine and dandy with Managed Properties mapped up etc. However, I've come ...
2
votes
0answers
238 views

SharePoint Designer Workflow create new item with lookup to current item

I have two lists, "customers" and "expense Sheets". The list "expense sheets" has a lookup column "related customer" to the "title" field of the "customer" list. I am trying to create a workflow for ...
2
votes
0answers
67 views

Is cross-site lookup possible with a provider-hosted app?

I have following problem. I got two projects, one sharepoint-hosted app and another provider hosted app. Both contain a couple of lists. So far so good. Now I need the data from the sharepoint-hosted ...
2
votes
0answers
555 views

Adding fields to a list's existing lookup column won't add them to list's existing content types

I have created a custom list, in which I am not using any Site Columns or Site Content Types; I started with the OOTB Item content type and added various custom columns to the list using the "Create ...
2
votes
0answers
172 views

Recurring Events in Calendar created from a template

Using SharePoint 2013 on-premise, I had a calendar working nicely in my test environment. I then Saved it to a template, moved it to another site collection and created a new calendar. It had lookup ...
2
votes
0answers
71 views

Does the total amount of lookups affect performance in a CAML query that has less than 8 lookup columns?

I have a large library with 12 lookup columns, and while I only use 6 of these columns when I retrieve data from this library (in a CAML query), the retrieval process often takes 20-30 seconds. Would ...
2
votes
0answers
54 views

Lookups in SharePoint Workflow Emails

I've created a workflow that sends an email to all users when any new item is added to my "Payroll Processing" list. I want to be able to display the Client Name in the email that gets sent. The ...
2
votes
0answers
137 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 ...
2
votes
0answers
179 views

Join SPQuery in list

List 1 "Posts", fields Title body #comments modified in this list #comments fields is look up from another list Comments: List 2 "Comments", fields title body comments post ...
2
votes
0answers
99 views

Sharepoint 2013 not displaying lookup field as input

I have a lookup column whose datasource has many items (2 000+) and when creating an item that references the source list, a dropdown is not very suited for the task. In SP2010 when there were more ...
2
votes
0answers
317 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 ...
2
votes
0answers
398 views

Getting distinct/unical values from External List

I have got an External List. I want to get distinct values from this External list to the dropdownlist getting from lookup Field. The values are often repeated. How can I get distinct values from ...
2
votes
0answers
754 views

Filter a CQWP on a Lookup Column

I'm creating a custom page layout that contains a CQWP that I'd like to display documents related to the page. The document library has a lookup column that relates to the page title in the Pages ...
2
votes
0answers
448 views

Filtering LookupMulti by FilterMultiValue SP2010

I can't filter LookupMulti's column using FilterMultiValue. My Url contain this fragment FilterName=Tags&FilterMultiValue=Flower;Sword Three is nothing, apart correlation ID. I found in ...
2
votes
0answers
155 views

Best way to create a list with hidden columns with Data pulling from InfoPath form

So I have been working on this for a little bit here is what I am trying to accomplish: Using OOTB SharePoint 2010 Functionality I want to create an HR Referral System. Basically an InfoPath Form ...
2
votes
0answers
1k views

Inserting new item in list with EntityRef field to User Information List using Linq to SharePoint

I have a list with SPFieldUser field type in it. I try to insert new item in this list using Linq 2 SP. So, I generated data context class using the following configuration file: <List Name="User ...
1
vote
0answers
29 views

Cross site collection lookup field (SPO)

I need to create "cross site collection lookup field" in the SharePoint Online List. I can programmatically change "List" and "WebId" in SchemaXml from LookUp field. It helps to get "cross site" ...
1
vote
0answers
21 views

SharePoint 2013 bulk edit column not updated

When selecting edit list, select the column, the choices are not updated from the lookup list. But if you edit an individual item the lookup choice is available for a selection. How do I get the ...
1
vote
0answers
55 views

Me Filter on Multiple Selection Lookup Column

I have found plenty of information about filtering lookup columns (title: Employee)during searches but I haven't located something that said using [Me] filter. I created a lookup column that has ...
1
vote
0answers
160 views

Fetch values into dropdown list column based on query from another list - jquery

Please help me with some code (preferrably jquery). Sharepoint 2016. I have List 1 with columns Resource, Attribute1, Attribute2,..., Attribute10. And I have another List 2 with columns Project, ...
1
vote
0answers
162 views

Can you use a lookup column to filter results in a content search webpart?

I am working on a site in Sharepoint 2013 and I have created a content search webpart in a page layout used for multiple pages. I want to be able to display items from a list that are associated with ...
1
vote
0answers
73 views

set value in Sharepoint cascading dopdowns 2013

I have a newform that sets values on selection of a dropdown value in other fields on form. eg. I select a value in ID dropwdown and all the field values related to that selection are prefilled in ...
1
vote
0answers
61 views

how i can create a site column of type lookup with empty source list (Get information from), and modify the “Get information from” at list level

I am working on an on-premise sharepoint server 2013 farm. i have the following:- 1) i have a team site collection which contain 5 sub-sites. 2) under each sub-site i have a custom list named "...
1
vote
0answers
91 views

How to group multiple variables on lookup column?

I want to separate multiple rows. How can i do this with another web part listview or programmatically?
1
vote
0answers
26 views

Lookup column to Page library with versioning remains empty after search crawl

We have a content type (named: Tiles) of 7 lookup site columns that point to the ID field of the Pages library on the same site. The Pages library has versioning (Create major and minor (draft) ...
1
vote
0answers
141 views

How to copy the value in a lookup field to a related item in the same lookup column?

I'm looking to fill out a lookup column. I have a couple of Sharepoint Designer Workflows to set a lookup column field in list A to a related ID from another list B when an item is created in list C. ...
1
vote
0answers
129 views

Display Childs in Parent list possible? (Parent-Child relationship list)

I know how to create a Parent-Child relationship between 2 lists and display the Childs in the parent form or on a Webpart near my parent list but what I would like to do is actually display the ...
1
vote
0answers
39 views

Lookup data updates in Content Search Web Part / Search Results

I am using a content search web part to serve up text content and hyperlinks from a list (We will call this the main list). Everything is displaying as expected. One of my fields is a lookup column, ...
1
vote
0answers
69 views

User Profile replicable field not showing data from user

We have created a custom user profile field called "X" and checked the box for replicate and alias and ran a full profile sync. The field "X" appears in the drop down list for field to show when you ...
1
vote
0answers
47 views

Using Flow to change Client Status in Client List based on Activity Type in Activity List

I have a list of Clients and a list of Activities. Activities includes two lookup columns: Client Activity Type Clients includes one lookup column: Client Status What I'm trying to achieve is ...
1
vote
0answers
169 views

Page layout in Root site with lookup field that refers a list in child variations sites Issue in sandboxed solution sharepoint online

I have a sharepoint online site created with No Code Sandboxed Solution. In the feature scope site , i put the content type that contains the lookup field "Category" and the module of the Page ...
1
vote
0answers
16 views

How changes at the lookup field affect the destination list

I have list A that a lookup field "LF" to list B. If I change an item on list B, will all items in list A get the new value? Thank you
1
vote
0answers
291 views

Lookup site column created using powershell will have an empty source list

I am working on a sharepoint server 2013 on-premise. and i run the following power-shell script to create a lookup column :- #Create site column from XML string $web.Fields.AddFieldAsXml($fieldXML) ...