1

I've created a picture library called "Reusable icons" with all my icons. Then I created a new Custom List with a lookup column to the "Reusable icons"-library.

Problem is that I don't get the url or image name in the lookup column. In the picture library I have one column called "name" that shows the image name.

enter image description here

How can I get the lookup column to choose from the name? I don't see the name column in the dropdown list

enter image description here

I can't use Title, because that can be different to the actual filename! Doesn't picture library have a easy way to get the url to the image? Seems strange!

Improve this question

1 Answer 1

Reset to default
4

It's the way SharePoint works, it only lets you add some specific columns(can't really remember which ones at the moment) as look-up columns, I had same issue few years ago, only solution I could find it that add a item adding event receiver and change Title column to file's name.

There is no other way around I ever came across.

Similar post:

Lookup column to Documents library

Improve this answer
2
  • What about calculated column? Commented Aug 18, 2014 at 14:27
  • I never tried it myself, but I still don't believe it would work, AFAIR SharePoint uses joins for look-up columns and it all happens at database level - again, I did this research an year ago or so.. Commented Aug 18, 2014 at 14:32

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.