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.

354 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
65 views

Cross site collection lookup field (SPO)

I need to create "cross site collection lookup field" in the SharePoint Online List. I can programmatically change "List" and "WebId" in SchemaXml from LookUp field. It helps to get "cross site" ...
1
vote
1answer
22 views

Use infopath for a lookup column different site collections

I have a client who has 2013 SP and has 3 different site collections. They have an infopath form that is used. However they require they need to get information from a different list in other site ...
1
vote
1answer
68 views

SP2013 Changing lookup source values

List A is a list of products and details about each product. List B is a list of collateral that includes a lookup column refering to product names in list A. One of the products in list A is getting ...
1
vote
1answer
30 views

Using a Lookup Column (follow up question)

Following up this question on using Lookup columns: How to use LookUp column? How would you make this work looking up values from a calculated field (Store No) rather than manually inputting the ...
1
vote
2answers
261 views

how to lookup multiple items from one list to another and the connect results into a string

I have list "A" in which i store name, email and product. I have a list "B" which should trigger an email based on some values. One of these values is product. If I chose "car", the workflow should ...
1
vote
0answers
29 views

SharePoint 2013 bulk edit column not updated

When selecting edit list, select the column, the choices are not updated from the lookup list. But if you edit an individual item the lookup choice is available for a selection. How do I get the ...
1
vote
0answers
64 views

Me Filter on Multiple Selection Lookup Column

I have found plenty of information about filtering lookup columns (title: Employee)during searches but I haven't located something that said using [Me] filter. I created a lookup column that has ...
1
vote
1answer
106 views

Sharepoint 2013 - Conditional validation on mutiple choice lookup column

Scenario: Sharepoint form created in infopath with multiple views. One multiple choice lookup column needs to be "Cannot be blank" for only one of the views. I have removed the ribbon save button and ...
1
vote
1answer
125 views

Provisioning Lookup field with reference to another provisioned list

I'm trying to provision two lists (List 1 and List 2). List 1 has a Title column and in List 2 i want to create a Lookup field with a reference to the Title column in List 1. The problem is that ...
1
vote
1answer
104 views

OOTB: Manage employee skills requirements and departments in SharePoint

Need to create a log and a matrix for tracking requirements for job skills, required and after completed. Employees by location and current rank. Skills by categories, levels, and areas. Master list ...
1
vote
0answers
181 views

Fetch values into dropdown list column based on query from another list - jquery

Please help me with some code (preferrably jquery). Sharepoint 2016. I have List 1 with columns Resource, Attribute1, Attribute2,..., Attribute10. And I have another List 2 with columns Project, ...
1
vote
1answer
40 views

List Filter in Look up

I have a list which contains a column for Name and a column for Department I'm building a secondary list which will contain two look up columns. These looks ups will display the Name column from the ...
1
vote
1answer
131 views

JSOM - CAML query - Not able to get columns from joint lists

I am trying to get data from 3 lists through Join. However not able to access columns of 2nd and 3rd list which i had fetched in query. Relation between lists is as follows; Test3rdList has Lookup ...
1
vote
1answer
437 views

SharePoint 2013 REST - Create List Item with Lookup User Field

How do I create a new list item for a list that has a user lookup field? I have seen other people pass the ID of the user, but that isn't working for me. I get a 400 error when I try that. I have ...
1
vote
0answers
167 views

Can you use a lookup column to filter results in a content search webpart?

I am working on a site in Sharepoint 2013 and I have created a content search webpart in a page layout used for multiple pages. I want to be able to display items from a list that are associated with ...
1
vote
0answers
82 views

set value in Sharepoint cascading dopdowns 2013

I have a newform that sets values on selection of a dropdown value in other fields on form. eg. I select a value in ID dropwdown and all the field values related to that selection are prefilled in ...
1
vote
1answer
336 views

How to set the values of cascading lookup columns using javascript

I have two lookup fields that are cascaded with each other like: 1. Function and 2.category. First I select Function based on that Category field gets value. But I have to set value in these two ...
1
vote
2answers
2k views

