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
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 ...
PandoraGirl's user avatar
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-...
Anders Nielsen's user avatar
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 ...
Kelly Shaffer's user avatar
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 ...
justme123's user avatar
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 ...
Patgat's user avatar
  • 1
1 vote
1 answer
188 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
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 ...
Chris's user avatar
  • 391
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 ...
microsoftdeveloperdesigner's user avatar
0 votes
0 answers
36 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
23 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
143 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
35 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
96 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
28 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
215 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
51 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
  • 391
0 votes
1 answer
183 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.6k
0 votes
0 answers
20 views

How to get item id from sharepoint lookup column allowing multiple selection

How can I get the individual item id from sharepoint lookup column that allows multiple selection. For instance the data is stored as 1479 in sharepoint which would represent items id 1,4,7 and 9.
rkravitz's user avatar
0 votes
2 answers
288 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
290 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
55 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
530 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
349 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
293 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
339 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
38 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
471 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,337
0 votes
1 answer
286 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,337
0 votes
1 answer
32 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,064
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
27 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
413 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
103 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
  • 177
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
1k 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
768 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 vote
0 answers
62 views

Hidden files in Document Set Library based on custom field on SharePoint List Lookup column

I have a Document Set Library with a lookup column to a SharePoint list. Please note it is a Document SET library, not a standard Document library. The issue: Some files within a document set folder ...
Michelle McIntosh's user avatar
1 vote
1 answer
2k views

Power apps - SharePoint list lookup columns

Is there any performance issues if we use the SharePoint list lookup columns in power apps ?
Saira's user avatar
  • 598
0 votes
1 answer
127 views

Find out all places where a user ID (from the user info list) is used on a site?

Given that user fields are lookups to the user information list in a particular site, is there an easy way to find all user fields in the site that are populated with a particular user ID? We recently ...
Dylan Cristy's user avatar
  • 12.6k
1 vote
1 answer
50 views

SP 2016 Lookup Field with Rest API returning Value does not fall within the expected range

I have a lookup field that works with the .js file isn't hooked up to the form. When the .js is hooked up to the form, which I click "Save" the Promotion Name field errors with "Value ...
whahoo's user avatar
  • 21
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?
vandana agrawal's user avatar
0 votes
2 answers
291 views

Additional fields from lookup column not showing in mail notification

I setup a list with a lookup column and some additional fields from the linked list. Everything works good in the SharePoint web site (additional fields show correctly) but the notification mail I ...
Corrado's user avatar
  • 101
0 votes
0 answers
65 views

Add column to list, which shows item-level permissions

Is there a way to create a column, that shows all groups and users (SP groups and AD) that can view this item? I'm not talking about having column-level permissions as this was the only thing I found ...
workerForThePeople's user avatar
0 votes
1 answer
225 views

Lookup Category, Subcategory based on column value

I've used the Asset manager template to for a list of the companies machines. I would like to edit the Modell column, to be a lookup from another list. This list contains all models, but also a ...
Mister 832's user avatar

1
2 3 4 5
24