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,172
questions
2
votes
3
answers
9k
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?
CommunityBot
- 1
3
votes
1
answer
2k
views
Can i group documents by using lookup column with multiple value?
One document belongs to many row. It is allowed . But I want to group them and show the document on each group. Is it possible ?
CommunityBot
- 1
2
votes
2
answers
2k
views
Sharepoint lookup to another list using current item ID
I am building a list, where I want to protect certain columns from editing by the users. I understood that Sharepoint does not have column protection functionality. One of the workarounds is to have ...
CommunityBot
- 1
0
votes
1
answer
2k
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 ...
CommunityBot
- 1
0
votes
1
answer
3k
views
How to update the people and group column with multiple values in SharePoint
I have a person or group column in SharePoint 2013 I want to set the multiple values I have set its value like 1;#pallavi it's working but when done for multiple values like 1;#pall;#2;#shee it's not ...
CommunityBot
- 1
0
votes
1
answer
3k
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 ...
CommunityBot
- 1
0
votes
1
answer
1k
views
How can I sort a lookup drop-down list box in the Edit or Create form?
I've been developing a SharePoint site to track projects and work intakes at my job, and one thing that I can't figure out is how to sort the contents of a lookup drop-down list box.
The data I'm ...
CommunityBot
- 1
0
votes
2
answers
4k
views
Filtering lookup values based on another column powerapps
I have a document library (with document sets). And while I wanted to use enterprise metatags (so I can use nested tags) the users feel that this is too much of a confusion and would like to have two ...
CommunityBot
- 1
1
vote
4
answers
6k
views
Add multiple line breaks to look up column in which multiple values are allowed
I have a specific question regarding line breaks in SharePoint online lookup columns in which multiple values are allowed. I would like to separate each of the values from lookup via a line break.
I ...
CommunityBot
- 1
0
votes
1
answer
2k
views
SharePoint Online List Lookup within the Same List
I have only One SharePoint Online List.
I want to use a Lookup using "ID" and "Prior ID" columns, in order get a Date added to the "Prior Date" Field.
I want it to look like the table below.
But ...
CommunityBot
- 1
1
vote
1
answer
2k
views
How to add hyperlink from other list with lookup
I gave up. The task looked simple:
I have a list with clients with 2 columns: clientname, clientid, URL.
I made another list where managers could collect clients from this list that they frequently ...
CommunityBot
- 1
1
vote
1
answer
15k
views
Getting the value from a lookup column in Power Automate
Pretty simple: I have a lookup column that references another list of strings (multiple selection text field). In a workflow I want to get the values from that lookup column so I can put them in an ...
CommunityBot
- 1
1
vote
1
answer
1k
views
Get value automatically similar to Excel's vlookup function
I want to get data from another list automatically based on a column from this list. Let's say the source list shows the ID A, B, C and the related values 1, 2, 3. In my list I show in a column one of ...
CommunityBot
- 1
1
vote
1
answer
2k
views
Validate text column against [Me]'s Display Name
I have two lists in SharePoint 2013
Trips
Drivers
Drivers has a column called Active Driver that is a single line of text formatted "Lastname, Firstname". Drivers also has a separate column that is ...
CommunityBot
- 1
1
vote
2
answers
1k
views
Update Lookup Column with Multiple values using Designer Workflow in SPO
In SP Online using designer workflow,I am trying to update a lookup column(with multiple values enabled) from another lookup column(with multiple values enabled).Both lookup columns are in different ...
CommunityBot
- 1
0
votes
0
answers
17
views
how to add lookup to existing big list
I have a parent and child lists.
Job list has unique job (title) and Job History list with none unique job (title)
Both lists are already over 5000 items.
I need to report on the history but need one ...
- 292
1
vote
1
answer
2k
views
Link two SharePoint lists and edit at the same time where one list can have multiple items per one item on the source list?
I have two sharepoint lists.
The first, LIST1, is a location listing with a unique plant code to each.
The second list, LIST2, is a list of contacts with a column that ties back to that plant code. ...
CommunityBot
- 1
0
votes
1
answer
1k
views
copy one column value to another column in a list
I have a list named ABC in MOSS 2007
List has
2 Views (All Details and Multi Location)
2 columns (BA-tech and BA for both views)
BA- tech field is "Single line of text" type and BA field is "Look up"...
CommunityBot
- 1
1
vote
1
answer
2k
views
Clear multi-value lookup via Jquery SP 2013
I am trying to clear a multi value lookup field using javascript when an item is re-edited.
I have tried all the following combinations without success
$("input[id^='Test'").removeAttr();
$("input[...
CommunityBot
- 1
0
votes
2
answers
2k
views
SharePoint Error Invalid look-up value. A look-up field contains invalid data. Please check the value and try again
While trying to update a value in pages library, I am getting below error:
Invalid look-up value.
A look-up field contains invalid data. Please check the value and try again.
This is happening for ...
CommunityBot
- 1
1
vote
1
answer
3k
views
Sort Order of a Lookup Column
I am trying to sort my lookup column based on a column called sortby. I've tried an few of the suggestions, but just can't seem to get it to work.
This is what I have tried and it doesn't sort by ...
CommunityBot
- 1
2
votes
1
answer
1k
views
How to use a lookup column's additional field in a workflow?
Background
I have two lists. One is a list of voltages and their corresponding costs. This is to be used as a lookup for other lists.
Voltage Cost
120 2.50
240 ...
CommunityBot
- 1
1
vote
1
answer
2k
views
Lookup field value is not getting set when using Client object model
I have a document library (contact). Have created a custom list (workstatus). Have added column to contact library which is lookup of workstatus.
Below is my code using which i am setting the lookup ...
CommunityBot
- 1
2
votes
1
answer
2k
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 ...
CommunityBot
- 1
6
votes
1
answer
2k
views
SharePoint Online list view threshold error in a lookup column
I am facing an issue with lookup column in the list forms due to list view threshold limit (5000 items).
The parent list is having more than 5000 items. Hence the lookup field is not getting ...
CommunityBot
- 1
0
votes
1
answer
2k
views
Adding a many to many relationship, and having a form input data into two lists
I'm building a form for a Marketing Event list. The list would track name/type/location/date etc of the event and also those people associated with it (for example recipients or attendees) These ...
CommunityBot
- 1
0
votes
1
answer
18
views
Options to fill the information in the lookup column of the document library after migration from SP 2013 to SPO
In my SP 2013 site I have a calendar and a document library that has a lookup column, taking values from the Title column of the Calendar.
I am migrating my SP2013 site to SPO site.
We used ShareGate ...
- 434
2
votes
2
answers
6k
views
Workflow Error: Coercion Failed: Input cannot be null for this coercion
I have a workflow that is assigning a task based on a lookup value. This workflow runs successfully the first time then fails on subsequent attempts. Here's how the data looks:
Look Up
Title ...
CommunityBot
- 1
5
votes
1
answer
1k
views
Sharepoint 2013 - Add lookup column to key filters
I've got a document library of invoices. It has various columns (mainly choices) such as, Year, Status, Location, etc. and I've been able to add them to metadata navigation as key filters.
However, ...
CommunityBot
- 1
0
votes
1
answer
2k
views
How do I send data to a lookup field with ReST? SP2013
I've been working with a jQuery AJAX call to post data to one of my SharePoint lists.
One of the fields in this list is a look-up field. In forming my JSON data to push to the list I was able to ...
CommunityBot
- 1
2
votes
2
answers
9k
views
Pull multiple values through a lookup
I am rather new with SP so I apologise if I cant express myself too well.
Problem at hand:
Two lists - Shops and Managers with a many-to-many relationship between them.
I.E. in Shops there can be ...
CommunityBot
- 1
1
vote
3
answers
2k
views
how to lookup multiple items from one list to another and the connect results into a string
I have list "A" in which i store name, email and product.
I have a list "B" which should trigger an email based on some values. One of these values is product. If I chose "car", the workflow should ...
CommunityBot
- 1
1
vote
2
answers
1k
views
Update LikedBy column through Rest Api
I am trying to update the LikedBy column in Discussion Board. LikedBy, it seems, is a lookup column. Can you let me know the what the payload would be? I will need to update the Likedby Id and Likedby ...
- 1
0
votes
1
answer
6k
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 ...
CommunityBot
- 1
0
votes
2
answers
1k
views
Get list information from another SharePoint list
i have a SharePoint list called “HR”, it lists our employees and all personal information about them. On this list, I want to display whether the employee have borrowed any equipment home from the ...
CommunityBot
- 1
0
votes
3
answers
1k
views
CAML Lookup - get different value from lookup list using query
Say I have two lists:
Support Pack
ID : 1, SupportPackTemplateLookup:(ID#OtherValue), IsActive : True
Support Pack Template:
ID : 1, OtherValue: x, SuppType: 10 hr support pack
ID : 2, OtherValue: ...
CommunityBot
- 1
6
votes
2
answers
4k
views
set multiselect lookup column using jquery
I have a Multi select Look up column which as you all know is a control with two list boxes and "Add or Remove" Buttons.
The user populates the right-hand side of the control with some values by ...
CommunityBot
- 1
1
vote
2
answers
2k
views
Retrieving Lookup Values, Javascript SharePoint 2013, Not Working
I've seen a lot of info on the above question but none of it has answered what I'm looking for, so far. I'm trying to retrieve list items that have a great number of lookup fields. I've had success ...
CommunityBot
- 1
0
votes
2
answers
62
views
SharePoint - show Yes/No column from a lookup table
I have a list A which has columns ItemCode (text type) and Enabled (Yes/No type).
In list B I created a lookup column to list A. I am able to show in list B ItemCode from list A however I don't seem ...
- 45.7k
0
votes
1
answer
37
views
Link to Add item into a lookup list
Is the following possible in SharePoint Online.
I have a list A. One of the columns within list A is a lookup type column to list B.
What I would like to do is have an option to add a new item to list ...
- 485
2
votes
2
answers
2k
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 ...
- 308
1
vote
2
answers
4k
views
How to get the value of Person field and Lookup field depending on ItemID using Javascript/Jquery?
I have a form where I have a lookup field displaying issue ids of same list. On selection of Issue id, Person field (Issue Assigned to) and other Lookup field (Function) to be prefilled. I have ...
CommunityBot
- 1
1
vote
1
answer
2k
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 ...
CommunityBot
- 1
1
vote
2
answers
8k
views
Add column (lookup field) to another site
I create a column "LookUpValues" of type LookUp in Site A but I'm trying to add from existing site columns in Site B but it doesn´t show up. Is it possible to do it? Any ideas?
CommunityBot
- 1
0
votes
0
answers
17
views
Patching Lookup column
I have two tables students and subjects. Subject contains subject_id (pk) and subject_name. Student table contains subject_id which is a lookup column to Subject table. Student table does not contains ...
0
votes
0
answers
9
views
Lookup Multi control - is there a client side JS API like SPClientPeoplePicker?
I have a Lookup field for which I am allowing multiple values, however I want the list of available options on the left side of the multi-select to be filtered by another control on the form.
I can ...
- 12.8k
6
votes
2
answers
11k
views
SharePoint 2013 - Remove the hyperlink from a lookup column in a list view
I've searched the web and found a solution.... IF I WAS USING 2010 or 2007.
I have cascading selections referencing two different lists that hold the dependencies as lookup columns. My cascading ...
- 1
0
votes
0
answers
54
views
How to default the value of a lookup column from another forms text field
I have two SharePoint lists. List A (Incidents), which includes an incident number, List B (Subjects), which includes a Lookup Column that uses the incident number. List B allows multiple subjects to ...
1
vote
2
answers
12k
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....
- 177
1
vote
1
answer
18
views
Make a lookup column in one list to show me the item that are on hand in another list
I have two list, the first one (tracker list) is a tracker or inventory of all the phones that I have on hands. Second list (request list) is for user request a phone by serial number.
I want to ...
- 45.7k