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

Question

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?

Chelsea_MSFT · Answer

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.

SOURAV MUKHERJEE · Answer

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/

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

2 Answers

Add your own answers!

Ask a Question