I have a SQL table with 5 columns in it (EmployeeName, StartDt, EndDt, Location, PictureUrl). I want to display this data in a Sharepoint List. I want the image to be displayed in my sharepoint list's "PictureUrl" column based on the url in the external location.

How to solve this?


1 Answer 1


You can use a content query web part. Then customize it in such a way it can be set to display image instead of the url. I am not sure whether you can customize the entire External List. When you are using the Content query Web Part you can customize the XSLT in it. There then set it to view the image instead of url.

  • External Lists are not supported by content query webpart.
    – user28455
    Aug 28, 2014 at 17:21
  • But you can create a custom list, then add a External Data Column, include the url field with it, then use it in CQWP. Aug 28, 2014 at 17:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.