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.

359 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0
votes
3answers
243 views

Lookup column agains list with more than 5000 posts

I am new to SP online. This is about a lookup column that displays data from another list which is currently exceeds the 5000 items limit? Any easy solution as I dont have much programming ...
0
votes
0answers
85 views

List people picker graph

I am pulling a list via the graph api. I would like to be able to filter on a people picker field. However I do I use the lookup field id to equate to a user/member i.e the id 18 person joe blogs.
0
votes
0answers
93 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
59 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
799 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
138 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
37 views

Filtered lookup displaying html in view

I created a filtered lookup column to pull in values from another list in my site based on a view. The drop down works great but when I see the item in my default view it is no longer a plain text. ...
0
votes
0answers
58 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
38 views

Document opens in tiny window

I have a list, in the list is a look-up column referencing a document library. (n.b. the Lookup column is actually a 3rd party column a Sparqube Lookup Tracker, but is a look-up column). Is there a ...
0
votes
0answers
36 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
40 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 ...
0
votes
1answer
118 views

Fetching Data based on Look up value from another List

I have a small requirement , where in i have 2 lists say List A and List B. In List B, i have a lookup column which is looking up to List A column. Now on selection of Lookup column value in List B i ...
0
votes
1answer
37 views

Sharepoint Online- out of the box solution

Never used SharePoint before and have been given the task of setting up SharePoint Online and migrating list from SharePoint 2001. I set up subsites, however I now know that I cannot create lookups ...
0
votes
1answer
48 views

How to migrate site collection using powershell (SharePoint Online)?

The requirement is to migrate all the Lists(SharePoint Online to SharePoint Online). I have tried many ways. But Lookups don't work. It creates the lookup column with an empty reference to the other ...
0
votes
1answer
123 views

SharePoint 2013 Lookup column

How to fetch I'd of the parent list from a lookup column value. I have created a report using jQuery data table in child list.( Ihave the lookup column in this list which is referring to the parent ...
0
votes
1answer
27 views

Data in Lookup Columns goes missing

We have SharePoint Online and within one site a Document Library. Within the Library are 8 Lookup columns that reference lists within the same site. When a Document gets uploaded to the Library, a ...
0
votes
1answer
284 views

Filter dropdown/lookup field based on date

I have a Secondary List(B) that my Primary List(A) uses to populate a field in InfoPath called 'Current Pay Period' which is a drop down. List B contains a calculated column to display dates since ...
0
votes
1answer
102 views

Validation of lookup fields

I am using the following Javascript code using Script Editor on NewForm.aspx. It supposed to be working but by debugging I can see that the value returned from the dropdown select is empty. I looks to ...
0
votes
1answer
46 views

Missing Lookup Column Including Search Form

I was trying to create new lookup column with search form in sharepoint online (365), but the lookup column with search form is missing. i want to ask, how to add lookup column with search form? as ...
0
votes
2answers
33 views

Get data from linked lists

I have two lists which are linked. When I want to add a record to the second (child) list I need to get data from the first list (parent). My parent list "PIR" has the fields PIR, number and source. ...
0
votes
2answers
145 views

How to update a lookup value in a Document Library With DocumentSet

I would like to update my document library but i do not know how to do with one of my field which is a lookup field. Here is my code: #plug-in SP PS Add-PSSnapin Microsoft.SharePoint.PowerShell -...
0
votes
0answers
115 views

jquery to get value from parent list

I have a list that uses a LookupField. I am trying to display the ParentID when I add a new item to this list. Here is my jquery code: <script src="/sites/SWR000744/SiteAssets/Scripts/jquery-3.2.1....
0
votes
1answer
155 views

How to create a lookup column with Site Design for modern sites

As per the MS article i have created site design file and uploaded to SharePoint which is working fine. But I want to create a lookup column with the site design approach. I am using below code to ...
0
votes
1answer
512 views

SharePoint 2013 How to update a lookup column in different lists?

SharePoint 2013 updating a lookup column from another list not working Lists: IP Range: Includes a title column (single line of text) for ip ranges (ex. 10.1.1.x) IP List: Includes columns for ip ...
0
votes
1answer
197 views

Choosing between Choice, Lookup & Managed metadata to add keywords to our documents inside document libraries

I am working on SharePoint Online team site collection. And we have many document libraries that we want end users to be able to add keywords inside them. Now I want the approach to have the following ...
0
votes
2answers
420 views

Filter Lookup column based on Current Logged in user

I have a small problem i am facing in CAML queries. Currently i am trying to filter a Lookup column based on Current logged in User in SharePoint Online. Here is my code and i am new to using SP ...
0
votes
1answer
30 views

Employee Based Projects

I have a small problem that i am facing currently in SharePoint Online. I have two list Employees & Projects and i have created cascading dropdown. When the employee selects its name from ...
0
votes
1answer
21 views

Lookup to list with identical values

I have a list that contains usage information for tooling. Each time a tool is used, a new line item in the list in entered. This results in the "Tool ID" column being the same (tool ID number), but ...
0
votes
1answer
149 views

Expand and filter nested lookup fields

Lets suppose this structure below: Is there any way to select children whom have root/Id eq 1 with REST API?
0
votes
1answer
102 views

