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,007
questions
0
votes
0answers
9 views
Add auto complete to lookup field and allow multiple selections
I'm trying to make a lookup field on a newform.aspx have auto complete AND allow multiple selections. The following script works great BUT only allows one choice. Does anyone know how to modify this ...
0
votes
0answers
37 views
SharePoint Online - JSON Column Formatting
I have a List Lookup in my form. This gives the user the ability to choose multiple unique values.
The problem I am having is that the values are being translated back on to the SharePoint list with ...
2
votes
1answer
15 views
How to update a SharePoint Multi-value Lookup Column using a PowerApps Combobox?
I have a primary SharePoint list which is connected to a customised PowerApps form for data entry. Inside this form, I have added an additional multi-select Combo-box, which displays values from a ...
0
votes
1answer
18 views
Set the chosen drop down list with lookup field value
This is my Function :
function RetrieveNewChange(ChangeID) {
var getItemsUrl = "/_api/Web/Lists/GetByTitle('" + ChangeList + "')/items?$select=ID,Title,Employee/Id,Employee/Title,Employee/FullName&...
1
vote
1answer
30 views
How to get list data from sharepoint list with lookup field values in asp.net mvc
I want to get data from a list. It contains some lookup fields. My problem is how to get lookup value from the list. I meant I want to expand lookup field values.
Here is the code I'm doing.
var ...
1
vote
1answer
22 views
How Do I Use The Value of a Lookup Column in a 2013 Workflow?
I have a list used for scheduling appointments. Each item in the list is an appointment date/time. Column A is a Number column indicating the total number of appointment slots, Column B is a ...
0
votes
1answer
21 views
Not able to edit lookup field with multiple selection in quick edit mode
Lookup fields with multiple selection becomes grayed while creating a new record using quick edit mode.
Once the record exist, using the quick edit, there is no problem for modifying lookup fields ...
2
votes
1answer
38 views
metadata error SP.FieldLookup
Arigato is a lookup field. I would like to change its value. I got error with FieldLookup. Can you help me?
0
votes
0answers
20 views
Unwanted [Object object] on a Lookup column but page refresh solves
I am trying to create a help desk using a SharePoint List. I am using JSON column formatting to create a MailTo email containing relevant parts of the item, that will be sent on.
My problem is that ...
0
votes
1answer
41 views
Update Lookup Field value, from Text field value in the same list using workflow
i have come across a scenario where i should update lookup field value from single line text field in the same list (lookup field used for splitting text/string).
Is this possible to update the ...
0
votes
1answer
23 views
Restrict delete lookup
I do have a lookup in a SharePoint list . The list contains each category will have an approver's name and email. The user won't know who will be the approver to choose in drop down. So in Power apps,...
0
votes
2answers
50 views
Have a column pull criteria from two columns and display specific value
My goal is to have a calculated/or lookup column to display the company number if two columns contain certain information. I do not have access to PowerApps, Microsoft Forms, SharePoint Designer, ...
0
votes
2answers
16 views
Sharepoint limit lookup dropdown entries by “pre-filter”
Following scenario: List A contains several thousand items, List B has a lookup-column to List A. When a user is creating item in List B he has to select the List A item via the mentioned lookup-...
0
votes
0answers
22 views
SharePoint - Manager/Role Look-up
I'm trying to replicate the attached table in SharePoint Online, ideally using a Look-up list.
Ideally with Out the box functionality. I hope you can help.
Scenario:
List of Responsibilities (30, ...
0
votes
1answer
35 views
Lookup value inside multiline text field
I wonder if it's possible to get lookup values (from another list) inside a multi-line column. I can have these values as a separate lookup column, but I'd like to embed them into text in a multi-line ...
0
votes
1answer
28 views
how to Modify lookup column as type able field
I have a lookup column in the SharePoint list, but when we have more number of items in the lookup parent list, it is difficult to select the lookup value. Is there any way to make the lookup column ...
0
votes
2answers
107 views
I can't find a solution to use the value of a lookup column in a list, can anyone help?
I am trying to create a kind of registration tool with a Sharepoint list (next step could be to create an app), but I am struggling to get the value of a lookup column. I read a lot of forums and ...
1
vote
1answer
28 views
workflow: how to create a related item when add an item
I have one list 'transaction', I have another list 'transaction log' with a lookup column link to ID of 'transaction'. When I add a new item in 'transaction', I want to trigger action to add a new ...
1
vote
0answers
16 views
Numbers aren't working as values in a SharePoint workflow
I am trying to get a workflow to basically move an item into a certain escalation status and then email someone at that point. We need to calculate only business days, no weekends and no holidays.
I ...
0
votes
2answers
82 views
Adding Lookup Field to a SharePoint list via PowerShell (SharePoint/PNP)
I am trying to create a lookup field via Sharpoint PNP PowerShell module.
And here is my script:
$URL = "https://testing.sharepoint.com/sites/sitename"
Connect-PnPOnline -url $URL -Credential ...
0
votes
2answers
29 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
19 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
52 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
28 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
57 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
52 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
43 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
25 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
199 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
111 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
35 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
29 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
9 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
33 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
38 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
28 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
56 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
55 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
43 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
73 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
87 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
50 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
20 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
53 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
22 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
17 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
265 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
474 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
75 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 ...
