Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

In SP2010,

I want to get 2 columns from another list and merge these columns. But when I am trying to do this via Lookup, they are not shown under "Add a column to show each of these additional fields".

But when I tried a simple text one (not lookup) it is shown.

Is there anyway to show a column which a kind of lookup field?

share|improve this question

5 Answers 5

up vote 9 down vote accepted

I gather that you're trying to use a lookup to 'bring in' additional fields to your current list, but that they aren't available to select.

Some field types are not available for this sort of function. For example, further Lookup fields can't be brought in.

Also, notably and annoying, neither can Choice fields. This was possible in SharePoint 2010 before SP1, but after SP1 it seems to be no longer possible. I can't see a good reason why, and it is very annoying.

There is no way of making additional types of column available in the look up control as far as I know.

share|improve this answer
    
thanks Andy, i googled it alot and there is really no way to use looked up columns in additional fields. Its bad :/ I must find another way. –  alicanbatur Jun 27 '12 at 10:44
1  
+1 for the note on choice fields. Apparently a workaround is to copy the choice field to a calculated column –  Christophe Aug 29 '13 at 22:57

Not all fields are supported as lookup fields. I tried to find a supported fields list but didn't find one. While searching though I ran across this discussion which offers a fix for columns that aren't supported such as choice fields.

http://social.msdn.microsoft.com/Forums/en/sharepoint2010general/thread/5a80988a-6b37-4454-957b-856ea16b2e60

share|improve this answer

I found a work around for this, what you do is use a wf to move the column into a text field. Go the origional list that has the information you'd like to look up. Creat a new text column and give it a name similar to the one you would like to dupilicate. Then create a WF to auto-populate that column into a text field. You can then look that column up in any other list.

share|improve this answer
    
Yeah, this is what we do as well. –  PeterX May 22 '13 at 6:15

Not as far as I know - which is why it doesn't show.

share|improve this answer

How about this as a solution,

Say the choice column that you want to use is called 'My Choice', create a calculated column with the formula [My Choice] then this calculated column is available in the "Add columns to show additional fields" options. This will probably also do for a look-up column too.

It seems to work for me but I'm sure Microsoft will find a way of breaking this in the next service pack.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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