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,018
questions
0
votes
0answers
4 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
16 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
31 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
21 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
32 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
27 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
26 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
19 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
50 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
31 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
44 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
33 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
21 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
50 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
46 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
257 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
20 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
49 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
26 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
29 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
25 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
70 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
25 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
58 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
19 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
27 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
37 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
190 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
vote
1answer
31 views
workflow: how to create a related item when add an item
I have one list 'transaction', I have another list 'transaction log' with a lookup column link to ID of 'transaction'. When I add a new item in 'transaction', I want to trigger action to add a new ...
1
vote
0answers
16 views
Numbers aren't working as values in a SharePoint workflow
I am trying to get a workflow to basically move an item into a certain escalation status and then email someone at that point. We need to calculate only business days, no weekends and no holidays.
I ...
0
votes
2answers
133 views
Adding Lookup Field to a SharePoint list via PowerShell (SharePoint/PNP)
I am trying to create a lookup field via Sharpoint PNP PowerShell module.
And here is my script:
$URL = "https://testing.sharepoint.com/sites/sitename"
Connect-PnPOnline -url $URL -Credential ...
0
votes
2answers
35 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 ...
1
vote
1answer
24 views
SharePoint 2013 - Custom WebPartPage for List Form
I'm looking to add related lists to a Display Form for a list and tie them together with filters.
I can create a new custom Display Form in SPD and add the related web parts with filters based of the ...
0
votes
0answers
111 views
Error: Binding a non-repeating control to a repeating field or group is not supported in SharePoint list forms
I am creating a sign-up list for a company potluck, and I want to show the number of certain dish types that have already been signed up for. Details:
I have two lists: Potluck Signup List, and Dish ...
0
votes
0answers
30 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
128 views
How to Update Newly Added Lookup Column using Value from the existing Choice column through powershell
I am working with SharePoint on prem 2019 and in one of the document libraries, I have a field called 'Trust' of type choice, this library contains about 7000 files.
Now we have to convert this ...
0
votes
4answers
137 views
How to get value from Multi Lookup field using SharePoint rest API call?
I have one list with lookup column #lookupColOne and this value is used in #list2.
#List2 have a lookup column of #List1 ID field. I want to get #list2 data along with #list1 lookup column values.
...
0
votes
2answers
55 views
Sorting multiple value lookup column - alternatives
Is it possible to sort lookup columns that allow multiple values or is there any alternative that can be applied in a modern list view?
1
vote
0answers
27 views
SharePoint Online (Office 365): REST API is not working from yesterday (19th September 2019)
Since from yesterday 19th September 2019, Simple Rest URL Select=* is not working.
Note: list is having 12 person or group/lookup column excluding created by & modified by.
However it was ...
5
votes
2answers
267 views
Too many lookup columns error - stable list with no new lookups being created or used
Users & 'Full Control' site collection admin are unable to EDIT items.
Error message reads:
The query cannot be completed because the number of lookup columns it
contains exceeds the lookup ...
0
votes
1answer
180 views
Microsoft Graph api user lookup
I have a user lookup field in SharePoint however the id given is the lookup id and not the userid.
Where is the lookup id referencing?
Looking at a link like this: Create list relationships by using ...
1
vote
1answer
45 views
Adding a search function to a lookup column?
Situation:
I have a list and a library.
The list has a lookup column that allows you to choose multiple documents from the library.
Problem:
The library has several hundred documents, so it's very ...
0
votes
1answer
47 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
0answers
10 views
Copy result of additional lookup column field
I need a way to filter a document library based on the value of a lookup fields additional column.
Set up:
Lookup list has various fields including Company and Accountant.
Document library has field ...
0
votes
1answer
36 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, ...
