Follow

Choice field Lookup

In SharePoint Online it is not possible to lookup a choice field. This can be resolved with the following workarround.

 

Setup:
Companies (Parent)
Contacts (Child)
Projects (Child)

 

Goal:
Get the column named "Company Type" which is of the "Choice" type to appear on projects.

 

Resolution:
Create a column on the Company list of the "Calculated" type and set it to indicate the value of the choice field.

 

Then create a lookup field on the Project list to lookup the value of the calculated field in Company list or add it to a column which already is looking something up from the company list (eg. Company).

On the Project list click List settings > Company

And tick the calculated column from the Company list

 

A video of the configuration can also be found here:
http://screencast.com/t/bP1gJ0fqs

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments