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
0 votes
1 answer
8 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 ...
user25512953's user avatar
0 votes
0 answers
11 views

Sharepoint Rest Api Lookup Field inside site group

i'm not able to retreive the value of a custom lookup filed using rest api inside a sharepoint group site. My actual call working like this: /_api/web/SiteGroups/GetById(" + groupId + ")/?$...
David's user avatar
  • 1
0 votes
1 answer
14 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 ...
Paksos's user avatar
  • 15
0 votes
0 answers
11 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 ...
Alchemist Az's user avatar
0 votes
2 answers
25 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 ...
Paksos's user avatar
  • 15
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 ...
Dylan Cristy's user avatar
  • 12.7k
0 votes
0 answers
37 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 ...
user111103's user avatar
1 vote
1 answer
14 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 ...
Alexander Soto Acevedo's user avatar
0 votes
0 answers
15 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? ...
hic24's user avatar
  • 1
0 votes
0 answers
20 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 ...
PandoraGirl's user avatar
0 votes
0 answers
60 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-...
Anders Nielsen's user avatar
0 votes
0 answers
12 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 ...
Kelly Shaffer's user avatar
0 votes
0 answers
9 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 ...
justme123's user avatar
0 votes
1 answer
110 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 ...
Patgat's user avatar
  • 1
1 vote
1 answer
407 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 ...
Lucky's user avatar
  • 13
0 votes
1 answer
279 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 ...
Chris's user avatar
  • 409
0 votes
1 answer
44 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 ...
microsoftdeveloperdesigner's user avatar
0 votes
0 answers
41 views

REST filtering large list by lookup field value

Is it possible to search in large list by lookup filed value with 'substringof' like: _api/web/lists/getbytitle('Obchodné Prípady')/items?$select=*,Investor/Title&$expand=Investor/ID&$top=100&...
Bálint's user avatar
  • 341
0 votes
0 answers
30 views

MS Lists - Lookup

I have a Microsoft Team "Department Name", with a few channels within it. General > Holds a 'List' for all Customers and their respective ID numbers ('Customer Name' and 'Customer ID') ...
barelyben's user avatar
0 votes
1 answer
21 views

Lookup-column that looks for sites in tenant?

Is it possible to create a lookup in a list that looks for sites in the tenant? I am trying to make a project list, where each project is a new site.
Herland Bjørnsbror's user avatar
0 votes
0 answers
448 views

How to automatically populate and update a lookup column based on a condition on sharepoint?

I have 2 lists: List A: List B: I want to extract all the Projects from List A and display them in ProjectsList column in List B where: LinkTitle(List B) = Company (List A) At the end, I want the ...
Jayesh Jagtap's user avatar
0 votes
0 answers
62 views

Building 2 large SharePoint lists which have many to many relationships between them

We have 2 SharePoint lists:- Assets Spare Parts Now a Spare Part can be linked to more than one Asset and an Asset can have more than one Spare Part. Now the straightforward way to implement this ...
microsoftdeveloperdesigner's user avatar
0 votes
1 answer
185 views

Change order of additional lookup field in display form

I created lookup field with additional column at the end of creating list columns. Now I would like set another order of the additional field in forms, but when I set order of lookup column in list ...
Zbyna's user avatar
  • 149
0 votes
0 answers
45 views

Display an url image in column from a lookup

i'm struggling for several days now to create an image column comming from a lookup table. I have my main Sharepoint list with one column called Image_Thumbnail. I want user to only put an image ...
Florian's user avatar
0 votes
1 answer
362 views

Create lookup column with multi select option using Powershell

I want to create lookup column with multi select option using PNP PowerShell in SPO. I am able to create lookup field below script. But i dont know what is the property to be added to make it multi ...
Sriram Tamilarasan's user avatar
1 vote
0 answers
57 views

PowerApps - Two Lookup Columns Issue

I have a canvas app connected to a SharePoint list that contains 2 Lookup columns: Name and Code. There are about 600 line items. In the app I have these two fields side by side, and basically want ...
Chris's user avatar
  • 409
0 votes
1 answer
264 views

REST API - Get lookup IDs of lookup column on second list through a lookup $expand on first list?

I have two lists, List1 and List2. List1 has a lookup to List2, let's call it List2Lookup. List2 has a multi-select lookup to itself, as a way to identify other items in the same list as "...
Dylan Cristy's user avatar
  • 12.7k
0 votes
2 answers
388 views

Is there a way to make our SharePoint Lookup fields delegable inside Power Apps

I read many articles about how to make SharePoint lookup field delegable inside SharePoint/PowerApps. and seems if we use .Value instead of .Id for the lookup we can have delegable filtering. but one ...
microsoftdeveloperdesigner's user avatar
0 votes
2 answers
345 views

Can't get Lookup column data from list in SharePoint online

My list name is 'EmployeeData' and in that list my lookup column name is 'SectorId' and that column actual name is 'Sector'. I want title of that lookup column: https://site name /_api/web/lists/...
Kajal's user avatar
  • 9
0 votes
1 answer
69 views

Is it possible to automatically bring data with a lookup into another column?

I have a SharePoint site that I am working on and it has 2 lists that I am working with. One list is a list of vendors that my company uses and has details about the vendors. The other is a list of ...
Kyle Kidman's user avatar
1 vote
2 answers
740 views

Lookup column showing as "Required info"

I have a list that is using a lookup from another list - client name. As part of that column I am able to select "Add additional columns from source list". I have selected a couple of these ...
Kerry McIlwain's user avatar
0 votes
1 answer
497 views

