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.
1,133
questions
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 ...
- 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 ...
- 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?
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 ...
- 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 ...
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 ...
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 ...
- 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 ...
- 107
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 ...
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 ...
- 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 ...
- 3
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 ...
- 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 ...
- 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 ...
- 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/...
- 75
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 ...
- 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 ...
- 11
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 ...
- 1
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?$...
- 23
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 ...
- 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 ...
- 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 ...
- 11
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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 31
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, ...
- 133
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 ...
- 3
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 ...
- 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 ...
- 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] == "&...
- 31
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....
- 31
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 ...
- 31
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.
...
- 11
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 ...
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 ...
- 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 ...
- 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 ...
- 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;
...
- 13
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, ...
- 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 ...
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 ...
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/...
- 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 ...
- 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 ...
- 1
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 ...
- 1
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
- 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 ...
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 ...
- 145