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.
395
questions with no upvoted or accepted answers
6
votes
1answer
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 ...
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
161 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
518 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
532 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
2answers
526 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 ...
4
votes
0answers
756 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
1k 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
316 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
0answers
515 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 ...
3
votes
1answer
68 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
60 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
734 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 ...
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
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 ...
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
686 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
505 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
582 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
182 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
543 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
198 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
125 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
836 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
215 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
78 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
739 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
166 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
277 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
94 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
75 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
749 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 ...
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
1answer
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 ...
2
votes
0answers
179 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
75 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
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
161 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
5k 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
183 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
100 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
328 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
1answer
487 views
Filter a parent list by a particular child list item's lookup field value
I have two lists, Activities and Objectives. The Activities list has a multi-value lookup field that references the Objectives list.
I am trying to create a filtered view on the Objectives list that, ...
2
votes
0answers
799 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
459 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 ...