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 2


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/

  • Thank you, sourav! Jul 23, 2020 at 20:54

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.

  • Understood, Chelsea. Thank you! Jul 23, 2020 at 20:54
  • Chelsea: is there a way to have the looked-up value show on the form itself? Or can it only be seen in a list view? Jul 23, 2020 at 21:44
  • @rizingfenix Yes. If you are using the default list form, the new created column (including lookup column) will be automatically displayed on the list form. But if you are using customized form, the list field will need to be manually added to the form. Jul 24, 2020 at 2:54
  • I have the menu added to the form, but the value I'm interested in carrying over from the other list isn't a field choice at all in InfoPath. ??? Jul 24, 2020 at 5:23
  • In other words, if I'm looking at just the list view, I can see both the values: the one in the dropdown menu and the value that I'm really interested in carrying over. But I can't find a way to make that show in the form via InfoPath. Jul 24, 2020 at 5:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.