Does using a Lookup column require a manual selection to initiate?

SharePoint Asked on December 6, 2021

My users manually enter an alphanumeric value for each record in List A. I want that value to match up with the same value in List B so that another column in List B shows up in List A.

At first, I was thinking of using a Lookup column for this but if I’m not mistaken, this would require a user to choose a "connecting" value from a list first.

Selecting a value from an ever-growing list of values is not practical (right now I have 1,000), which is why I’m looking for a method that will do this match automatically.

So, can this be done without selecting a value from a Lookup column to initiate this connection?

lookup column sharepoint list sharepoint online

2 Answers

Lookup columns do require manual selection to fill in the values and build a connection between lists.

You can also automatic this process using SharePoint Designer 2013 workflow.

Here is an example:

Please note that we cannot update the lookup column using a normal column since it will cause format conflict error. The column I use in the test is the ID column of the source list.

Answered by Chelsea_MSFT on December 6, 2021

We can "join" two lists using SharePoint designer. Please have a look here: http://www.macaalay.com/2013/12/17/join-two-sharepoint-lists-together-by-id/

Answered by SOURAV MUKHERJEE on December 6, 2021

Does using a Lookup column require a manual selection to initiate?

2 Answers

Add your own answers!

Related Questions

Microsoft Teams file sharing support for on-premises SharePoint

REST or any other API for client side dev to get current users running workflows(Designer or OOTB or MS Flow)?

Adding outlook resource calender to Sharepoint 2013 and Sharepoint online

Is there any way to handle disaster recovery for SharePoint Online?

trigger Approval Workflow Action using Power Apps button – Power Automate

Is there an API or web service for Copy-SPSite?

Searching for keywords and open specific OneNote page

How can i add a text to document library without any file?

I cannot see the “List” in the “Apps you can Add “?

Error while reading the file in SharePoint Document Library

Calculated Fields and Outputting to Excel

call executeQueryAsync mutliple times and add results into an array

Quick links WebPart with Target Audience option

D3 is not rendering in CEWP (SP2013)

PnP with .NET Core

I am trying to upload a file from OneDrive to Sharepoint Online (Office 365) while retaining the file’s format

How to clone the metadata of documentA and set on documentB?

How can I use MS Web Test to upload files to SharePoint?

When clicking on document, not prompting with ‘Read-only’ or ‘Edit’

Filtering List View by Current User Email

Ask a Question