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
18 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 ...
user avatar
  • 12.2k
0 votes
0 answers
8 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 ...
user avatar
  • 1
1 vote
3 answers
54 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?
user avatar
0 votes
2 answers
43 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 ...
user avatar
  • 101
0 votes
0 answers
16 views

Share point Online search managed properties lookup column

can we scrawl lookup column ? I have a requirement , lookup column should be scrawled in SPO in order to expose a List text value through Azure API , I have created a list and a site column (Lookup ...
user avatar
0 votes
0 answers
32 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 ...
user avatar
0 votes
0 answers
21 views

How would you write some html code, in a basic SharePoint page table, that pulls a count from a SharePoint list on the same website?

So, I made a table that I am hoping to insert some kind of code into each cell that can pull some information from various SharePoint lists. I have some SharePoint lists that have item counts based ...
user avatar
  • 1
0 votes
1 answer
21 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 ...
user avatar
0 votes
0 answers
9 views

Automatic referencing vice-versa from lookup-fields from one list to another on the same site

we started to attach multiple items (e.g. technicians) in a lookup-field within one list (e.g. customers). What is the fastest way for automatic referencing vice-versa from these lookup-fields? For ...
user avatar
0 votes
0 answers
7 views

create and manage the relation between Project and Task lists inside SharePoint and Power Apps. where a task can be assigned to multiple projects

I have 2 SharePoint online lists:- Task Project where a task can be associated with zero,one or multiple projects Now if i were building this according to the book, i will create the relation ...
user avatar
  • 948
0 votes
1 answer
80 views

How to Automate Percentage Complete on Sharepoint List when answers are text

I have a sharepoint list I am trying to figure out how to utilize power automate and flows to calculate a percentage score column that runs an initial calculation and then updates as new selections ...
user avatar
0 votes
0 answers
46 views

Best appraoch to build a Parent/Child lists inside SharePoint and manage the relation inside Power Apps

I have 2 SharePoint online lists:- Customer Project. Where each project will be assigned to one and only one customer, here is the Project create/edit form:- So i am not sure how i can build the ...
user avatar
  • 948
0 votes
1 answer
171 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 ...
user avatar
  • 258
0 votes
0 answers
20 views

correct way to join lists

Huge chance of being a duplication - apologies. I have two Lists, like: List A: Code Name A1 ABC A2 DEF A3 GHI List B: Code Name B1 ABC B2 DEF B3 GHI There are specific relationships between ...
user avatar
  • 1
0 votes
1 answer
18 views

Getting the ID of a lookup column?

I have a list which has a lookup column in it. "Subcats" has a lookup to "Cats". If I do an ajax call like this url: _spPageContextInfo.webAbsoluteUrl+"/_api/web/lists/...
user avatar
0 votes
1 answer
34 views

How to get multi selection look up value in Power BI report?

I am new in Power BI and working on creating a simple report. I have 2 list - "Country" and "Test" which contain invoice amount. Country is multiselect look up in Test list. I need ...
user avatar
  • 1,126
1 vote
1 answer
227 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 ...
user avatar
0 votes
1 answer
30 views

Arrange lookup items in a list in SharePoint Online

I have a master list with only Title column only. It is having 100 items. Few values are:- Communication Not Applicable Operation Now, I need "Not Applicable" either at top or at end for ...
user avatar
1 vote
2 answers
173 views

How to use expand in rest api to get child list records

We have 2 lists. List A is the parent and List B is the child. I want child record details when I am querying to the parent list. Current API: https://url/_api/web/lists/GetByTitle('ListA')/items?$...
user avatar
0 votes
1 answer
34 views

Sharepoint 2013 List Relationships for Choice Column

I'm working on a 2013 SP site and do not have the ability to use any program with any cloud based capabilities, or Designer because it'll be obsolete. I have two lists. One of the columns overlaps ...
user avatar
  • 1
0 votes
1 answer
444 views

Update multi-value lookup column with Flow

I have two list: Item List: contains beside the item name a column "item short" with a shortened string as our internal item registration text. Main list: used like an inventory list. The ...
user avatar
  • 129
0 votes
1 answer
28 views

Prefilled new item with dynamic value

I need to click on new item and the employee field to be prefilled with correct employee I added this functionality using a code in modern part editor but when I click on cancel button a new empty ...
user avatar
0 votes
1 answer
16 views

Lookup Column for Doc Library

I have a library where users upload trainings for different teams. Each team has a different set of training so as of now, the training dropdown for the Training choice field is so much to scroll ...
user avatar
  • 103
0 votes
0 answers
143 views

How to display lookup values as plain text without making them invisible in the drop-down?

I have a few lookup columns in my list that, a few months ago, were working/displaying correctly. I don't believe anything has changed on my side, but I may be wrong... in any case, when I open up the ...
user avatar
  • 114
0 votes
0 answers
12 views

User Names Appearing Incorrectly

Was seeking some assistance on names appearing incorrectly on our SharePoint Online 2013 list. The field is a 'person' lookup, and names have started appearing with 2 commas between the first and last ...
user avatar
  • 1
0 votes
1 answer
440 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 ...
user avatar
  • 114
0 votes
0 answers
40 views

Format SharePoint Online List row based on multiple conditions in same field using json

From the code below, the [if(length([$Employee.lookupValue]) == 0, 'ms-bgColor-red'] portion changes a row to ms-bgColor-red if the field is empty. How do I extend this condition so that, in the same ...
user avatar
0 votes
1 answer
129 views

Nested lookup columns in a list

For some context, I work within a small design team who cover the whole of the UK. Our business also offer installation services, with various offices around the country. I have a list, Projects, ...
user avatar
0 votes
1 answer
67 views

Remove Trailing Zeros from Sharepoint List Lookup Field that is based on a Calculated Field

I have two Sharepoint Lists, one of which has a Primary ID field that is a Calculated Field that simply equals the Sharepoint generated ID field. Table 2 has a Lookup field that pulls in this new ...
user avatar
0 votes
1 answer
71 views

Strange error on GetItems. Missing parameter depending on Item

Given: 2 lists (1 calendar, 1 custom list). Calendar has a lookup column to custom list. Within a flow I want to retrieve all items from the calendar which have the lookup column set to a certain ...
user avatar
  • 171
1 vote
1 answer
382 views

Column with lookup doesn't show the selected list columns

I am having a trouble with lookup column from one list to other list, the columns are not showing in selection. I have list called Business Case and list Status report, I would like to add some of the ...
user avatar
  • 23
0 votes
2 answers
284 views

Format SharePoint List row based on empty column using json

How do I extend the solution provided here to highlight a row if, say, column "LookUpColumnABC" is empty? I tried incorporating if([$LookUpColumnABC] == '', if([$LookUpColumnABC] == "&...
user avatar
1 vote
1 answer
100 views

How to remove HTML in email output generated by Power Automate for lookup columns

My Power Automate solution produces the desired values except I can't figure out how to remove the HTML metadata in the email output. Instead of: {"__metadata":{"type":"SP....
user avatar
0 votes
2 answers
408 views

Row formatting based on a LOOKUP column value in modern SharePoint List

Modern experience SharePoint List A has a LookUpColumn that retrieves values from NumberColumn in ListB. I need conditional formatting that applies a color across an entire row based on a value in the ...
user avatar
0 votes
1 answer
32 views

Multiple search on column

I have one list - List 1 with 3 columns (ID, Name, Surname), and another one - List 2 with lookup column connected to ID, but I need the search to be able to work with name and surname columns too. ...
user avatar
1 vote
1 answer
103 views

Grouping, Summing, Filtering to join two SharePoint lists together in a Collection in PowerApps

I am creating a PowerApp that uses two SP lists: PowerAppCalendar1 (An actual calendar in SP). One added field is Capacity TrainingAttendees - the folks who want to join a class use this list This ...
user avatar
3 votes
1 answer
265 views

What limitations should I keep in mind when choosing between single line of text or choice columns?

I have a SharePoint online list that will be populated with data from a Form (MS Forms) via Power Automate. I have some choice (single select, multi-select and yes/no) fields in the form, but before I ...
user avatar
  • 114
0 votes
1 answer
29 views

For managing/storing relation between 2 LARGE sharePoint lists, should we use lookup fields or Single line of text field

I have 2 SharePoint lists; Parent list & Child list. Now inside the Child list i need to store the Parent ID. and seems i have 2 approaches:- Use a Single Line of text to store the Parent ID Use ...
user avatar
  • 948
4 votes
2 answers
280 views

Lookup column which reference a list that have 2 million records is not working, the lookup keeps loading forever

I have a Parent list which contain over 2 million records:- and inside another list (Child list) i have a lookup field which reference the above parent list, as follow:- and inside the Parent list i ...
user avatar
  • 948
1 vote
1 answer
11 views

Unable to show the lookup field in datagrid view using CSOM sharepoint online

private void btnGetdata_Click(object sender, EventArgs e) { try { string WebUrl = this.listUrl.Text; string lib = this.txtLib.Text; ...
user avatar
0 votes
1 answer
42 views

LookUp Column Not Returning Values from Referenced List

I have two lists, A1 and B1. A1 has and "Entity" column and the rest of the columns are user details. A1 Example: Entity column = Starbucks.. Rest of columns = Name, Request Date, Email, ...
user avatar
  • 1
0 votes
0 answers
23 views

Find Sharepoint lookup field source URL in different web using javaScript

I have a need to get information about a lookup column in a SharePoint list. The lookup column is a site column that lives in a top level site collection (there could be one ore more of these lookup ...
user avatar
1 vote
1 answer
519 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 ...
user avatar
0 votes
1 answer
71 views

Why using this REST API /_api/web/lists/GetByTitle('Mobile Device Request Form')/items(1473) will not retrieve all the fields

I have the following columns inside a SharePoint Online list: But when I tried to query an item using HTTP request, using this URL: https://****.sharepoint.com/sites/HomeOffice/en-ca/Forms/_api/web/...
user avatar
  • 948
0 votes
0 answers
26 views

Lookup field which reference a list inside the root SharePoint site did not get mapped inside the subsite power app's form Fields

I have a SharePoint online site collection which contain one sub-site. now inside the sub-site we have a custom list named Device List which contain 2 lookup fields. One lookup field references ...
user avatar
  • 948
0 votes
1 answer
155 views

Two Lists: Choice field (lookup column) in first list should auto-filter column in second list. Help!

I have two SharePoint lists on the same site. One list (List A) has a lookup field (called Select Material) that displays the variables in the "Description" column in list (List B). I have ...
user avatar
0 votes
1 answer
200 views

SharePoint SPFx dealing with lookup field

My problem is that when I get the value of the lookup field ('Attachment') its retrieved as an array and I don't know how to deal with it, I mean how do I get the values inside this array, so any ...
user avatar
0 votes
1 answer
103 views

How can I use a SharePoint lookup value in a Calculated field?

I have a list that has 1 field that is a lookup and another which is a calculated field that I wanted to concatenate the lookup value with another field. I worked out the answer below. regards Michael
user avatar
  • 59
0 votes
1 answer
44 views

How can i make a lookup menu searchable?

Situation: I have a list and a library. The list has a lookup column that allows you to choose multiple documents from the library. Problem: The library has several hundred documents, so it's very ...
user avatar
0 votes
1 answer
1k 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 ...
user avatar
  • 145

1
2 3 4 5
23