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
1
vote
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 ...
6
votes
2answers
3k 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 ...
0
votes
1answer
26 views

How to view a list item and its linked items in simplest way?

There is one list Clients, and another list Projects. Latter is linked to Clients by looking up Clients ID column. Now if I am in Clients list page, how can I click one client row and somehow display ...
1
vote
2answers
830 views

Retrieving Lookup Values, Javascript SharePoint 2013, Not Working

I've seen a lot of info on the above question but none of it has answered what I'm looking for, so far. I'm trying to retrieve list items that have a great number of lookup fields. I've had success ...
0
votes
3answers
653 views

CAML Lookup - get different value from lookup list using query

Say I have two lists: Support Pack ID : 1, SupportPackTemplateLookup:(ID#OtherValue), IsActive : True Support Pack Template: ID : 1, OtherValue: x, SuppType: 10 hr support pack ID : 2, OtherValue: ...
1
vote
1answer
37 views

Display value of lookup fiels on webpart

I am beginner on SharePoint framework and with TypeScript. My problem is I have a list that contains a lookup type field "categorie", When I try to get the records from the list with rest API, the ...
0
votes
3answers
208 views

Lookup column agains list with more than 5000 posts

I am new to SP online. This is about a lookup column that displays data from another list which is currently exceeds the 5000 items limit? Any easy solution as I dont have much programming ...
0
votes
2answers
636 views

Add column (lookup field) to another site

I create a column "LookUpValues" of type LookUp in Site A but I'm trying to add from existing site columns in Site B but it doesn´t show up. Is it possible to do it? Any ideas?
0
votes
1answer
20 views

How To insert field of type lookup in the SharePoint List

I have a list with name Product Catalog and there are two lookup fields with name Country Preference and Location Preference one date field and multiselect field. I tested with list name without any ...
0
votes
1answer
636 views

The lookup that you defined is not guaranteed to return single value

Error: The lookup that you defined is not guaranteed to return single value. If more than value is returned only the firs value will be used How to return multiple values from a lookup column?
0
votes
1answer
619 views

How to submit multi-checkbox items in a formatted string to SharePoint lookup column

I'm new to InfoPath and SharePoint and i also use the trial version of qRules, i have 2 sharepoint lists, with one (let's call it "list1") having a lookup column to the second ("list2"), and this ...
0
votes
1answer
31 views

Document Lookup Column

all, In SharePoint Online I have a doc library (Reference Docs) and a list (Projects). The goal is for users to choose a doc from a lookup drop-down in Projects, which, when clicked, will directly ...
0
votes
1answer
600 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 ...
0
votes
0answers
17 views

SharePoint Online Lookup Column lagging

It started about a week ago, and it only has about 50 items. what is the best approach to tackle this. Thank you in advances.
1
vote
2answers
2k views

How to get the value of Person field and Lookup field depending on ItemID using Javascript/Jquery?

I have a form where I have a lookup field displaying issue ids of same list. On selection of Issue id, Person field (Issue Assigned to) and other Lookup field (Function) to be prefilled. I have ...
0
votes
1answer
632 views

look up column error

I am getting into a null array - $spList = $webobj.Lists["Studentlist1"] Exception calling "update" with "0" argument(s): "This lookup field cannot enforce a relationship behavior because it is not ...
1
vote
2answers
321 views

Expand Multiple Lookup field with Microsoft Graph

How can I Expand a Multiple Lookup field with Microsoft Graph. I need to get all fields from a multiple lookup field. Thanks.
0
votes
0answers
27 views

Sharepoint Online cross site lookup schema.xml for field extension

I try to create a cross site Lookup field extension for Sharepoint Online. The Field extention is working perfectly, as long as both lists are at the same Website but I need it to work cross site. ...
1
vote
0answers
23 views

How to create a recurrent event where every instance is individually modifiable

I have a calendar web part that is associated to another list (Projects). Now, each event in the calendar web part has a lookup column from the "Projects" list. My problem is that when I create a ...
0
votes
1answer
726 views

SharePoint Error Invalid look-up value. A look-up field contains invalid data. Please check the value and try again

While trying to update a value in pages library, I am getting below error: Invalid look-up value. A look-up field contains invalid data. Please check the value and try again. This is happening for ...
0
votes
1answer
17 views

Lookup column allow multiple values warning

I am working in SP Online modern UI. On one of the libraries, after checking on "Allow multiple values" for a lookup column field, I am seeing below warning in red. can someone assist, i have not ...
0
votes
2answers
605 views

Calculate value based on choice column and value in other list

In list A I have three columns; Currency, Value and USD value. In list B I have two columns; Currency and Exchangerate. The currency column is a choice column and based on this column I want to ...
3
votes
1answer
621 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 ?
0
votes
1answer
597 views

How to copy choice column values to lookup column values

I am using sp 2010. I have a column from type "choice" and is multiple. I have created a new column from type lookup field. Also this lookup column is multiple. I already have migrated the values to ...
0
votes
3answers
625 views

How to delete Lookup columns

I have a list with more columns in SharePoint Online 2010. When I am making the extraction to Access or Excel, I have some columns which do not appear in my list of columns I created. I can see them ...
0
votes
0answers
9 views

Lookup columns referencing Source variation site Ids in sharepoint 2016

I am using Variations feature in Sharepoint 2016. I have a lookup column for a list in my Source variation site. Now I am popagating that list in my target variation site. The list is getting ...
0
votes
1answer
41 views

Set-PnPField -Values @{DependantLookupInternalName=??}

Hello SharePoint Peoples, So I am trying to figure out how to use a lot of the PnP Commands. Getting hung up on Set-PnPField. I have a column already created, and I can Get-PnPField and read it's ...
0
votes
1answer
26 views

