SharePoint ListItem Error: "Value does not fall within the expected range"

Question

Hi I am developing using the SharePoint namespace and I ran into the following error when I try to retrieve a Title field from the list items.

Value does not fall within the expected range

I know however that the field exists because I printed out all the fields.

string value = (string)listItem[listItem.Fields["Title"].Id];
Console.WriteLine("Title = " + value);

Update: To what extent does the View that was used to retrieve the list items play a role in what fields will be available? This code fails with the same exception:

SPListItemCollection items = list.GetItems(list.DefaultView);
foreach (SPListItem listItem in items)
{
  try
  {
    Console.WriteLine("Title = " + listItem.Title);
  }
  catch (Exception e) 
  { 
    Console.WriteLine("Exception: " + e.Message); 
  }
}

In both cases the list.DefaultView property was used to retrieve the list items.

score 5 · Answer 1 · answered Feb 17 '14 at 10:01

5

I don't know if your error is solved or not. But I was facing the same issue and I found the solution to the problem.

You have to go to:
Central Administration > Application Management > Manage Web Applications
select the Web Application in use and choose:
“General Settings > Resource Throttling” via the Ribbon.

In that scroll down and look for "List View Lookup Threshold" in that by default value is 8 increase the value till the error is gone.

Reference Link

answered Feb 17 '14 at 10:01

Rahul Gokani

1,688
5
25
43

1

I had this very problem. I had validated that my field names were correct. Also, it appears Microsoft has changed the default value of this from 8 to 12. I had 12 in my development environment but 8 in the staging environment where the problem arose. I had to reset the app pool in IIS for the setting change to take effect. – Joe Rattz May 05 '14 at 15:55

score 2 · Answer 2 · answered Mar 26 '16 at 13:34

I had this issue because the column was not part of the default view. Instead of relying on the view, query for the specific columns directly when creating the SPListItemCollection.

  SPList cityList = web.Lists[cityListName];
  SPListItemCollection items = cityList.GetItems("Title","LocCode");
  foreach (SPListItem item in items)
     {
          cityName = item["Title"].ToString().Trim();
          cityCode = item["LocCode"].ToString().Trim();
     }

score 1 · Answer 3 · edited Oct 15 '12 at 17:24

1

I'd suggest something like

if (item.Fields.ContainsField("Last_x0020_Modified"))
{
    if (query.ViewFields.Contains("Last_x0020_Modified"))
    ...

B/c if the field wasn't requested in the SPQuery.ViewFields, you probably can't get it (exceptions include Created field, ID field)

edited Oct 15 '12 at 17:24

Paul Fleming

24,238
8
76
113

answered Apr 13 '11 at 19:07

Perry33

11
1

score 1 · Answer 4 · answered Mar 18 '09 at 15:04

1

The "Title" field may exist in the list but not in the default view. Can you do this?

foreach (var item in list.Items) Console.WriteLine((string)item["Title"]);

answered Mar 18 '09 at 15:04

vitule

15,612
11
33
37

Any attempt to reference item["Title"] throws that exception. – Ries Mar 20 '09 at 16:05
I am facing same problem – Shyam sundar shah Jul 28 '13 at 08:17

score 0 · Answer 5 · edited Oct 15 '12 at 17:24

I don't know why, but I created a GridView from SPListItemCollection as a DataSource. I had the same error. But I tried to get the dataTable from collection:

SPListItemCollection res = da.getAllItems();
DataTable dt = res.GetDataTable();

And then I see in my GridView that field that contains titles of list items is called "LinkTitle". So, I rewrited my code: SPListItemCollection res = da.getAllItems();

gridView.DataSource = res.Cast<SPListItem>().Select(a=> a["LinkTitle"] );
gridView.DataBind();

And everything works fine :)

Greg Sansom · Answer 6 · 2011-03-08T02:33:13.433

The "Title" field is not (by default) available in the default view. If you have a look at the view settings page, Title is checked, but it is labeled as being "linked to item with edit menu".

The field exposed by the view is actually named "LinkTitle" (you can confirm this by enumerating list.DefaultView.ViewFields).

The solution to your problem is simply to replace item.Title with item["LinkTitle"].ToString().

Xaris Fytrakis · Answer 7 · 2021-03-05T08:32:30.133

0

This problem can occure if you rename an already existing Column. Try deleting it and create a new one with the same name.

Or in another case that occured to me, I had accidentally wrote a letter of the column name in Greek! eg. "ΙsCooperation" Ι was a greek character

edited Mar 05 '21 at 08:32

answered Oct 29 '20 at 15:06

Xaris Fytrakis

487
6
16

SharePoint ListItem Error: "Value does not fall within the expected range"

7 Answers7