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
16 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
14 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
47 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
1answer
65 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
6 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
21 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
18 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
28 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
6 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
15 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
24 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
39 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
34 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
49 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
18 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
66 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
27 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
69 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
32 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
27 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
24 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
22 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
61 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
57 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
53 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 ...
0
votes
0answers
24 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
39 views

Calculated column which checks to see if a value in that row is in another list

I'm trying to figure out the sharepoint equivalent to the following SQL statement: UPDATE List1, List2 SET List1.Field2 = List2.Field2 WHERE List1.Field1 = List2.Field1; Or the Excel version: =...
0
votes
1answer
26 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
70 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
18 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
53 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 ...
2
votes
1answer
735 views

How to update a SharePoint Multi-value Lookup Column using a PowerApps Combobox?

I have a primary SharePoint list which is connected to a customised PowerApps form for data entry. Inside this form, I have added an additional multi-select Combo-box, which displays values from a ...
0
votes
1answer
22 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&...
1
vote
1answer
55 views

How to get list data from sharepoint list with lookup field values in asp.net mvc

I want to get data from a list. It contains some lookup fields. My problem is how to get lookup value from the list. I meant I want to expand lookup field values. Here is the code I'm doing. var ...
1
vote
1answer
27 views

How Do I Use The Value of a Lookup Column in a 2013 Workflow?

I have a list used for scheduling appointments. Each item in the list is an appointment date/time. Column A is a Number column indicating the total number of appointment slots, Column B is a ...
0
votes
1answer
33 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 ...
2
votes
1answer
45 views

metadata error SP.FieldLookup

Arigato is a lookup field. I would like to change its value. I got error with FieldLookup. Can you help me?
0
votes
0answers
28 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
110 views

Update Lookup Field value, from Text field value in the same list using workflow

i have come across a scenario where i should update lookup field value from single line text field in the same list (lookup field used for splitting text/string). Is this possible to update the ...
0
votes
1answer
29 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
78 views

Have a column pull criteria from two columns and display specific value

My goal is to have a calculated/or lookup column to display the company number if two columns contain certain information. I do not have access to PowerApps, Microsoft Forms, SharePoint Designer, ...
0
votes
2answers
20 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
0answers
29 views

SharePoint - Manager/Role Look-up

I'm trying to replicate the attached table in SharePoint Online, ideally using a Look-up list. Ideally with Out the box functionality. I hope you can help. Scenario: List of Responsibilities (30, ...
0
votes
1answer
44 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
28 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
299 views

I can't find a solution to use the value of a lookup column in a list, can anyone help?

I am trying to create a kind of registration tool with a Sharepoint list (next step could be to create an app), but I am struggling to get the value of a lookup column. I read a lot of forums and ...

1
2 3 4 5
21