Skip to main content

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.

436 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6 votes
1 answer
2k 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 ...
Shekar's user avatar
  • 193
6 votes
2 answers
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 ...
Ranjani's user avatar
  • 63
6 votes
1 answer
203 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 ...
Dikesh Gandhi's user avatar
5 votes
1 answer
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, ...
user1416564's user avatar
4 votes
0 answers
529 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. ...
Jek Ng's user avatar
  • 145
4 votes
1 answer
581 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 ...
user avatar
4 votes
2 answers
578 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 ...
SushriSmita Rout's user avatar
4 votes
0 answers
800 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 ...
mr.freeze's user avatar
  • 141
3 votes
1 answer
2k 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 ?
f_gulay's user avatar
  • 651
3 votes
0 answers
367 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" ...
Isa's user avatar
  • 410
3 votes
1 answer
100 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 ...
dev.Manderson's user avatar
3 votes
0 answers
553 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 ...
binusr's user avatar
  • 31
3 votes
1 answer
94 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'>&...
Rehman's user avatar
  • 41
3 votes
0 answers
74 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 ...
IMTheNachoMan's user avatar
3 votes
0 answers
904 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 ...
Dan Henderson's user avatar
3 votes
0 answers
357 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, ...
Tinjo's user avatar
  • 113
3 votes
0 answers
13k views

Count number of rows in another list

I have two lists, A and B. I wish to find out the number of rows in list B that have a certain value in list A (through a lookup column) and display this in list A. Is this possible at all using a ...
Kris Van den Bergh's user avatar
3 votes
0 answers
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 ...
John John's user avatar
3 votes
0 answers
706 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 ...
GillouX's user avatar
  • 670
3 votes
0 answers
529 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 ...
jjczopek's user avatar
  • 1,547
2 votes
3 answers
8k views

How To Update Multi-value Lookup Column in SharePoint List using Power Automate

How we can update SharePoint list Multi-value Lookup Column using Power Automate Flow?
vandana agrawal's user avatar
2 votes
1 answer
2k views

How to retrieve lookup field value in Pnp Core in c#

I am using the Pnp Core library 1.5.0 (https://github.com/pnp/pnpcore) trying to read a lookup value in a sharepoint list. var listNameBookings = "Bookings"; var itemsBookings = await ...
Piero's user avatar
  • 278
2 votes
0 answers
235 views

Creating lookup site column with site scripts

I am trying to create some look-up columns in my site (not in the list) with site scripts. I have succesfully been able to create one: { "verb": "createSiteColumnXml", "...
shocks's user avatar
  • 41
2 votes
2 answers
2k 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 ...
Xian Hui Ng's user avatar
2 votes
0 answers
226 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 ...
Eric's user avatar
  • 21
2 votes
1 answer
910 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 ...
Morten K's user avatar
  • 1,229
2 votes
0 answers
206 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. ...
Claus Turbine's user avatar
2 votes
0 answers
136 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 ...
Scott Roberts's user avatar
2 votes
0 answers
310 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? $...
Elijah Allstrom-Luttrell's user avatar
2 votes
0 answers
91 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....
Bret's user avatar
  • 66
2 votes
0 answers
747 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 ...
Pepozzo's user avatar
  • 1,073
2 votes
0 answers
296 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... $...
Jonathan Eckman's user avatar
2 votes
0 answers
290 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 ...
Lukas Reiners's user avatar
2 votes
1 answer
99 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 ...
Zibi's user avatar
  • 29
2 votes
1 answer
120 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 ...
Steve Morley's user avatar
2 votes
0 answers
1k 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 ...
TheCoder's user avatar
  • 469
2 votes
0 answers
72 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 ...
LeonidasFett's user avatar
2 votes
1 answer
1k 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 ...
Charles Clayton's user avatar
2 votes
0 answers
192 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 ...
Maureen's user avatar
  • 687
2 votes
0 answers
86 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 ...
Skarven's user avatar
  • 151
2 votes
0 answers
56 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 ...
Daniel Watson's user avatar
2 votes
0 answers
175 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 ...
Guest's user avatar
  • 21
2 votes
2 answers
6k 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 ...
ExceptionLimeCat's user avatar
2 votes
2 answers
9k 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 ...
Geri's user avatar
  • 21
2 votes
1 answer
195 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 ...
geeeeky's user avatar
  • 123
2 votes
0 answers
111 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 ...
Michael's user avatar
  • 123
2 votes
0 answers
342 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 ...
David Weitz's user avatar
2 votes
0 answers
414 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 ...
Grzegorz Z's user avatar
  • 1,709
2 votes
0 answers
808 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 ...
kgoggin's user avatar
  • 21
2 votes
0 answers
469 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 ...
Helix's user avatar
  • 33

1
2 3 4 5
9