In SPO/O365, I have a Data List containing two columns:

A                 B
-------------     -------------
Red               1
Blue              2
Green             3

I'd like the data of the Data List to be available for meta data entry, in such a way that a user is able to select a colour (column A) and the value of code (column B) will be used in further processing.

I know to set this up manually using a Managed Metadata column but I'd like to tie these two together in other way.

Any suggestions?


I think your best option here is to create a Lookup column, which does exactly what you're trying to accomplish.

enter image description here

Reference: Create list relationships by using unique and lookup columns

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.