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?

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:

enter image description here

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:

Answered by SOURAV MUKHERJEE on December 6, 2021

Add your own answers!

Related Questions

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

0  Asked on October 25, 2021 by spdevadmin


Calculated Fields and Outputting to Excel

1  Asked on February 28, 2021 by brandon


PnP with .NET Core

1  Asked on February 23, 2021 by thomas-segato


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

2  Asked on February 19, 2021 by user1258


Filtering List View by Current User Email

2  Asked on February 18, 2021 by hushhoney


Ask a Question

Get help from others!

© 2023 All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP