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.

383 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6
votes
1answer
1k 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 ...
6
votes
2answers
4k views

set multiselect lookup column using jquery

I have a Multi select Look up column which as you all know is a control with two list boxes and "Add or Remove" Buttons. The user populates the right-hand side of the control with some values by ...
6
votes
1answer
150 views

Custom field type from SPFieldLookup - item values are not appearing in List view

I have created custom field type with SPFieldLookup as a parent class. Using my custom field type, I can able to create custom lookup type columns where source columns are of types: Choice and User ...
5
votes
1answer
1k views

Sharepoint 2013 - Add lookup column to key filters

I've got a document library of invoices. It has various columns (mainly choices) such as, Year, Status, Location, etc. and I've been able to add them to metadata navigation as key filters. However, ...
4
votes
0answers
507 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. ...
4
votes
1answer
505 views

Exporting a list with lookup fields

I'm in a situation where I need to export 2 lists from site Site A to Site B. The lists I'm exporting have a lookup relation. List X has a lookup to List Y. List Y gets imported to the new location ...
4
votes
0answers
747 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
1answer
994 views

Can i group documents by using lookup column with multiple value?

One document belongs to many row. It is allowed . But I want to group them and show the document on each group. Is it possible ?
3
votes
0answers
294 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
1answer
93 views

Connect lookup field to a list inside an app

I have a list in SharePoint online which should get a lookup a field to a list which is inside a SharePoint hosted app / add-in. Is it possible? My app has "FullControl" rights on the web and on the ...
3
votes
1answer
67 views

How to insert new item with multi users ids using batch element?

I am getting issue while creating a new item with multiselection peoplepicker field named multiusers with ids, i am trying below code for stringbatch string strbatch="<Method ID='1' Cmd='New'>&...
3
votes
0answers
58 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
2answers
512 views

Remove Hyperlink for Multi Value look up column in Sharepoint

How can we remove hyperlink from a multi value look up column in SharePoint 2010 list. There are article on removing hyperlink from Single Value look up column. But I am not able to get a way to ...
3
votes
0answers
341 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
94 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
668 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
504 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
2answers
55 views

Sharepoint lookup to another list using current item ID

I am building a list, where I want to protect certain columns from editing by the users. I understood that Sharepoint does not have column protection functionality. One of the workarounds is to have ...
2
votes
0answers
168 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
1answer
402 views

Lookup columns not visible in designer workflow

I have a massive 2013 list workflow build to handle projects on the SP Online platform. This workflow utilises a few lookup columns and people fields - but no more than 5! For some strange reason I ...
2
votes
0answers
197 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
118 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
1answer
580 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
196 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
70 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
726 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
147 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
508 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
275 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
1answer
90 views

Library upload form Dropdown options order

I have a library to store files (obvious) with column "City" which is a lookup to list with two columns (CityName & Order). How to change ordering of options in dropdown field (which is in ...
2
votes
1answer
71 views

Restricting a lookup field in a list

I'm putting on SharePoint Lunch and Learn training for my company. I'm wanting them to sign up. In one list, I have title and date Lunch and Learn 1, January 15 Lunch and Learn 2, January 22 In ...
2
votes
0answers
69 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
690 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
1answer
887 views

How to use a lookup column's additional field in a workflow?

Background I have two lists. One is a list of voltages and their corresponding costs. This is to be used as a lookup for other lists. Voltage Cost 120 2.50 240 ...
2
votes
0answers
178 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
74 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
1answer
2k views

Displaying multiple column data in a drop down menu

I'm using SP2010 unfortunately without SP Designer and only used InfoPath once. I have 2 lists: List A - Is a list of 'Event Codes' with a 'status' column displaying Active, Used or Reserved ...
2
votes
0answers
55 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
157 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
2answers
5k views

Workflow Error: Coercion Failed: Input cannot be null for this coercion

I have a workflow that is assigning a task based on a lookup value. This workflow runs successfully the first time then fails on subsequent attempts. Here's how the data looks: Look Up Title ...
2
votes
2answers
4k views

Pull multiple values through a lookup

I am rather new with SP so I apologise if I cant express myself too well. Problem at hand: Two lists - Shops and Managers with a many-to-many relationship between them. I.E. in Shops there can be ...
2
votes
0answers
182 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
324 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
399 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
792 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
458 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
1answer
32 views

Sharepoint Lookup Column with Multiple Display Vertically

I'm using a SharePoint lookup column that has a multi-select choice field. When 2 or more values are selected for an item, it is displayed in the view like this: Value1;Value2;Value3;Value4;Value5;...

1
2 3 4 5
8