How to get the value of Person field and Lookup field depending on ItemID using Javascript/Jquery?

I have a form where I have a lookup field displaying issue ids of same list. On selection of Issue id, Person field (Issue Assigned to) and other Lookup field (Function) to be prefilled. I have ...
1
vote
0answers
62 views

how i can create a site column of type lookup with empty source list (Get information from), and modify the “Get information from” at list level

I am working on an on-premise sharepoint server 2013 farm. i have the following:- 1) i have a team site collection which contain 5 sub-sites. 2) under each sub-site i have a custom list named "...
1
vote
1answer
164 views

SharePoint Designer: Email Workflow based on names in lookup columns

I am trying to create a workflow in SharePoint Designer where in List A it will email the people in Columns: OCR PM, BSC, Pri DBA, Sec DBA, and Tech Mgr only if someone updates/appends changes in the ...
1
vote
0answers
97 views

How to group multiple variables on lookup column?

I want to separate multiple rows. How can i do this with another web part listview or programmatically?
1
vote
0answers
26 views

Lookup column to Page library with versioning remains empty after search crawl

We have a content type (named: Tiles) of 7 lookup site columns that point to the ID field of the Pages library on the same site. The Pages library has versioning (Create major and minor (draft) ...
1
vote
1answer
550 views

“Failed to cache field with id” unexpected error on list item edit

Some of our users are receiving "Unexpected errors" when modifying list items. They are third party, but have access to our internal SharePoint site. Our site admin sees "Failed to cache field with id"...
1
vote
0answers
147 views

How to copy the value in a lookup field to a related item in the same lookup column?

I'm looking to fill out a lookup column. I have a couple of Sharepoint Designer Workflows to set a lookup column field in list A to a related ID from another list B when an item is created in list C. ...
1
vote
0answers
132 views

Display Childs in Parent list possible? (Parent-Child relationship list)

I know how to create a Parent-Child relationship between 2 lists and display the Childs in the parent form or on a Webpart near my parent list but what I would like to do is actually display the ...
1
vote
0answers
43 views

Lookup data updates in Content Search Web Part / Search Results

I am using a content search web part to serve up text content and hyperlinks from a list (We will call this the main list). Everything is displaying as expected. One of my fields is a lookup column, ...
1
vote
0answers
74 views

User Profile replicable field not showing data from user

We have created a custom user profile field called "X" and checked the box for replicate and alias and ran a full profile sync. The field "X" appears in the drop down list for field to show when you ...
1
vote
2answers
743 views

Update Lookup Column with Multiple values using Designer Workflow in SPO

In SP Online using designer workflow,I am trying to update a lookup column(with multiple values enabled) from another lookup column(with multiple values enabled).Both lookup columns are in different ...
1
vote
0answers
51 views

Using Flow to change Client Status in Client List based on Activity Type in Activity List

I have a list of Clients and a list of Activities. Activities includes two lookup columns: Client Activity Type Clients includes one lookup column: Client Status What I'm trying to achieve is ...
1
vote
0answers
181 views

Page layout in Root site with lookup field that refers a list in child variations sites Issue in sandboxed solution sharepoint online

I have a sharepoint online site created with No Code Sandboxed Solution. In the feature scope site , i put the content type that contains the lookup field "Category" and the module of the Page ...
1
vote
1answer
431 views

Copy value from Lookup (CountRelated) column to another 'Number' column

I'm trying to visualise data using Google charts, but it won't work with Lookup (count related) columns, so I'm trying to convert those values to Numbers using workflow and that won't work either ...
1
vote
0answers
16 views

How changes at the lookup field affect the destination list

I have list A that a lookup field "LF" to list B. If I change an item on list B, will all items in list A get the new value? Thank you
1
vote
0answers
305 views

Lookup site column created using powershell will have an empty source list

I am working on a sharepoint server 2013 on-premise. and i run the following power-shell script to create a lookup column :- #Create site column from XML string $web.Fields.AddFieldAsXml($fieldXML) ...
1
vote
0answers
80 views

Uploading file in a Sharepoint Library with a required lookup field with copy.asmx

I'm trying to upload a file in a document library. I'm doing it with the copy.asmx web service. I've no problem with document libraries that don't contain lookup field. But if the library includes a ...
1
vote
0answers
62 views

Master and child Sharepoint 2010 lists using look-up

I am process of creating a parent and child custom SharePoint lists. Going through the online forums I figured out how to create the parent and child list (relationship). However I am running into ...
1
vote
0answers
40 views

Lookup Field in List has no selection menu

I have created a list via Visual Studio and added a Lookup Field to an another list and which is looking for the ID of the other list. In fact this lookup field is the second one in this list. There ...
1
vote
2answers
827 views

Retrieving Lookup Values, Javascript SharePoint 2013, Not Working

I've seen a lot of info on the above question but none of it has answered what I'm looking for, so far. I'm trying to retrieve list items that have a great number of lookup fields. I've had success ...
1
vote
0answers
594 views

How to prefill a lookup column in custom new item form: no JavaScript

The goal is to automatically fill a lookup value on a new item form, hidden from the user, based on a parameter value. Preferably without using JavaScript, since I am using a parameter passed from a ...
1
vote
1answer
306 views

Empty lookup column source

I have to maintain a Sharepoint site and I have some lookup column with empty "Get information from" data source when I go in the Site Columns/Edit Column : Those Column present a list Parameter ...
1
vote
0answers
115 views

External Content Type : How to display label on lookup columns (without unable edit / new form)?

I have a SQL Server Table A with a foreign key with reference to B : id_A [int auto_increment PK] name [varchar()] ref_B [int FK_ref_to_B] I try to display A in an External List based on External ...
1
vote
0answers
260 views

Limit Row Height on rows with Lookup Column

I have a SharePoint list in which there are three columns that are lookups from another SharePoint list. The list has custom CSS (below) that limits the row heights on all columns except the lookups. ...
1
vote
0answers
136 views

Change a lookup column's width without influencing other text boxes

I wanted my lookup column to be larger therefore I added a web part with code to my NewForm: <script src="http://code.jquery.com/jquery-latest.js" type="text/javascript"></script> <...
1
vote
1answer
70 views

SharePoint 2013 List Permission issue with root list and subsite list?

I have an issue with SharePoint (Office 365) can you help out to solve my issue. I have a list with confidential data in root site and I have subsite with a list that is referring some column(lookup ...
1
vote
0answers
64 views

receiving errors while working on Advance look up column in SP 2013

I am working in SharePoint 2013, I received errors while I was working on Advance look up. Two errors one after the other: System.InvalidOperationException: Sequence contains no matching ...
1
vote
0answers
122 views

Sort View based upon a specific order of a lookup column

Our standard setup when a department requires a document library with document types is to create a separate Custom List for the Document Types so a power user within that department can add new ...
1
vote
0answers
42 views

Create a button on list view page to copy items to another list

i guys, So my scenario is the following: We have list A and list B, I want to add a button to list A (maybe in content editor web part) to copy the selected list items (multiple items) to list B, I'...
1
vote
1answer
2k views

Sort Order of a Lookup Column

I am trying to sort my lookup column based on a column called sortby. I've tried an few of the suggestions, but just can't seem to get it to work. This is what I have tried and it doesn't sort by ...
1
vote
0answers
29 views

Lookup column lookups up link, not text

brand new oddity I have yet to see. I have two web parts, a picture library (projectPictures), and a list (projectProfile). On ProjectPictures, I have a nonworking workflow (it is supposed to copy ...
1
vote
0answers
34 views

End user picture choices

I am struggling to come up with a method to allow my end user to set up a "project page" as we call them. Basically, this is a parameter based page that filters using ProjectName for both the CQWPs ...
1
vote
0answers
80 views

Lookup Column in two lists

I have a situation on our team that requires us to redesign a set of lists. This directly relates to a client side development effort where we need to re-engineer a Custom Sharepoint Solution written ...