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.
973
questions
0
votes
2answers
34 views
How to view a list item and its linked items in simplest way?
There is one list Clients, and another list Projects. Latter is linked to Clients by looking up Clients ID column.
Now if I am in Clients list page, how can I click one client row and somehow display ...
1
vote
1answer
44 views
Display value of lookup fiels on webpart
I am beginner on SharePoint framework and with TypeScript.
My problem is I have a list that contains a lookup type field "categorie", When I try to get the records from the list with rest API, the ...
0
votes
1answer
21 views
How To insert field of type lookup in the SharePoint List
I have a list with name Product Catalog and there are two lookup fields with name Country Preference and Location Preference one date field and multiselect field.
I tested with list name without any ...
0
votes
1answer
32 views
Document Lookup Column
all,
In SharePoint Online I have a doc library (Reference Docs) and a list (Projects).
The goal is for users to choose a doc from a lookup drop-down in Projects, which, when clicked, will directly ...
0
votes
0answers
17 views
SharePoint Online Lookup Column lagging
It started about a week ago, and it only has about 50 items. what is the best approach to tackle this.
Thank you in advances.
0
votes
0answers
29 views
Sharepoint Online cross site lookup schema.xml for field extension
I try to create a cross site Lookup field extension for Sharepoint Online.
The Field extention is working perfectly, as long as both lists are at the same Website but I need it to work cross site.
...
1
vote
0answers
23 views
How to create a recurrent event where every instance is individually modifiable
I have a calendar web part that is associated to another list (Projects).
Now, each event in the calendar web part has a lookup column from the "Projects" list.
My problem is that when I create a ...
0
votes
1answer
17 views
Lookup column allow multiple values warning
I am working in SP Online modern UI. On one of the libraries, after checking on "Allow multiple values" for a lookup column field, I am seeing below warning in red.
can someone assist, i have not ...
0
votes
0answers
9 views
Lookup columns referencing Source variation site Ids in sharepoint 2016
I am using Variations feature in Sharepoint 2016. I have a lookup column for a list in my Source variation site. Now I am popagating that list in my target variation site. The list is getting ...
0
votes
1answer
49 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
1answer
33 views
An unexpected 'PrimitiveValue' node was found when reading from the JSON reader
I am getting this error while trying to post data to SharePoint list. It has one lookup field PostCategory.
{"readyState":4,"responseText":"{\"error\":{\"code\":\"-1, Microsoft.SharePoint.Client....
1
vote
1answer
27 views
Auto populate a lookup field with multiple entries after selecting multiple entries from a lookup
Please excuse me for the vaugness, required due to the type of work.
I have a list that indicates upcoming work on various items. When the work is finished on those items, drawings need updated. As ...
0
votes
2answers
47 views
Why I can't get Lookup Column ID from Source List by Flow?
I have a question about Flow for Sharepoint List. I have 2 Lists, and one of them has a lookup column to another.
List 1: Currency List (Target List)
List 2: Price Table (Source List). I want to get ...
0
votes
0answers
7 views
Lookup Via Sharepoint Designer
I have two list. One List (EMP) Where i have EMP ID and EMP Name, another list(EMP Details) where i have EMP Details (Like, EMP ID, EMP Name and etc). I want when any new item add in EMP list, based ...
1
vote
1answer
69 views
Using Flow to get Lookup Column Value and use these Value to calculate
I am setting a Flow that can get the value of lookup column for using in Calculated Column. My List below:
List A: Target List, contain Currencies and Exchange Rate to VND (Called exRate) of the ...
0
votes
0answers
17 views
Indexing lookup column in SP2019
I am working on a project where a document library is about to exceed threshold and lookup column is one of the metadata columns being used in the library, I am working with SP2019 on prem.
The ...
0
votes
1answer
47 views
Replace HTML list values with substring on SharePoint 2013 Custom List Field
I'm using SPAutocomplete from SPServices because I have a requirement to make a searchable lookup field rather than an OOTB lookup field (drop down menu), as there is potential for thousands of values ...
0
votes
1answer
18 views
Multiple Cascading Delete
I have 3 lists, lets say A, B, and C
I have a lookup in a column from B to A
I also lookup in a column from C to B.
I have the column lookups in B and C as Cascading Delete.
If I delete A, I know ...
0
votes
0answers
29 views
Can I lookup what a lookup column looks up?
To explain the concept, let's pretend I wanted to make lists of cocktails and ingredients.
First off, we have a list of ingredients (gin, rum, campari etc.) and columns of relevant information (cost, ...
1
vote
1answer
202 views
column formatting with json for lookup fields
I have problems formatting the column of a lookup field with json.
Precisely, it is an additional field, displayed from the parent list that I want to format. The lookup field is of type multiple, so ...
0
votes
2answers
33 views
Lookup Column Value through Rest API
i have a small requirement, where in i am pulling in a lot of data from List A to List B through Rest API. but i am stuck at one place where in i am not able to pull in lookup value in List B.
Hope ...
0
votes
0answers
32 views
Lookup to populate Text Box or Dropdown
I was following this to pull Additional Fields to appear on the form using calculated field and it is worked perfectly. However, when I try changing the calculated field to text box, it won't load in ...
0
votes
0answers
46 views
Cascading lookups/filtered choice columns in modern sharepoint
We are using modern sharepoint pages. I currently have a document library with a column that indicates the subject of the document. there's a 2nd column that has the sub subjects. I'm looking to set ...
0
votes
0answers
29 views
SharePoint - Infopath - Lookup Field - Filtering Out Items
I'm working with a SharePoint List (we'll call it List A) that has a lookup field to a second list (List B).
List B has two fields: REPORT_NAME & RETIRED. RETIRED will either be blank or have an '...
1
vote
2answers
412 views
Can we create a look up column from multiple lines of text column in list
we need to create a lookup column from multiple lines of text column in SharePoint online list is it possible.
0
votes
0answers
14 views
Adding a sum column which uses data from lookup
I have a list with employee names and a lookup column from another list, which has the training names and training duration.
The training duration is added as an "additional field" from the lookup
...
0
votes
1answer
56 views
Getting link from lookup document library
I have created a Lookup field linked to the document library which allows multiple files.
I am able to get the Title of the linked documents, but I can't find a way to get the url? How can this be ...
0
votes
1answer
119 views
Update another field with an id of a lookup column
I have a list with around 1000 columns and I need to be a able to prepopulate another field with a lookupid of another lookup field on the same list
I am getting error when I use:
var ...
0
votes
2answers
83 views
Create a self-lookup field which only show certain items based on criteria
I am working on a sharepoint online classic team site. where i added a custom list named "Pricing", which contain these main 2 fields:-
1) a column named "Type" of type drop-down list and have 2 ...
1
vote
0answers
69 views
Cross site collection lookup field (SPO)
I need to create "cross site collection lookup field" in the SharePoint Online List.
I can programmatically change "List" and "WebId" in SchemaXml from LookUp field. It helps to get "cross site" ...
0
votes
0answers
14 views
Required lookup field being submitted with no value
We have a list form which users can use sign up to work induction sessions with. The induction session dates are stored on a separate list.
Sometimes if a user doesn't have the correct permissions, ...
1
vote
1answer
22 views
Use infopath for a lookup column different site collections
I have a client who has 2013 SP and has 3 different site collections.
They have an infopath form that is used. However they require they need to get information from a different list in other site ...
0
votes
0answers
35 views
Sharepoint Multilookup Empty Field
I'm facing an issue with a multi lookup field while doing a REST API call using pnp-js.
So I have this list (let's call it A) that looks up into another list (let's call it B) using a lookup field (...
0
votes
1answer
28 views
Pull mulitple fields when getting dropdown choices from external data source
I've tried searching for this as I'm sure others have had the question but can't find a way to word it to find a result.
I have two lists setup - one with a list of people and their data (IDs, First, ...
0
votes
3answers
137 views
Format text on lookup popup and text inside a table
I have a multiple lookup data inside a table.
I have to format a text "Stato" with green background if it is "PRONTO CONSEGNA".
And do the same thing inside the table isolating the single "Id_uni" ...
0
votes
0answers
56 views
How to retain previous lookup values when initial lookup value is no longer available?
On parent site, have an Employee list with employees who are available/unavailable during different periods.
There are several subsite Project lists using Employee list as a look-up for available ...
1
vote
1answer
70 views
SP2013 Changing lookup source values
List A is a list of products and details about each product.
List B is a list of collateral that includes a lookup column refering to product names in list A.
One of the products in list A is getting ...
0
votes
1answer
71 views
Lookup column adding new columns from source list
This is on SharePoint Online. I have two lists, A and B. List B contains a column which is a lookup column from List A and also pulls in some additional columns.
I've now added a new column in List A,...
0
votes
3answers
217 views
Lookup column agains list with more than 5000 posts
I am new to SP online.
This is about a lookup column that displays data from another list which is currently exceeds the 5000 items limit?
Any easy solution as I dont have much programming ...
0
votes
0answers
82 views
List people picker graph
I am pulling a list via the graph api. I would like to be able to filter on a people picker field. However I do I use the lookup field id to equate to a user/member i.e the id 18 person joe blogs.
1
vote
1answer
146 views
Search API not returning lookup column values
I want to retrieve all the library items of a content type "Prod Request". I am using REST API for this. I am not able to get lookup column values.In below query my lookup column name is LookUp1. I ...
0
votes
0answers
93 views
Filtering view and workflows for lookup columns
I have 2 lists with the following columns:
List A - "Status" (choice column)/"Name"(Single line)/"ReqNr(Number)"
List B - "StatusNameReq"(Lookupcolumn based on the columns in List A)
Now, I want to ...
1
vote
1answer
129 views
how to add lookup value sharepoint online
How to add lookup value (Title )
column "achat" : lookup field
enter c
if (itemEnum.moveNext()) {
// update the item
var current = itemEnum.get_current();
// add lookup field
var ...
0
votes
1answer
59 views
Show all the lookup column data
I have 2 lists: House and Room.
House list has lookup column call Room(Room1,Room2,Room3).
When I add a record for house list, I choose Room1 which is hyperlink to lookup column.
Is there any way, ...
6
votes
2answers
248 views
SharePoint 2013: Error while creating lookup column
We are using SharePoint 2013.
We have two lists in our site: one custom list and one calendar list.
We are trying to add lookup column in Calendar list and referencing the custom list.
Adding ...
0
votes
2answers
376 views
How to retrieve Multi Value Lookup List REST Api Sharepint 2013
have 2 lists,
I tried to retrieve the values of lookup field (one or more values from the Finance list (Title, Country (lookup field to the list Country column "Title"
$("#Finance").autocomplete({...
1
vote
1answer
381 views
Lookup User field limit
Is there any limit of lookup user field in ShP list(Sharepoint Online)? I've created just a simple list with over 18 single user select fields and everything seems to works fine, but I've seen ...
1
vote
1answer
275 views
Filter Lookup Multi-Select on previous selection
I have a Lookup Column called Region, and a second lookup column of type multi-select called Customer.
I want to filter Customers column based on Regions selection. I found SPServices allows to ...
2
votes
0answers
138 views
Large Dropdown Lookup with Autocomplete
Wondering if anyone can point me in the right direction.
Requirement is a drop-down field in a SharePoint Online list that references a customer table in SharePoint Online. Of course, the customer ...
1
vote
1answer
30 views
Using a Lookup Column (follow up question)
Following up this question on using Lookup columns:
How to use LookUp column?
How would you make this work looking up values from a calculated field (Store No) rather than manually inputting the ...
