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,064
questions
0
votes
1answer
24 views
How to separate lookup column selected items with “X”?
I have a SharePoint Lookup column with multiple choices, as follows:
Apple
Orange
Strawberry
Watermelon
How can I populate a different column by separating the choices with "X", as follows:
...
1
vote
1answer
37 views
How can I join data from two custom lists in SharePoint add-ins?
I want join 2 custom lists in add-ins:
Data of Lists: QuanLyMembers.PhongBanId is ID value of QuanLyPhongBan
QuanLyPhongBan list:
QuanLyMembers list:
This is my code:
function getListMem() {
//...
0
votes
1answer
16 views
SharePoint 2019 on premise - Open lookup column item without modal
Does anyone know any JSON formatting which will open a lookup field item directly without opening in a modal first?
1
vote
0answers
27 views
Creating lookup site column with site scripts
I am trying to create some look-up columns in my site (not in the list) with site scripts. I have succesfully been able to create one:
{
"verb": "createSiteColumnXml",
"...
0
votes
3answers
29 views
How to update a multiple lookup field in SharePoint Designer 2013 (REST API)
I would like to update a multiple lookup field in SharePoint Designer 2013. OOTB this is not possible. In SharePoint Designer 2010 it was possible. Now I would like to do this with for example a REST ...
0
votes
0answers
11 views
Replicate Data from one list to Another [duplicate]
Happy New Year..!
I have two List, List A and List B
in List A, i have column name Title, Status and Value
In List B i have column name Title, Status and Value
in both the sheet title value is same so ...
2
votes
2answers
49 views
How to add a lookup column to a Sharepoint list?
I have 2 Sharepoint Lists:
Entidades:
Entidade_ID | Nome
1 | ABC
2 | DEF
And Diario:
Diario_ID | Entidade_FK
1 | 2
2 | 1
3 | 2
I want to add a ...
0
votes
2answers
33 views
Lookup column in SharePoint list
I've searched around but couldn't find an answer for a simple question:
Is it possible to add a column to a SharePoint list that looks up another column in another list?
Both lists are on the same ...
1
vote
2answers
91 views
Filtering lookup values based on another column in another list, sharepoint online and powerapps
I need to filter a column in the list A, in her form. The filtered values must exist in the list B and I need do this in the form of powerapps. It's simple to do this in SharePoint 2013, but I cant do ...
0
votes
1answer
17 views
How to keep Lookup values when cloning a list?
We have SharePoint 2016 and like to create some central maintained lists (a country list, flags, locations of our company, contacts etc.).
Since we have a workflow that clones a list to a different ...
1
vote
1answer
30 views
Sharepoint: Creating another view with unique values and sum
I have such a list as per screenshot.
I need to create another view, where first column "Risk Category" will show only unique values (so only 3 items in this case: "Legal risk, "...
1
vote
3answers
96 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 ...
0
votes
1answer
27 views
SPD Workflow generated email showing 27;#
I've created a workflow which auto-generates an email. I'm using "Add or change lookup" to provide information to the "To:" line and to the body of the email (e.g. [%Current Item: ...
0
votes
2answers
28 views
Will changing a list name affect lookup columns?
Will changing a list or library name affect other lists that use it as a reference/lookup column? Or will they automatically be pointed to the updated name?
I am working on renaming a couple lists and ...
1
vote
1answer
312 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 ...
0
votes
3answers
35 views
Copy item and information from lookup column to another list
I have 2 SharePoint lists. I have List A which is list of types of devices (make, model, etc.) and List B which contains an inventory (serial number, computer names, ip address, etc.) List B has a ...
0
votes
0answers
12 views
Cannot set sp2013 workflow variable to value from list field that holds 'count related' value form related list
In the light of sp2010 workflows going into retirement on November 1st I have an issue with the migration of one of our 2010 workflows.
the context:
We have two lists where one is a list of ...
0
votes
1answer
54 views
How can i find the Lookup Column id when i pass the data to REST API?
As shown in some examples I must use lookup column ID when i pass data to Rest API. But I cannot find what the lookup column's id. So How can i add this id to data in rest api?
JSON.stringify({ '...
0
votes
2answers
82 views
SharePoint online limitations for a lookup column with multiple values
I have a SharePoint online list that has a lookup column with multiple values enabled.
I am not able to find the official upper threshold value of the number of items I can select in the lookup column?...
0
votes
0answers
76 views
Sharepoint 2013 after upgrade lookup values with modified urls
After upgrading SP 2013 from May 2017 CU to Sept 2019 CU, I have some strange behavior on lookup values.
All the URLs are modified and throws 404 error.
For example:
Correct URL:
http://site.domain....
0
votes
0answers
22 views
SharePoint online lookup column translation issue
I have a SharePoint online site collection.. and created a list named "TestList" with two columns "testcol1" & "testcol2" ( columns are site column and created ...
0
votes
0answers
12 views
Copy values to a lookup column
I have a form with a cascading dropdown. I am getting the data from MSSQL table using SSIS. I was able to update the text fields from the database, however, I couldn't update or create anything if ...
0
votes
1answer
38 views
Sharepoint online list Validate field base on lookup value selected
I am doing a testing on sharepoint online which I would like to do the below:
I have a list with below schema:
As you can see there's one lookup field: Document type
In this document type, currently ...
0
votes
1answer
27 views
Is it supported to have Additional fields inside a lookup field contain another lookup field
I have 3 lists as follow:-
ItemCategory
Item
Invoice
the Item list has a lookup field to the ItemCategory list
the Invoice list has a lookup field to the Item list.
now i am trying to get the ...
0
votes
2answers
56 views
Multiple inheritance for the Lookup lists. is this supported
I have 3 lists as follow:-
ItemCategory
Item
Invoice
the Item list has a lookup field to the ItemCategory list
the Invoice list has a lookup field to the Item list.
now i am trying to get the ...
0
votes
1answer
53 views
How to update “Lookup column” values from csv to Sharepoint Online using Powershell Script?
I have a Parent list called country and the child list where I want my values updated is call Continents.
the lookup filed name in Continents is "Country". Any help will be greatly ...
1
vote
3answers
90 views
Lookup Column Content
I have two list: Members / Members Training
A Member's 'Status' can be Active or Inactive.
The Member's Status column appears in both lists, but is only updated in the Member list, by Power Apps.
Is ...
0
votes
1answer
24 views
Lookup fields will not save
I have a library with a lookup field pointing to a list.
When I attempt to add data to the field, 'saved' appears next to the field, and then the data vanishes.
This happens both with the form and in ...
0
votes
1answer
38 views
Unable to add item with a lookup column value using CAML query
I have a PowerShell script that add's a new item to a list which has 2 lookup columns to different lists
first part of the script add's the item with the correct lookup value:
$ListLookupitem = $...
0
votes
1answer
18 views
Identify “additional” Lookup field and select its value via OData select/expand
I've created a list "My List" with a column called "RelatedRecord", which is a lookup against other items in "My List". When I defined the column, I selected the field &...
0
votes
0answers
6 views
Look up columns not seen in XML when using Sharepoint API
Hi I am a new developer and I just started using SharePoint and the SharePoint API. I've tried searching for an answer to this but have not found one.
When I use the SharePoint API request: https://{...
0
votes
2answers
39 views
Does using a Lookup column require a manual selection to initiate?
My users manually enter an alphanumeric value for each record in List A. I want that value to match up with the same value in List B so that another column in List B shows up in List A.
At first, I ...
0
votes
1answer
47 views
CASE SENSITIVE Custom Validtion syntax for the IN operator for a column of SharePoint list
I am entering the below condition as the validation formula for an attribute in the SP list, but it allows me to enter "innovation" instead of "Innovation", how can I avoid this.
=...
0
votes
0answers
22 views
SharePoint Hosted Add In REST API returns null for lookup field values
I have written following REST Query in SharePoint Hosted Add In to get list items:
<appweburl>/_api/SP.AppContextSite(@target)/web/lists/getbytitle('PageAccessMatrix')/items?$select=Headers,...
0
votes
1answer
35 views
Sharepoint list : Formatting for lookup column to see future dates only
I have two lists (1) Meeting schedule and (2) meeting Agenda. the 2nd list (meeting agenda) has look up column which linked to meeting schedule.
Question: Is there a way where only future dates from ...
1
vote
0answers
12 views
Is there extra Javascript involved in the 2016 version of a multi-lookup control?
I have to filter the available options for a multi-lookup field based on the value of a Taxonomy field. I had it working in 2013 doing this:
On page load, detach all the option elements from the ...
0
votes
1answer
20 views
CamlQuery Lookup not correct
I need to display the elements in Column "NetworkNodes" only SRV1 and SRV3 in Lookup, how to write correctly?
The remaining elements of the SRV are not needed.
Doesn't work like that:
Query =...
0
votes
0answers
17 views
Column Default Value Based on Root URL
I have a tab in an MS Teams team where users can view our upcoming corporate training sessions (i.e. modern Events). In each event description, I am putting a link to a sign up form. The sign up form ...
0
votes
0answers
21 views
SharePoint Lookup Column - break connection from source
When choosing an item in a lookup column, how do I break the connection of the item in this web part from the source in the other web part? So that when the item is deleted from the source list, it ...
1
vote
1answer
282 views
Unable to delete Column
Forgive me if this has been asked before but I have not been able to find a solution that works. I am currently teaching myself how to use SharePoint.
I have created some columns that have errors in ...
0
votes
1answer
21 views
Creating Upload Document button - upload hangs and never closes
Trying to create an upload document button for a SharePoint 2013 library. I have some metadata that is necessary for user to enter upon upload. When I grab the URL for the UploadEx.aspx and link to ...
0
votes
1answer
23 views
Need JQuery to Add a (None) or blank value to SharePoint Lookup Column
I have a Lookup column to another list but I need to display a "Blank" value or a "None" as the first item in the dropdown. The column must remain "Required". Does anyone have a JQuery example of ...
0
votes
0answers
20 views
Unable to set User SharePoint group column (lookup) value
Would like to request for some assistance in SharePoint.
I have a SharePoint group called Users and SharePoint List called Role and Department.
I have added Role and Department to Users column as ...
0
votes
2answers
83 views
Sharepoint Pre Save Lookup Validation
I'm new to SharePoint, so will appreciate any help here.
I'm trying to run two checks before a user can submit a form, be it on a new or edit form. The first check is the value of a field is >0 and ...
0
votes
2answers
485 views
getURLParameter(ID)
Lots of great posts on using the getURLParameter(ID) to populate a lookup column in a NewForm.aspx when coming from a list view web part on another page. Here is my problem, the source url that I am ...
0
votes
0answers
15 views
Workflow Error message - add lookup
Creating a workflow that sends an email. Click Add Lookup to retrieve value [%Current Item:Assigned To%].Get error message: Using the brace character in an email that also contains a workflow lookup ...
1
vote
1answer
57 views
Reverse Lookup field Update
I have a lookup field which has 2 additional fields (all coming from List 1) which appear in List 2. Field 1, Field 2 and Status. Field 1 is the primary lookup, field 2 and Status just show the ...
0
votes
1answer
38 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 ...
0
votes
0answers
19 views
While in an Item the Lookup Field Opens the Lookup List instad of the Related Item
I have a lookup field that references another list and I'd like to be able to click on the one of the lookup results and then be taken to that item on the other list. This works fine in the standard ...
1
vote
1answer
236 views
Sharepoint Lookup Column with Multiple Display Vertically
I'm using a SharePoint lookup column that has a multi-select choice field.
When 2 or more values are selected for an item, it is displayed in the view like this:
Value1;Value2;Value3;Value4;Value5;...