options for enhanced lookup column in “new experience” SharePoint Online

I have a site in SharePoint online which is using a lookup column to a large list (like 25k) of items. I'm getting the list view threshold error when trying to add metadata with that lookup column. ...
0
votes
1answer
163 views

Getting LookupField with SharePoint Online Management Shell

I am trying to get the user Email through a LookUpField. When I try to "Write-Host the Email", the screen is blank. There is no errors and nothing. What is wrong with my code? Any help is much ...
0
votes
1answer
266 views

SharePoint Online - filter lookup text field on new item form to current user

I have 2 lists: Traveler: Employee - Text (Ex:'Smith, John') Profile link - Url Travel Authorization Request: Traveling Employee - Lookup "Traverler:Employee" I need to apply a filter to the ...
0
votes
3answers
668 views

How to delete Lookup columns

I have a list with more columns in SharePoint Online 2010. When I am making the extraction to Access or Excel, I have some columns which do not appear in my list of columns I created. I can see them ...
0
votes
1answer
318 views

How to auto-fill fields on new form based on a lookup column of same list?

I have a lookup column that lists the issue ids of the same list. Based on its selection, I need to pre-fill the fields on new form with the values of previously created issues (like issue category, ...
0
votes
1answer
82 views

Lookup links not opening associated record from List form in Sharepoint 2016

I have set up a list that has a lookup field on Documents. This works nicely except for one thing. If I open a record (by double clicking on the record), a panel pops out showing a form populated ...
0
votes
1answer
220 views

Lookup Column Keeps Returning as Undefined

I am getting a TypeError that I cannot figure out for the life of me. I am unable to debug as my company forces IE11, and I do not understand its interface [I use Chrome, which I don't have access to]...
0
votes
1answer
30 views

Manipulate a value in a webpart and use it somewhere else

I hope you can help. We have two lists : countries and customers Countries fields : Country Name + Language Customers fields : Customer Name + Country Name In the dispform of customer, I need to ...
0
votes
1answer
35 views

Where does the Discussion Board 'Posted By' data come from?

We have an email that is sent out when there is a new post to the discussion board via SharePoint Designer workflow. In the email, it shows the user who posted the message or reply using 'Current Item:...
0
votes
1answer
42 views

How can i add linked data source to website?

I got two lists. And I want to join , merge them and select the same IDs.But i don't want to do this on Sharepoint Designer. I only use browser.
0
votes
1answer
52 views

Is it possible to get 13+ lookup field values in an All Items query via CSOM?

I know I could split the queries into 2 or 3 and combine them if I only specify 4-5 lookup fields I want to retrieve each time.. But is it possible to get all of the lookup IDs with CSOM in one CAML ...
0
votes
1answer
453 views

Discussion Board link with List Item - File not found

I have created a List A and a Discussion Board B. In order to link discussion in B with the item in A, I created a lookup column which get the value ID from item in A. This works pretty well when I ...
0
votes
1answer
191 views

Adding value to Lookup columns fails using CSOM in SharePoint 2010

Using the below code, I am able to update the Publications column but not the Authors column as it returns Invalid data has been used to update the list item. The field you are trying to update ...
0
votes
1answer
32 views

Error in sending mail to more than one user through multi valued column

I had a Organizer list with 2 main columns as event and email. Another list is Problem list which has a lookup column with look up field as event. So, a person poses problem and link all events he ...
0
votes
0answers
51 views

Dates from lookup fields that are set using a workflow carry over dates that are a day behind the source date. Why is that?

I have dates pulled from lookup fields from a list and set to new fields on a different list but the dates are one day behind. I checked to see if they are indeed both just Date and not Date and Time,...
0
votes
1answer
758 views

SharePoint Error Invalid look-up value. A look-up field contains invalid data. Please check the value and try again

While trying to update a value in pages library, I am getting below error: Invalid look-up value. A look-up field contains invalid data. Please check the value and try again. This is happening for ...
0
votes
1answer
124 views

How to set the “title” in a lookup field

if you have a lookup field, its Html source is depicted as: <option value="79" title="G0058">G0058</option> I could use jquery to change the title from G0058 to company1 (field name: ...
0
votes
1answer
75 views

How Can You Show Columns Associated with Lookup On Select?

I've got a lookup column that is pulling another field with it. I am trying to show the other field on a New form when a selection is made from the lookup dropdown. The user needs to use use this ...
0
votes
1answer
268 views

SP2013 Add additional columns to a lookup field using REST

I'm trying to create a couple of lists automatically using REST. List A: TextField: ID TextField: Name List B: LookupField: ID (Get from list A) LookupField: ID:Name (Additional read-only column) ...
0
votes
1answer
134 views

Display Associated Lookup Field on Newform.aspx immediately after selection

Here is my scenario: I have List A called Case Info. In it, I am assigning a Case ID based on the YY-XXXX format (so 17-0001 is the first for 2017). In this list I define what firm the case is ...
0
votes
1answer
76 views

Trying to create a lookup field but unable to find the source field

I created 2 lists (A and B). A Field1 field2 Field3 B Field4 Field5 Field6 On A I have a lookup field Field2 which is based on the Field4 of B. It works fine. I would like to make a lookup in ...