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
0answers
9 views

Lookup Column in SharePoint Designer 2013 Workflow then send an email to the users for infos [on hold]

Dears, I am a new user to the SharePoint designer and I need to do workflow to my Lookup list (it has Multiple values to chose) and then send email to different users when they use the Lookup list. ...
0
votes
1answer
20 views

SharePoint 2013 - Related List Web Parts

I have two related lists (parent-child relationship) in my SharePoint 2013 site. The child list contains a lookup column containing the unique titles that exist in the parent list. I have added the ...
1
vote
1answer
16 views

SharePoint 2013 - Custom WebPartPage for List Form

I'm looking to add related lists to a Display Form for a list and tie them together with filters. I can create a new custom Display Form in SPD and add the related web parts with filters based of the ...
0
votes
0answers
18 views

Error: Binding a non-repeating control to a repeating field or group is not supported in SharePoint list forms

I am creating a sign-up list for a company potluck, and I want to show the number of certain dish types that have already been signed up for. Details: I have two lists: Potluck Signup List, and Dish ...
0
votes
0answers
23 views

Look-up Columns redirecting to folders changed their behaviour

I am using SharePoint Online site. Some months ago I created a lookup column in document library [A] that referred to another document library [B]. This was the best option I found to be able to ...
0
votes
1answer
24 views

How to Update Newly Added Lookup Column using Value from the existing Choice column through powershell

I am working with SharePoint on prem 2019 and in one of the document libraries, I have a field called 'Trust' of type choice, this library contains about 7000 files. Now we have to convert this ...
0
votes
4answers
18 views

How to get value from Multi Lookup field using SharePoint rest API call?

I have one list with lookup column #lookupColOne and this value is used in #list2. #List2 have a lookup column of #List1 ID field. I want to get #list2 data along with #list1 lookup column values. ...
0
votes
2answers
39 views

Sorting multiple value lookup column - alternatives

Is it possible to sort lookup columns that allow multiple values or is there any alternative that can be applied in a modern list view?
1
vote
0answers
21 views

SharePoint Online (Office 365): REST API is not working from yesterday (19th September 2019)

Since from yesterday 19th September 2019, Simple Rest URL Select=* is not working. Note: list is having 12 person or group/lookup column excluding created by & modified by. However it was ...
5
votes
2answers
129 views

Too many lookup columns error - stable list with no new lookups being created or used

Users & 'Full Control' site collection admin are unable to EDIT items. Error message reads: The query cannot be completed because the number of lookup columns it contains exceeds the lookup ...
0
votes
1answer
41 views

Microsoft Graph api user lookup

I have a user lookup field in SharePoint however the id given is the lookup id and not the userid. Where is the lookup id referencing? Looking at a link like this: Create list relationships by using ...
1
vote
1answer
33 views

Adding a search function to a lookup column?

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
1answer
19 views

How to use GroupBy in lookup field

I have a lookup column and i want to use groupby for that lookup column in rest api. Anyone suggest me how to do this?
0
votes
0answers
7 views

Copy result of additional lookup column field

I need a way to filter a document library based on the value of a lookup fields additional column. Set up: Lookup list has various fields including Company and Accountant. Document library has field ...
0
votes
1answer
29 views

Sharepoint look up - big number of lookups, so I want to write them down instead of having cascade down option

I am creating a SharePoint lookup function for all the products of my company (there are a lot). I want to, as soon as I put the code of the product, have a lot of parameters appearing. Currently, ...
1
vote
1answer
33 views

Lookup Columns in Word desktop are greyed out in properties pane

I am working with SP on Prem 2019. Users perform File->Save As from word or excel desktop apps and try to save it to the desired document library in sharepoint. The save fails as it expects required ...
0
votes
1answer
25 views

How to create a lookup field from another lookup column

I have one lookup column. I need to create another lookup column to look up the existing lookup column in different lists. I am notable to do this, Could you please suggest some idea to implement the ...
0
votes
1answer
54 views

mandatory lookup column doesn't work

So I have a pretty basic scenario. Two lists (Projects and Clients). In the Projects list I have a mandatory lookup field that aims at the Clients Title column. Now when I fill out the form for ...
0
votes
1answer
49 views

lookup column in sharepoint modern page

I have sharepoint list where we have lookup column which is not loading the data(options) related. Anyone has idea how to resolve it. This is working fine in classic mode.
0
votes
2answers
38 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
52 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
34 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
36 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
18 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
37 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
24 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
19 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
115 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
102 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
38 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
97 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
251 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
21 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
60 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
20 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
478 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
61 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
31 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
656 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
15 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
94 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
144 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
122 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
82 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, ...