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
18 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
22 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
0answers
22 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
54 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
27 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
73 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
22 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
31 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
16 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
37 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
30 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
21 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
31 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
10 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
14 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
18 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
52 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
12 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
21 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
19 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
59 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
447 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
12 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
32 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
28 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
18 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
52 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;...
0
votes
0answers
11 views

automated solution to consolidate real time files in multiple Sharepoint folders in one excel sheet

I have a scenario :We have 60 folders in one of the parent folder in Sharepoint on premise site. Each folder has an excel file uploaded.I need to consolidate the data in the excel file in one of the ...
0
votes
1answer
18 views

Lookup doc library column showing options based on List other column's value

I am currently setting up a document management system in our SP Online system. A column of the Doc Library is called "Project Name". I created a List ("Project List") containing the Project Name ...
0
votes
1answer
35 views

Unable to fetch lookup field values using REST api

I am using REST api to fetch data from a SharePoint list. I am able to get data using this query: requestUri = "/_api/lists/GetByTitle('Data')/items?$select=ID,Title,Department/Title&$expand=...
2
votes
2answers
198 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 ...
0
votes
1answer
149 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 ...
2
votes
1answer
104 views

If statement JSON column formatting - SharePoint Online List

I'm very much new to using JSON and I try avoid it where I can. My problem is definitely lack of knowledge. I'm trying to change the color of column values based on their lookup fields. Originally ...
0
votes
0answers
7 views

Lag in workflow detecting updates from lookup column

We have moved our internal newsletter to run through sharepoint, We have one list (Dates List) which contains the dates and workflow of emails and reminders, and another list which contains the ...
0
votes
1answer
17 views

After creating the first list with choice fields I cannot lookup those fields - how do I keep data integrity and still link?

I have seen older answers that I can have a calculated field for the lookup but that seems silly and redundant. I have 3 choice fields I would have to do that for for 100s of records. Is that really ...
0
votes
0answers
5 views

Lookup field in Infopath (answer filtered on another dropdown) is returning text as designed, but field error says integer required

I have two dropdowns in a repeating section of an Infopath List Form. When LeaveCategory is selected, the lookup, LeaveDetails, returns a list of options from a SP list based on a filter where ...
0
votes
1answer
20 views

Filtering by date isn't working properly

I have some struggle viewing lists with a Group By. The list contains documents that belong to a certain event. Therefore, we added a lookup field which points to the date + start time from the ...
0
votes
2answers
151 views

How to remove extra trailing zero from SharePoint Look Up field in PowerApps?

When we edit a row in a SharePoint List which has a PowerApps Form associated with it, the LookUp field displays 10 additional Zero after decimal. How to remove that additional 0? I tried finding ...
0
votes
1answer
54 views

SharePoint Designer Define workflow lookup question

SharePoint Designer 2013 lookup workflow values there are 4 columns and I'm not sure what they mean and whenever I try it doesn't work but once they are just 2 columns they work perfectly. Wondering ...
0
votes
1answer
105 views

Lookup values invisible on QuickEdit (JSON formatted)

I hope you can help. SharePoint Online: Values on a Choice column appear colour formatted on QuickEdit view.  However values in a Lookup column (values taken from a lookup list) are invisible on ...
0
votes
2answers
40 views

Update Item Choice selection based on other List

I'm relatively new to all this, so I apologize if this is simply not possible or incredibly easy. I have two lists, the first is 'Projects' which is a list of various projects being worked on, and ...
0
votes
0answers
28 views

Lookup Column in SharePoint 2013

I have two lists. One is the 'Product' list and the other is the 'product description' list. There is a unique productId in the product list. Using jquery I have modified the Title column of the '...
0
votes
0answers
25 views

Creating a “Self-Healing” list that updates when a different list updates

I have a list that uses the People/Group Field. I am able to use the "Create an Item in another site" function with a workflow to "copy" that field to another list, but I am unable to update the field ...
0
votes
1answer
31 views

Grouping lookup select option

I am new to SharePoint. So I would like to ask if it is possible to "group" these drop-down selections together? My lookup table has a "user" and timestamp columns. So, whenever I add a new entry in ...
0
votes
1answer
158 views

Creating one-to-many relationship between two columns in separate lists with thousands of variations

I have a library with thousands of files. Each of these files is a shipment arrival. I have a separate list that contains all of the ID numbers for the individual box/cargo within each shipment ...
0
votes
1answer
109 views

Document Library - Lookup Column Filter

I have metadata tags utilized in my document library - several of them are lookup columns. One of these lookup columns is to a list named "Projects". This list also has several other columns - "...
1
vote
0answers
85 views

Get Lookup column value in SharePoint online search results using CSOM

We have a SharePoint list Products with columns Title, DisplayName, etc.. and document library Product Documents. The Products list is the lookup for the Product Documents. we created a results source ...

1
2 3 4 5
21