I have a SQL database server with 3 columns ID, Location, FileType, I have used BCS service to connect SharePoint with this table.

Now for example Location field is int type something like 19 means Newyork. This is defined in XML file. Is there any way I can show the city name rather than 19 as number in SharePoint List

1 Answer 1


Yes, do a lookup to another table that has

ID , NameOfPlace

19, "NewYork"

Since you said the ID and names were in XML, you will have to import the excel.

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.