Is this a bug? Look up column to External List error - SP2016
Hello folks - I am trying to find out if this is a bug with the product, or an issue with my farm. So, I wanted to reach out to the community to get help on something tested. (SharePoint 2016) Please consider this scenario. I've this tested on both on-premise farms and results are same. Prerequisites: Make sure to have a BCS External Content Type to a SQL database of your choice Make sure to create an External List using this ECT to the said SQL database Steps: Browse to Site Columns on a site collection (Same site collection that external list is on) Create a new site column, select type Lookup - Give a good name that you can remember Select "Get information from: " drop down to the External List you've already created, and select a column Hit "OK" Questions: Do you get an error? If you browse back to Site Columns do you see the column actually created but type is listed as "External Data" ? Please let me know your findings here. Thanks! Ali
