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
92 views

Lookup items says “Count Related”

I am not very skilled with SharePoint, but I have been tasked with using it on a daily basis, and am always at least "trying" to make improvements to it. The issue I am having today is that I have 2 ...
1
vote
2answers
1k views

Cascading Dropdown for Lookup with more than 20 items

I have implemented cascading dropdown using SPCascadingDropdown (SPServices) it was working for lookup with 19 items . When the items count became more than 20 , the lookup column is displayed as ...
1
vote
2answers
318 views

SharePoint Best practice for multiple images per list item

I have to create a simple Classifieds system in SharePoint. One classified item can have multiple images. Does anyone have suggestions on design for this initiative? For example, should I have a ...
0
votes
1answer
64 views

Is it possible to create an automatic connection between the look up field and another column?

Im struggling with a problem in SharePoint 2013. I have one list with procedure codes, which includes the “procedure code” plus some other fields In another table, i have volume data related to ...
1
vote
2answers
211 views

Save Document library lookup field using Rest API

How can I save document library lookup field using REST API Post in a SharePoint list? I tried like 'docItem':'1;#test' But, it is throwing an error : {"error":{"code":"-1, ...
0
votes
0answers
40 views

Weird lookup column issue

I have process that I setup to summarize a list in a lookup column in another list and to automatically generate emails based on the lookup column. I noticed that things weren't behaving quite as ...
0
votes
1answer
388 views

Using additional fields from Lookup in Word Document Information Panel

I have a Document Library in which I have a lookup columns to a Contact list, the contact list also includes linked values as email, phone numbers and so on. When creating a new word document in ...
0
votes
0answers
167 views

How to create a filtered list on Lookup columns

I have created a couple of custom lists, one called Partners, the other named Countries. The Countries list is populated with a list of the world's countries. The Partners list is a list of our ...
1
vote
1answer
80 views

Client API lookup field: LookupId has a value but LookupValue is null

I'm doing something very similar to this question; trying to get the value of a lookup field using the Sharepoint .NET client API. I can get the Id, but not the value. For some reason, the value is ...
1
vote
2answers
484 views

add a new value to a lookup field

I have a custom list in SharePoint 2013. This list contains text and lookup fields. While I do not have an issue populating the text fields, the lookups are giving me trouble. I found and tried ...
7
votes
3answers
237 views

Working around the “Lookup column threshhold”

To level-set, I'm working in a large enterprise with no Farm Admin access or access to SP Designer. I have out-of-the-box capabilities only as owner of a team site. I'm building a roster/schedule ...
2
votes
3answers
830 views

Binding lookup fields to document library template

I have features that define site content types and a document library template that uses these content types. Now, when I create a document library from the template, all the content types appear ...
0
votes
2answers
4k views

How can I combine multiple Lists into one view for editing

I had a list with 18 lookups which exceeded the SharePoint 2010 threshold. So I broke it up into 3 lists all having the same "ProjectID" column as a lookup to the first column so that there is only ...
2
votes
2answers
2k views

Is it possible to have a lookup field with multiple source lists?

I have two lists: list A and list B. List A should have a new multiple choice lookup column that allows the user to choose items from both list A and list B. Is this even possible? I have a kind of ...
2
votes
1answer
132 views

Filtered lookup column with 'WHERE' clause

I have 2 lists: List 1 and List 2. List 1 has 2 columns 'supplier' and 'broker'. List 2 has 2 columns 'nature' and 'supplier name'. My requirement is 'supplier' is a lookup from 'supplier name' ...
2
votes
2answers
1k views

SP 2013 - Updating a multi-value lookup field via the REST API

When adding a new item to list via the Sharepoint 2013 REST API I want to populate one of its multi-value lookup columns. I've tried passing in an array of Ids or a string with separators but nothing ...
0
votes
1answer
73 views

Calculated Lookup from another Lookup

I'm sure this has probably come up before but I'm getting nowhere fast so I thought I'd ask the question! I have a list called Areas, which has an Area column (text). I have a second list called ...
1
vote
1answer
245 views

During ItemAdding of parent list, assign lookup field of a child list

I'm attempting to create a projects/tasks lists. When a user creates "ProjectA", I want to create a list of tasks based on the template that was selected for that project. In general, everything is ...
1
vote
1answer
83 views

Example of a workflow pulling lookup column data for use in a calculated value column

I'm looking for an example of a workflow using SharePoint Designer 2010 that pulls information from a lookup list or via a lookup column and places it within a hidden field for use in a calculated ...
3
votes
1answer
2k views

Help with getting the value of a look up field

Currently, I am using an ajax request to access the list items. The fields that are not lookups come as expected but the lookup fields come across as an ID of the object that corresponds to its ...
2
votes
0answers
101 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
3answers
2k views

Can a SharePoint 2010 lookup column point to a multi-line rich text field from same list

Can a SharePoint 2010 lookup column point to a multi-line rich text field in same list? i dont find multiline column while creating a lookup column. Is there any way to achieve this. Because my ...
5
votes
3answers
6k views

Deploying List Instance - LookupMulti Type Column in XML

So I have been able to populate rows with Lookup type fields as such: <ListInstance ... > <Data> <Rows> <Row> <Field ...
1
vote
1answer
2k views

How to Find Lookup field list using Programmatically

How to find the list that a particular lookup column in a list is bound to, programatically?
1
vote
2answers
6k views

How to get multivalue lookup column items from sharepoint list to infopath?

I am on a project. I have a list that have 2 columns. One is the title, other is a multiple value look up column from another list. Everything is ok, working well. And call it ListA. BUT, i am ...
2
votes
1answer
296 views

Uploading a file to a library with curl - how do you also update the column values

I'm able to upload files from linux to sharepoint using something like this curl -u "Domain\Account":'Password' --ntlm -k -T report.xls https://portal.company.com/test_site/test_doc/ I would ...
1
vote
0answers
18 views

Display deactivated items in lookup column

We have a list of projects. One column is named Status (a choise Active or Finished) One column is Active Projects (a calculated column which shows only the actieve projects) One column is named ...
1
vote
3answers
831 views

Get value of lookup field

I have a cascading lookup using two lists on my SharePoint 2010 site. I want to get the value of first selection made in the lookup and show/hide other fields on my custom form based on that first ...
2
votes
2answers
1k views

Copy lookup value from one list to another with SPD workflow

I have two lists and a workflow that copies items from list A, if they get approved, to list B. Problem is that a field in list A uses a lookup list, if I select Dog in the Field Animal and save the ...
1
vote
0answers
254 views

Site Lookup Column As Managed Property

Please let me know if my logic here is incorrect or suggest better alternative. This is hosted on Office 365. I have a Site Lookup column (EventLookup) that is linked to a list on my Root Site --> ...
0
votes
2answers
238 views

Lookup field not updating when the document uploading

I am uploading document programically and passing lookup field value but its not get updated, how to handle this?
0
votes
0answers
56 views

I can't change the “Return Field As” in SPD for a “lookup” type column

I recently used this topic to help me create a WF that creates a new discussion item every time a new issue item is added to the issue tracker, however I ran into a small issue when changing the ...
3
votes
1answer
731 views

CAML Query on a Lookup Field that points to a Calculated Field throws Exception

I wrote some CAML Queries to get data from a List that has lookups on another List. All is working fine as long as I do not reference a Lookup Field which points to a Calculated Field. I tried ...
2
votes
1answer
187 views

Lookup field doesn't support some field types

Its looking more and more like you can't add additional fields that are anything other than string boxes (no person or yes/no etc) is there any work around for this?
0
votes
1answer
276 views

Conditional formatting lookup column

I am attempting to do conditional formatting in a list view in SharePoint Designer. In this list I have a list that contains a lookup column, and other columns derived from the list of that lookup ...
1
vote
1answer
706 views

Extending Content Types from Content Type Hub

I have defined a content type in content type hub. I would like to use this content type on a site (other than the hub) but also to extend it with an additional (lookup) column. Is it possible to do ...
0
votes
0answers
67 views

Load a SharePoint list into a workflow variable?

I am trying to use a workflow to lookup data in a column in a list and then compare that data in another library column then update another column in the library based on if it equals eachother. ...
1
vote
0answers
131 views

how do I create search in sharepoint list edit form using infopath

I have a list called Tasks in sharepoint 2013 that has a number of lookup fields. It was initially created by exporting data,tables and relationships from Access 2013. The client wants to be able to ...
1
vote
0answers
188 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, ...
0
votes
1answer
2k views

Bind lookup column with another subsite list

I have a site "ABC Company" in which I have two subsites. HR Inventory In HR subsite there is a list "Employee" which has a column "Full Name" In Inventory subsite there is a list "Issue ...
1
vote
1answer
328 views

InfoPath form referencing fields from another list

Environment: SP2013 Enterprise, InfoPath 2013 I'm building a course registration system for a SP client but am having a little difficulty with lookup fields. Basically there are two lists, a course ...
0
votes
0answers
56 views

Workflow to Update Library Column with Data from List

When creating a new item within the library I want a workflow to lookup a field in a list and if it equals a column in my library I want to update another column in my library. The field I need to ...
2
votes
0answers
159 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 ...
1
vote
1answer
671 views

Modifying XSL for multi lookup field

I'm trying to create custom XSLT for a multi lookup field, based on this article. When changing disable-output-escaping to yes I can see the html I want to modyify: <a ...
0
votes
2answers
332 views

Hide link in Listview on Lookupfield

In my customList there are several lookups. They link to the sourcelists. My question is: How can I hide these links?
14
votes
2answers
865 views

When deploying a site from custom site template, one lookup column in doclib has empty values for Office 2010 (docx, xlsx, pptx) files

I'm deploying sites using a custom site template (WSP) that is: Saved as WSP from customized Team Site Deployed as Farm Solution Has lists, libraries with content customized in Visual Studio ...
0
votes
1answer
247 views

What is use of LookupMulti in Sharepoint 2013

Can somebody tell me what is the use of LookupMulti in Sharepoint 2013 and how to implement this with visual studio 2012? Can we use this for chaining purpose ? For example, I have 2 lists country ...
1
vote
1answer
573 views

Is it possible in LINQ to SharePoint

I have a task to make a WSP, which should provide definitions of custom list and library, but not instances. List definition has a lookup column to library item <Field ...
1
vote
1answer
363 views

SharePoint 2013, Lookup field cross-Web

It looks like I found pretty annoying bug in SharePoint 2013. Can anyone confirm this? Create site-column lookup to list placed on rootWeb (I will refer to it as WebA), the title should be used as ...
0
votes
0answers
136 views

Get Items Lookup Mult timeout

I have a list with many records , and when I'm doing a filter for a column that is Lookup Multiple runs smoothly : Example <Where> <Eq> <FieldRef Name='Column' ...