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 the 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 a new calculated column from the choice field in the list, and you can use that choice field in lookup fields on any other list!
Now, you’ll be able to create a lookup on the choice field!
Hello, I tried to implement this solution however i’m getting a Syntax error. Assuming this is due to the column being a choice item