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
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;...

1
2 3 4 5
22