How to get a SPFieldLookupValue from an SPListItem?

Question

When you get an SPListItemCollection from a SPList.GetItems(SPQuery) request, and the items have SPFieldUser or SPFieldLookup fields, what is the sexy way to get typed values, not the item["Field"].ToString().Split('#')[1] way, please?

score 43 · Accepted Answer · edited Jul 26 '12 at 11:40

43

new SPFieldLookupValue(item["FieldName"] as String).LookupValue

you probably want to check if item["FieldName"] is not null or empty before doing this.

SPFieldUserValue works similarly, but you need to pass in an SPWeb into the constructor, which you can retrieve from your SPListItem using SPListItem.ParentList.ParentWeb

edited Jul 26 '12 at 11:40

Stu Pegg

4,623
7
48
91

answered Feb 05 '10 at 14:14

Jaap Vossers

5,040
2
24
28

or .ToString() and yes check for null always – Anders Rask Feb 06 '10 at 10:29
Cool, at least this way we are protected from cases when hash/pound-sign(#) appears in the value. Thanks. – Alexey Krasheninnikov Feb 07 '10 at 20:19
12

cool - just googled for this question and stumbled upon my own answer :) – Jaap Vossers Aug 12 '10 at 11:43
3

I wrote an article about the whole get/set Lookup/User field method, which may be useful: http://tsstsst.com/easily-accessing-lookup-and-user-fields/ – Stu Pegg Jul 26 '12 at 11:38
1

for CSOM, use FieldLookupValue from Microsoft.SharePoint.Client. – YHTAN Jul 25 '17 at 07:09

How to get a SPFieldLookupValue from an SPListItem?

1 Answers1