SharePoint Blogs / SharePoint University
SharePoint Blogs and SharePoint University - all in one place!
Need SharePoint Training? Attend a SharePoint Bootcamp!

Please delete cookies related to sharepointblogs.com and sharepointu.com to resolve login issues!

SharePoint Lookup fields does not support “user or groups”

 

Hi,It has been a while since I wrote any new blog entries because I got married J and guess what l am the luckiest man on earth with my wife and also I have reallocated my job from Estarta - Jordan to Injazat Data Systems - UAE (a joint venture between Mubadala and EDS) so my hand were little bit full.Anyways I decided I will update my blog with a series of entries to recap my absence and as a start I noticed something very strange in SharePoint lists lookup fields, I was doing a presentation for a client to show the ability of getting data from other lists and my example was to retrieve data from team members list that had two columns as the following:1-  Title by default with the list of type single line of text2-  Team member name of type people and groupMy goal was to connect the column to the team member column and guess what! It did not show up in the drop down list so as a result I made a small exercise to see what are the columns that are supported by the lookup column: 

 

Column Type Supported/Not Supported
Single line of text Supported
Multiple line of text Not
Choice – Drop down list Not
Choice – Radio buttons Not
Choice – Checkbox Not
Number Not
Yes/No Not
Person or Group Not
Hyperlink Not
Hyperlink – Picture Not
Calculated Supported
 

I know there are other solutions to get the values of these columns like the DVWP but is there any reason behind this limitation because I recall some of these columns were supported by SharePoint 2003.

 

Enjoy

Yazan

 


Posted 01-14-2008 10:30 AM by yazanouf

Comments

Links (1/15/2008) « Steve Pietrek’s SharePoint Stuff wrote Links (1/15/2008) « Steve Pietrek’s SharePoint Stuff
on 01-15-2008 8:40 PM

Pingback from  Links (1/15/2008) « Steve Pietrek’s SharePoint Stuff

Sharepoint wrote re: SharePoint Lookup fields does not support “user or groups”
on 01-18-2008 4:42 PM

Useful information on <a href="iaffari.blogspot.com/.../a> lookup fields.Need to concentrate on this point

Ramya wrote re: SharePoint Lookup fields does not support “user or groups”
on 07-23-2008 9:01 AM

Hi,

Is there a way to make the multi-line text appear in the look up field? I am trying and unable to find that option. Please help!

Thanks

Ramya

Chandrakant wrote re: SharePoint Lookup fields does not support “user or groups”
on 10-16-2008 2:50 AM

Hi Ramya,

I am having a same problem...do u got any solution for that?

Thanks

Chandrakant

OmahaVike wrote re: SharePoint Lookup fields does not support “user or groups”
on 01-08-2009 8:09 AM

it also appears that SharePoint does not allow a lookup of a lookup field.  bummer.  wish they'd fix this.

colonna ricerca in un elenco. Come funziona | hilpers wrote colonna ricerca in un elenco. Come funziona | hilpers
on 01-18-2009 6:54 AM

Pingback from  colonna ricerca in un elenco. Come funziona | hilpers

Add a Comment

(required)  
(optional)
(required)  
Remember Me?
Need SharePoint Training? Attend a SharePoint Bootcamp!
Posts (c) their respective authors. Everything else (c) 2009 SharePoint Experts, Inc.