An unexpected 'PrimitiveValue' node was found when reading from the JSON reader

I am getting this error while trying to post data to SharePoint list. It has one lookup field PostCategory. {"readyState":4,"responseText":"{\"error\":{\"code\":\"-1, Microsoft.SharePoint.Client....
0
votes
1answer
747 views

Can a workflow populate values in a lookup field for all the items in the list?

I have a list called Contacts, with 4000+ entries. It currently has a dropdown choice column with four specified values for different offices (MAO, NHO, MEO and CTO). I want to convert this dropdown ...
1
vote
1answer
27 views

Auto populate a lookup field with multiple entries after selecting multiple entries from a lookup

Please excuse me for the vaugness, required due to the type of work. I have a list that indicates upcoming work on various items. When the work is finished on those items, drawings need updated. As ...
0
votes
1answer
787 views

Restricting number of selections on a multiple lookup column

How can I restrict the number of values a user can select from a lookup column? It doesn't seem to have the same column validation settings as some of the other column types. I only want a user to be ...
0
votes
2answers
45 views

Why I can't get Lookup Column ID from Source List by Flow?

I have a question about Flow for Sharepoint List. I have 2 Lists, and one of them has a lookup column to another. List 1: Currency List (Target List) List 2: Price Table (Source List). I want to get ...
1
vote
2answers
745 views

Update Lookup Column with Multiple values using Designer Workflow in SPO

In SP Online using designer workflow,I am trying to update a lookup column(with multiple values enabled) from another lookup column(with multiple values enabled).Both lookup columns are in different ...
0
votes
0answers
7 views

Lookup Via Sharepoint Designer

I have two list. One List (EMP) Where i have EMP ID and EMP Name, another list(EMP Details) where i have EMP Details (Like, EMP ID, EMP Name and etc). I want when any new item add in EMP list, based ...
0
votes
1answer
802 views

How to add hyperlink from other list with lookup

I gave up. The task looked simple: I have a list with clients with 2 columns: clientname, clientid, URL. I made another list where managers could collect clients from this list that they frequently ...
1
vote
1answer
68 views

Using Flow to get Lookup Column Value and use these Value to calculate

I am setting a Flow that can get the value of lookup column for using in Calculated Column. My List below: List A: Target List, contain Currencies and Exchange Rate to VND (Called exRate) of the ...
0
votes
1answer
704 views

How Do I Format A SharePoint 2010 Search Refiner Lookup

In SharePoint 2010 Search, I've added a new managed property that refers to a lookup column. I then added a custom refiner by modifying the Refinement Panel "Filter Category Definition". Basically, I ...
0
votes
0answers
16 views

Indexing lookup column in SP2019

I am working on a project where a document library is about to exceed threshold and lookup column is one of the metadata columns being used in the library, I am working with SP2019 on prem. The ...
0
votes
1answer
44 views

Replace HTML list values with substring on SharePoint 2013 Custom List Field

I'm using SPAutocomplete from SPServices because I have a requirement to make a searchable lookup field rather than an OOTB lookup field (drop down menu), as there is potential for thousands of values ...
1
vote
1answer
748 views

Create a LookUp Column using SPServices “UpdateList” operation

I want to dynamically add a new list ("AddList" operation), and then use the SPServices "UpdateList" operation to add "newFields". I was able to get the "Text" fields to add properly, but the LookUp ...
0
votes
1answer
814 views

Lookup column added to list created by importing Excel spreadsheet not working

I have a list on a site that was created by importing an Excel spreadsheet. I have several lookup columns that were deployed to the site using a feature. Going into the site columns gallery, I see ...
0
votes
1answer
1k views

Link two SharePoint lists and edit at the same time where one list can have multiple items per one item on the source list?

I have two sharepoint lists. The first, LIST1, is a location listing with a unique plant code to each. The second list, LIST2, is a list of contacts with a column that ties back to that plant code. ...
1
vote
2answers
176 views

Lookup field deployed through feature can't be added to new list

I have deployed a number of fields, content types, and list definitions/instances to a site through a couple features. The fields and content types are deployed through a Site scoped feature, and the ...
1
vote
1answer
855 views

Validate text column against [Me]'s Display Name

I have two lists in SharePoint 2013 Trips Drivers Drivers has a column called Active Driver that is a single line of text formatted "Lastname, Firstname". Drivers also has a separate column that is ...
0
votes
1answer
827 views

Access Lookup to Linked List

I am trying to create a lookup from one Access table to a linked list from SharePoint. I need to have a lookup between the two because in order to create the type of subform that I need, there has to ...
0
votes
1answer
18 views

Multiple Cascading Delete

I have 3 lists, lets say A, B, and C I have a lookup in a column from B to A I also lookup in a column from C to B. I have the column lookups in B and C as Cascading Delete. If I delete A, I know ...
0
votes
0answers
29 views

Can I lookup what a lookup column looks up?

To explain the concept, let's pretend I wanted to make lists of cocktails and ingredients. First off, we have a list of ingredients (gin, rum, campari etc.) and columns of relevant information (cost, ...
0
votes
4answers
5k views

Is it possible to have a lookup field with autocomplete feature

I have defined a lookup field with multiple values over a contact list inside my SP 2013 team site, and by default I got a select list as follow:- So is there a way to have the lookup field with ...
1
vote
1answer
1k views

Get value automatically similar to Excel's vlookup function

I want to get data from another list automatically based on a column from this list. Let's say the source list shows the ID A, B, C and the related values 1, 2, 3. In my list I show in a column one of ...
0
votes
1answer
989 views

copy one column value to another column in a list

I have a list named ABC in MOSS 2007 List has 2 Views (All Details and Multi Location) 2 columns (BA-tech and BA for both views) BA- tech field is "Single line of text" type and BA field is "Look up"...