SharePoint Lists - Can you Lookup a Lookup column value?

Hear me out on this one, I know it sounds silly but I am looking for a work around to this issue. We know that building a database would be the best solution, but that is a project for the future at ...
JessitarSharepoint's user avatar
1 vote
1 answer
359 views

Open Lookup Column hyperlink List Item in full window instead of modal dialog (SharePoint Online, Classic View)

I have several lists (task list, issue list, custom lists) with a lookup column to a different list. The lookup column displays as a hyper link to the other list item. However, when clicked it opens ...
boster's user avatar
  • 11
1 vote
1 answer
3k views

Item-Level Permissions in SharePoint List based on Column Value

We have a SharePoint site that will be used to handle claims and enquiries. We have three tiers of User with different permissions. All users must be logged-in to access the site: Admin Internal User ...
sambr's user avatar
  • 11
0 votes
1 answer
429 views

Key-Value in SharePoint List column

I would like to add in a column some key-values choice (multiple or not) KEY1 : "Short description 1" KEY2 : "Short description 2" KEY3 : "Short description 3" saved ...
serge's user avatar
  • 133
0 votes
1 answer
39 views

Sharepoint Lookup

I have two SP lists a source(Demo Lookup List) and a target(Demo list). The project column in Demo List is the lookup column source in Demo Lookup List giving the title values. when in edit mode if ...
Taimoor Ahmed's user avatar
0 votes
2 answers
605 views

how to retrieve lookup fields from files

I am trying to expand the following lookup fields, but I am finding it hard: /_api/web/GetFolderByServerRelativeUrl('/sites/Acts/Shared Documents/2022_1')/Files?$expand=ListItemAllFields { "...
Burre Ifort's user avatar
  • 1,339
0 votes
1 answer
352 views

too many lookup fields in the Rest API URL exceed the size limit

I have too many lookup fields which are like 40+. Using the URL format below exceeds the URL limit which I believe it is 2084. /_api/Web/Lists/GetByTitle('DepartmentWing')/Items?$select= ../Id,../...
Burre Ifort's user avatar
  • 1,339
0 votes
1 answer
37 views

Lookup Field functionality in a SharePoint Tenant

Problem: I have a request that involves a lookup field for a list that currently is housed on the same SharePoint tenant but on a different site collection. Question: Is it possible to do a lookup ...
David Lee's user avatar
2 votes
1 answer
1k views

Filter lookup column value using JSON

I have a custom list where in the Title column we have 1 to 100 numbers. This Title column we are using in the Lookup column in another list. Now while using the lookup column list, all the 1 to 100 ...
SP 2022's user avatar
  • 4,084
1 vote
1 answer
2k views

Separate multi-value lookup column values as hyperlinks to respective documents in SharePoint Library with JSON formatting

I am trying to create a document library with multiple values in a lookup field function as hyperlinks to the respective documents. By default the lookup column navigates to a details page, this is ...
nripp's user avatar
  • 13
0 votes
1 answer
29 views

SharePoint List for Lookup to Provide Values

Each technology in the Tech Portfolio List needs to be tied to one or more Business Capabilities that it helps enable. We could select Business Capabilities at different levels of the hierarchy. In ...
David Lee's user avatar
0 votes
1 answer
526 views

Schema/structure of objects returned from RenderListDataAsStream and List/fields

Modified RenderListDataAsStream request: curl --request POST \ --url 'https://XXX.sharepoint.com/sites/pilotTeamSite/_api/web/GetList(@listUrl)/RenderListDataAsStream?%40listUrl='\''%252Fsites%...
3m3sd1's user avatar
  • 11
0 votes
1 answer
115 views

Linked lists: auto-create items

We need to split up information into multiple list, which are then linked in on "master list". (sample image from internet) In the sample our master list is "Orders", "...
Der_Fab's user avatar
  • 187
0 votes
1 answer
1k views

Can we force the SharePoint Lookup field to be delegable inside Power Apps

We have a list named Large123, and inside another list we define a lookup field named ll to reference the Large123 list, as follow: but when we try to do a Lookup formula on the Lookup SharePoint ...
John John's user avatar
0 votes
1 answer
2k views

How to copy and paste values into a Lookup (multiple values allowed) column?

Environment SharePoint Online Modern Environment SharePoint List Question How can I copy/paste values such as these into a Lookup column (with multiple values allowed): LookupValue_A LookupValue_B ...
user1063287's user avatar
1 vote
1 answer
3k views

Retrieve information from Lookup field (SharePoint list) in power automate

I am trying to create an automation in power automate, triggered when a table A is edited. Unfortunately, multiples values of that table are lookups, getting their data in other tables. When trying to ...
TT-txt's user avatar
  • 13
0 votes
1 answer
1k views

How Do I Link 2 SharePoint Lists with 1 ID?

I’m assisting with the build of an intake form in power apps. Currently we have 2 separate SharePoint lists linked to the power app. The issue we’re having is with the ID column. The ID column values ...
Carter's user avatar
  • 1
0 votes
1 answer
958 views

Replicating a 'vlookup' in Microsoft Lists

I'm looking for some help with a couple of lists I'm working with. Essentially I have a main list called 'Risk Events' which has an automatically generated ID for each item, and then another list ...
Benwdj's user avatar
  • 1
0 votes
0 answers
21 views

SharePoint Lookup column with Handelbars

I am using Content query to get information from SharePoint list and display them via Handelbars template on a SharePoint SPFX Page. Everything works fine except for column defined with lookup. For ...
Marc's user avatar
  • 1

1
2 3 4 5
24