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
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 ...
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 ...
0 votes
0 answers
13 views

Auto-populate column with data from another list based on another column choice

I have two lists (Suppliers and PO's). When someone fills out the PO form I want the Supplier ID column to auto-populate based on the chosen Supplier Name. I tried using a lookup column but the ...
0 votes
0 answers
20 views

Get-PnPListItem exceeds the lookup column threshold

We are having some issues querying some lists and libraries and I'm afraid we have stared ourselves blind on the matter. We run the following cmdlet and it throws an error: $listItems = Get-...
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
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 ...
0 votes
0 answers
7 views

Lookup field converting text to numeric value

I have a Library with documents that I need to index: File X has attributes such as first name, last name, location, ID, etc. I added a lookup field so when I enter in a last name, it will look on my ...
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 ...
1 vote
3 answers
5k 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 ...
2 votes
2 answers
8k 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 ...
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
0 answers
5 views

Lookup field requires value even though it and the lookup list are set to not required

I have two lists and one field is a lookup to a field in the other. At one time, the list being looked up had "required" turned on. Even though I am certain it's turned off in both lists ...
0 votes
1 answer
5k 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 ...
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 ...
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 ...
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 ...
2 votes
1 answer
194 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 ...
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: ...
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
1k 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 ...
0 votes
1 answer
69 views

Problem on JSON formating with a connected field of a lookup Column

In my List A I have a lookup column "CODE PROJET" and one connected lookup column "FIN RECONDCT" both coming from an other SharePoint list B. On a field of the A List I try to do ...
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?
1 vote
1 answer
6k views

SharePoint Online: Using JSON Column Formatting to get lookup column value inside Form

I am trying to create a link using JSON column formatting that helps users send an email (it's an anchor element with 'mailto'). The email parameters (the recipient and email body) need to contain ...
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
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
2k 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 ...
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
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 ...
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 ...
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
1 answer
1k 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 ...
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
1 answer
13k 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 ...
1 vote
1 answer
186 views

How to get lookup column value in single line of text

I Want to display lookup column values in single line of text. ProductName lookup column with multiple selection. I tried using JSON column formatting but values are not showing. Please can anyone ...
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
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
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
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
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. ...
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[...
1 vote
3 answers
29k views

How can i create cascading dropdown Lists in SharePoint?

I have created a list on my SharePoint page with multiple dropdown menus when a new list is created. However, I was wondering that when an option is selected in the first drop down menu, if there was ...
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
7k 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 ...
0 votes
1 answer
105 views

PowerApps SP Form - Referencing List item value in another List

I have a strange situation, and I was hoping for some advice. Basically, I have a PowerApps List Form (Customized SP form in PowerApps) that contains several fields, including a Lookup field to ...
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 ...
0 votes
1 answer
30 views

Build relation between SharePoint lists. should we use SharePoint Lookup fields or store the ID inside a number fields

I have built those SharePoint lists for our Mini CRM project:- Departments Projects Tasks Assets The relation between those lists is as follow:- Each Project is linked to a single Department ...

1
2 3 4 5
24