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.

392 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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
465 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
13 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 ...
0
votes
1answer
31 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 ...
0
votes
0answers
12 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
19 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
347 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 ...
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
23 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
1answer
123 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
45 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
36 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
135 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 - "...
0
votes
0answers
25 views

lookup column display data in other columns

I have a list in column A(an ID) that will display the description in column B(a name). I would like the data that will be put into column B to appear as I am selecting an ID in column A. Can this be ...
0
votes
1answer
55 views

how to convert currency type to number with workflow

I work on SharePoint 2019 and I have a list containing name(type: text) and price (type: currency) of food columns. How can I fetch them to other custom forms? I use lookup type in the custom form to ...
0
votes
2answers
185 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 ...
0
votes
0answers
22 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
61 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 ...
0
votes
1answer
29 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&...
0
votes
1answer
41 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 ...
0
votes
0answers
48 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
46 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
38 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
1answer
101 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
32 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
79 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 ...
0
votes
0answers
53 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
132 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
1answer
45 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, ...
0
votes
1answer
95 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
86 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
1answer
314 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
116 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
22 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
1answer
648 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
2answers
36 views

Lookup Column Value through Rest API

i have a small requirement, where in i am pulling in a lot of data from List A to List B through Rest API. but i am stuck at one place where in i am not able to pull in lookup value in List B. Hope ...
0
votes
1answer
312 views

Update another field with an id of a lookup column

I have a list with around 1000 columns and I need to be a able to prepopulate another field with a lookupid of another lookup field on the same list I am getting error when I use: var ...
0
votes
1answer
135 views

Pull mulitple fields when getting dropdown choices from external data source

I've tried searching for this as I'm sure others have had the question but can't find a way to word it to find a result. I have two lists setup - one with a list of people and their data (IDs, First, ...
0
votes
0answers
101 views

Filtering view and workflows for lookup columns

I have 2 lists with the following columns: List A - "Status" (choice column)/"Name"(Single line)/"ReqNr(Number)" List B - "StatusNameReq"(Lookupcolumn based on the columns in List A) Now, I want to ...
0
votes
1answer
64 views

Show all the lookup column data

I have 2 lists: House and Room. House list has lookup column call Room(Room1,Room2,Room3). When I add a record for house list, I choose Room1 which is hyperlink to lookup column. Is there any way, ...
0
votes
2answers
4k 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?
0
votes
1answer
463 views

how to change lookup reference between sharepoint lists?

I have simple Sharepoint list named Alist with lookup value column. the lookup value column returns fields from other list named Blist. accidentally I have deleted this Blist and in Alist all lookup ...
0
votes
0answers
142 views

how to insert multiple values to lookup field in Sharepoint list?

I have Assignee field which accepts multiple values and its lookup column but whenever i try to post multiple values I am getting the below error "Cannot convert a primitive value to the expected ...
0
votes
0answers
37 views

Multiple choice lookup field does not render on edit form

I have, for the last few years, used a field called "Enabled" and a calculated field which returns the value of the Title field if Enabled is true. If Enabled is false, it returns an empty string ("")....
0
votes
1answer
41 views

SharePoint filter lookup field, based on another field in the list

I am using SharePoint online and am having trouble with the formulas since they are not exactly like Excel or InfoPath. This custom list I am creating has a lookup column for office locations and I ...

1
4
5
6 7 8