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.

Filter by
Sorted by
Tagged with
1 vote
1 answer
2k views

Clear multi-value lookup via Jquery SP 2013

I am trying to clear a multi value lookup field using javascript when an item is re-edited. I have tried all the following combinations without success $("input[id^='Test'").removeAttr(); $("input[...
0 votes
2 answers
2k 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 ...
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?
1 vote
1 answer
3k views

Sort Order of a Lookup Column

I am trying to sort my lookup column based on a column called sortby. I've tried an few of the suggestions, but just can't seem to get it to work. This is what I have tried and it doesn't sort by ...
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 ...
1 vote
1 answer
2k views

Lookup field value is not getting set when using Client object model

I have a document library (contact). Have created a custom list (workstatus). Have added column to contact library which is lookup of workstatus. Below is my code using which i am setting the lookup ...
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 ...
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 ...
0 votes
1 answer
2k views

Adding a many to many relationship, and having a form input data into two lists

I'm building a form for a Marketing Event list. The list would track name/type/location/date etc of the event and also those people associated with it (for example recipients or attendees) These ...
0 votes
1 answer
17 views

Options to fill the information in the lookup column of the document library after migration from SP 2013 to SPO

In my SP 2013 site I have a calendar and a document library that has a lookup column, taking values from the Title column of the Calendar. I am migrating my SP2013 site to SPO site. We used ShareGate ...
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 ...
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, ...
0 votes
1 answer
2k views

How do I send data to a lookup field with ReST? SP2013

I've been working with a jQuery AJAX call to post data to one of my SharePoint lists. One of the fields in this list is a look-up field. In forming my JSON data to push to the list I was able to ...
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 ...
1 vote
3 answers
2k views

how to lookup multiple items from one list to another and the connect results into a string

I have list "A" in which i store name, email and product. I have a list "B" which should trigger an email based on some values. One of these values is product. If I chose "car", the workflow should ...
1 vote
2 answers
1k views

Update LikedBy column through Rest Api

I am trying to update the LikedBy column in Discussion Board. LikedBy, it seems, is a lookup column. Can you let me know the what the payload would be? I will need to update the Likedby Id and Likedby ...
0 votes
1 answer
6k views

Vlookup between 2 Microsoft List

I have 2 sharepoint/microsoft list files. I want to create a reconciliation of two columns( x and y) in 2 separate files/lists(a and b) and spit out the differences into a new file or in a new column ...
0 votes
2 answers
1k views

Get list information from another SharePoint list

i have a SharePoint list called “HR”, it lists our employees and all personal information about them. On this list, I want to display whether the employee have borrowed any equipment home from the ...
0 votes
3 answers
1k 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: ...
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 ...
1 vote
2 answers
2k 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
2 answers
36 views

SharePoint - show Yes/No column from a lookup table

I have a list A which has columns ItemCode (text type) and Enabled (Yes/No type). In list B I created a lookup column to list A. I am able to show in list B ItemCode from list A however I don't seem ...
0 votes
1 answer
18 views

Link to Add item into a lookup list

Is the following possible in SharePoint Online. I have a list A. One of the columns within list A is a lookup type column to list B. What I would like to do is have an option to add a new item to list ...
2 votes
2 answers
2k views

JSON formatting column based upon added column of lookup column

I have two SharePoint lists. List one has the following columns: Productgroup (text) Min (number, percentage) Max (number, percentage) List two has columns: a lookup column for Productgroup Added ...
1 vote
2 answers
4k 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 ...
1 vote
1 answer
2k views

SharePoint Online - JSON formatted Lookup Column - Values not visible when click to edit

Issue Description: I use JSON to format a lookup column in a SharePoint Online list. I click 'Edit in Grid View'. The column value and formatting are appropriately displayed in grid view. UNTIL I try ...
1 vote
2 answers
8k 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
0 answers
13 views

Patching Lookup column

I have two tables students and subjects. Subject contains subject_id (pk) and subject_name. Student table contains subject_id which is a lookup column to Subject table. Student table does not contains ...
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 ?
0 votes
0 answers
7 views

Lookup Multi control - is there a client side JS API like SPClientPeoplePicker?

I have a Lookup field for which I am allowing multiple values, however I want the list of available options on the left side of the multi-select to be filtered by another control on the form. I can ...
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 ...
0 votes
1 answer
3k views

How to update the people and group column with multiple values in SharePoint

I have a person or group column in SharePoint 2013 I want to set the multiple values I have set its value like 1;#pallavi it's working but when done for multiple values like 1;#pall;#2;#shee it's not ...
0 votes
1 answer
3k views

Filter or populate choice/lookup column based on another list without Power Apps? Or format column based on another list?

I'm working on a project where I have a main list called "Requests". It includes a "Course" column (pre-populated) and a "School" single-value choice column. I want to ...
0 votes
1 answer
2k 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
1 answer
1k views

How can I sort a lookup drop-down list box in the Edit or Create form?

I've been developing a SharePoint site to track projects and work intakes at my job, and one thing that I can't figure out is how to sort the contents of a lookup drop-down list box. The data I'm ...
1 vote
4 answers
6k views

Add multiple line breaks to look up column in which multiple values are allowed

I have a specific question regarding line breaks in SharePoint online lookup columns in which multiple values are allowed. I would like to separate each of the values from lookup via a line break. I ...
0 votes
1 answer
1k views

SharePoint Online List Lookup within the Same List

I have only One SharePoint Online List. I want to use a Lookup using "ID" and "Prior ID" columns, in order get a Date added to the "Prior Date" Field. I want it to look like the table below. But ...
0 votes
2 answers
3k views

Filtering lookup values based on another column powerapps

I have a document library (with document sets). And while I wanted to use enterprise metatags (so I can use nested tags) the users feel that this is too much of a confusion and would like to have two ...
1 vote
1 answer
14k views

Getting the value from a lookup column in Power Automate

Pretty simple: I have a lookup column that references another list of strings (multiple selection text field). In a workflow I want to get the values from that lookup column so I can put them in an ...
6 votes
2 answers
11k views

SharePoint 2013 - Remove the hyperlink from a lookup column in a list view

I've searched the web and found a solution.... IF I WAS USING 2010 or 2007. I have cascading selections referencing two different lists that hold the dependencies as lookup columns. My cascading ...
0 votes
0 answers
40 views

How to default the value of a lookup column from another forms text field

I have two SharePoint lists. List A (Incidents), which includes an incident number, List B (Subjects), which includes a Lookup Column that uses the incident number. List B allows multiple subjects to ...
1 vote
1 answer
2k 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
2 answers
1k 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 ...
1 vote
1 answer
2k 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 ...
1 vote
2 answers
12k 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....
1 vote
1 answer
15 views

Make a lookup column in one list to show me the item that are on hand in another list

I have two list, the first one (tracker list) is a tracker or inventory of all the phones that I have on hands. Second list (request list) is for user request a phone by serial number. I want to ...
0 votes
1 answer
1k 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"...
1 vote
1 answer
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 ...
1 vote
1 answer
2k 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. ...
0 votes
0 answers
20 views

Not sure why newly created Lookup type column [Update Date] is not auto-populating

Shouldn't the lookup operation automatically create a relationship between the common [Issue Index] columns (both type Number), then populate the [Update Date] lookup column with the matching values? ...

1
2 3 4 5
24