How to Use Choice Field in Lookup Columns in SharePoint?

Problem: Could not create lookup columns on Choice field in SharePoint list!

Solution: Not all column types are supported in lookup column. Supported column types are:
  • Single line of text, 
  • Number,
  • Date and Time, 
  • Calculated (Single Line of text), 
  • External Data
So, what's the trick? Well, in the parent lookup list, Create new calculated column from the choice field in the list and you can use that choice field in lookup fields on any other list!

sharepoint lookup on choice field
Now, you'll be able to create lookup on choice field!
sharepoint online lookup on choice field
How to Use Choice Field in Lookup Columns in SharePoint? How to Use Choice Field in Lookup Columns in SharePoint? Reviewed by Salaudeen Rajack on March 26, 2017 Rating: 5

No comments:

Please Login and comment to get your questions answered!

Powered by Blogger.