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.

Filter by
Sorted by
Tagged with
3
votes
2answers
6k views

Limit to the amount of values you can have in a lookup field?

Is there a limit to the amount of values I can lookup? When I search for the topic I only get hits on the number of lookup fields you can have in a list. I have tested this a bit and it was ...
3
votes
1answer
6k views

Multiple fields to same list in join (CAML)

Current situation: ============= In my example, I've got 2 custom lists: Accounts Addresses In the "Accounts"-list I've created 2 lookup columns to the "Addresses"-list Address1 Address2 When I ...
3
votes
1answer
4k views

How to sort SharePoint 2010 lookup combobox?

I have a lookup combobox whose source is another SharePoint list. By default, this combobox items are sorted by word order but I want to sort this items with another/custom order. How can I do this? ...
3
votes
1answer
1k views

Changing the sort order in a lookup field

I'm in an Office 365 SharePoint environment using a custom list. I have a lookup field that displays the title of courses. I'd like to sort it by the date of the course, but it sorts only ...
3
votes
2answers
600 views

Change Lookup Column target SharePoint 2010 manually

I have three lists A, B & C. List A have the lookup columns and existing List Template. List A have two lookup columns,which are pointing to List B & C's columns. How to edit the column in ...
3
votes
1answer
2k views

How to set image path to lookup column?

I have a custom list having lookup with a picture library. But when I am creating lookup it just gives some of the columns like Title, Created, Modified, etc. it do not gives any value like FileRef or ...
3
votes
1answer
2k views

Cascading functionality in quick edit mode in Office 365

I've sandbox solution in Office 365. I want cascading functionality of Country, State, City in SharePoint lists. I got that by using SPServices JavaScript but only in NewForm and EditForm. Want this ...
3
votes
2answers
2k views

Calculate Field with a Lookup Additional Column

Would like to ask some suggestion if i have 2 lists (Vendor List & Order List). Where Vendor List is contain with name & discount fields And i create new list "Order List" with field Items, ...
3
votes
1answer
1k views

Clear all values in a multi-value lookup, via REST, SP 2010

Conditions: SP 2010, html/javascript, using REST to read/write to various lists. Im using a jquery multiselect plugin to set a multi-value lookup column. I need the selecting Groups of items, easy ...
3
votes
2answers
725 views

Self Referencing Related Documents Library Through Lookup Column

I am trying to create a single document library that links to documents in the same library in SharePoint 2010 Server. I've created a multi-value lookup column that references the same library to ...
3
votes
1answer
2k 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 ...
3
votes
1answer
2k views

content query web part with multi value lookup column

I am trying to work out how I can query a content type with a multi value lookup field using the content query web part. I know that natively this is not possible with ootb sharepoint 2010 however I ...
3
votes
1answer
587 views

How to update metadata?

I have following code (didn't list the whole code) behind a button on a InfoPath Managed Form. and it works meaning I can submit data to a list. Now I have 2 controls on the form that is Multiple-...
3
votes
2answers
719 views

A “throttling” exception for a lookup field

I have a large list (with item count > 5000) with invoice positions, which I want to be filtered by a lookup field (invoice header ID). I tried to filter the list extending the URL, i.e.: ......
3
votes
1answer
470 views

How can we use multiple fields from an external list in a survey?

We are trying to build a survey, that uses data from an external list. It works fine for a single field. But what we would like to do is to bring about 10 fields back from the external system and ...
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
298 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
509 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
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
2answers
1k views

Get lookup from REST API

REST API url is /sites/MySite/_api/web/lists/getbytitle('MyList')/items?&$top=100 I have a lookup column called Sector in the list. How to retrieve this lookup value from the success call of ...
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
514 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
12k 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
3answers
6k views

Sharepoint 2010 - Workflow, return field as Lookup Values, Comma Delimited getting both lookup id and lookup value

I'm working on a simple workflow in SPD 2010 which is going to send an email to multiple recipients based on lookup values and even though I set the "Return Field As Lookup Values, Comma Delimited" I'...
3
votes
0answers
669 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
1answer
9k views

PowerShell script to create a list and add a lookup column

I need a Script to create a custom list and add a look up column into it and add the column into a default view. The look up column should have relationship of Restrict delete.
2
votes
3answers
8k views

Sharepoint REST API filter empty LookUp field

I'd like to know how I can filter ListItems in SharePoint rest API (2013) on empty lookup. On my list items, there is a lookup (single value, not required) and i'd like to get all items where lookup ...
2
votes
1answer
2k views

How to get Lookup ID from Search API with REST

I'm trying to get the ID of a lookup field when using search api. My query looks something like this: /_api/Search/query?querytext='ListId:12345678-1234-1234-1234-123456789012'&selectproperties='...
2
votes
2answers
1k views

How to show results of one-to-many relationship in search results?

We have a one-to-many relationship between a document library (with 150,000 documents) and a custom list storing additional metadata. We're looking to show the additional metadata from all of the ...
2
votes
4answers
8k views

Two-Way Relational List

We are testing SharePoint 2010 Standard and have a need to have relational data, but be able to view the data from both sides of the relation. For example, I have a contacts list and I create a list ...
2
votes
3answers
5k views

Content Type Hub Syndication and lookup site column within a content type

I am a content type which has to have a lookup field. I have created two exactly identical lists in hub site collection and the consumer site. Then I created the lookup site column and added to the ...
2
votes
1answer
5k views

SharePoint 2010 Rest query for Lookup fields

I am writing a REST query to retrieve data from child parent list. States is the parent list with "Title" column. LocalGovernment is the child list with "State_Territory(InternalName) and State / ...
2
votes
1answer
567 views

CamlQuery does not seem to return the value from LookupColumn

The below code work for all the Columns except for Publication which is a Lookup. The If publicationField is ALWAYS Null...ideas? // Assume the web has a list named "ADMPANewsAlertsWebAPI". ...
2
votes
2answers
1k views

Counting the number of items added in LookUp column

I have a lookup Column in my list which can take multiple values. So I need to count the total number of items added in that lookup field. What is the simplest way to do this?
2
votes
1answer
2k views

Edit Lookup table programmatically via Project Server Interface (PSI)

I have a standard lookup table database table "LOOKUP_TABLE_VALUES" in a SharePoint 2013 solution with columns like: LT_UID - for the Lookup table GUID LT_VALUE_FULL - storing the values with the ...
2
votes
2answers
9k views

infopath form not updating fields

I have an infopath form that has three read-only fields referencing items in another list, but when someone opens the form the values never change, even if they have changed in the other list. It ...
2
votes
1answer
1k views

Clear Multiselect Lookup

I am trying to add a button for my users to clear a multiselect lookup value using JQuery or Javascript. I have found some information about setting a default value on a single select lookup, but ...
2
votes
1answer
9k views

CAML query for null lookup field values

I have a problem with filtering list items using CAML I Have this list: Code - Text, Name - Text, Link - Text, Order No - Number, Parent - Lookup to this List. I want to filter all items where Parent ...
2
votes
3answers
3k views

Can someone provide examples and direction with relational list?

I'm trying to figure out the best course of action concerning relational lists. I have create several parent and child related lists but I'm having a bit of trouble understanding how to build my CAML ...
2
votes
3answers
1k views

Sharepoint2010 Lists Lookup

I'm creating 3 lists using Sharepoint 2010 UI. The lists and relationship are as follows: Training (parent) -> Training Instance (child, look up Training ) -> Training Session (grandchild,lookup ...
2
votes
2answers
1k views

Create Site Column (lookup type)

Is there any solid (proven) method of creating Site columns (lookups) where list GUID is not known? I think this is where feature activation kicks in; getting the lookup list by its name and then ...
2
votes
1answer
78 views

If statement JSON column formatting - SharePoint Online List

I'm very much new to using JSON and I try avoid it where I can. My problem is definitely lack of knowledge. I'm trying to change the color of column values based on their lookup fields. Originally ...
2
votes
1answer
1k views

Including a link to a SharePoint list item in an email

I have two lists. In one list a user enters system details which then kicks off a Workflow which then sends an email to an approver. The email has a link to the second list where the approver ticks on ...
2
votes
2answers
189 views

Is there a way to take only the value of a lookup type field

I am using a workflow where I need the value of a lookup field, My current result is : 210;#AA8888AA It needs to be: AA8888AA Is there a way to take only the value using SharePoint Designer or I ...
2
votes
2answers
27k views

Use a LookUp field in a Calculated Column

I have a SP2013 Server but have not been authorized to install SPD2013. I have a list [Web Team Tasker] which has a lookup column containing data from a list on a parent site as well as some ...
2
votes
2answers
5k views

Drop down lookup field search

I've got the following scenario: List A contains several thousand items, List B has a lookup field to List A. When a user is creating item in List B she has to select the List A item via the mentioned ...

1 2
3
4 5
21