Where is my SharePoint list gone?

[paNewby]

Background

Last week I created a PowerPoint App linked to a SharePoint tables called JobDetails and Contacts.

I also created virtually the same PA using SQL Server tables on Azure.

Because support for SQL is changing I decided to continue development on the SharePoint List based version.

I made some changes to the List Structure (added some fields etc), relinked to MS Access and uploaded data.

Next I tried to add the SharePoint List as an additional DataSource to my SQL Based app.

Help Needed

1.

The top left image shows the SQL Based PA where I tried adding SharePoint Lists called JobDetails and Contacts.

On the top right is the Sharepoint screen that shows both Lists.

The DataSource called eeJobDetails is one I started to add but decided to remove.

Where is the SharePoint List called JobDetails

2.

On the bottom are two screen prints showing the problem I am having with the app created last week.

The DataSources are JobDetails, Contacts and Office365 but when I open it a message appears in a large banner across the top that says "Failed to load JobDetails. The requested operation is invalid. Server response: Value does not fall within the expected range" (see banner at bottom of image below.

So although it shows JobDetails as a DataSource, it cannot find it, however I can go into SharePoint I can look at and modify it and I have successfully linked to it from MS Access and loaded data to it.

What has happened to my SharePoint List called JobDetails and how do I re-link PA to it?

[v-yamao-msft]

Hi PaNewby,

About the error message “Value does not fall within the expected range”, I think it is due to throttling limit set at List View Lookup Threshold settings in WebApplication.

To resolve this error, please try to open the SharePoint Central Administration site and click “Manage Web Application” link located under Application Management Group. Select the web application that has the problem. Select the “Resource Throttling” link under the “General Settings”

Navigate to List View Lookup Threshold section and change the value to a higher value depending on the count of Lookup, Person/Group, or workflow status field available in the list that caused the issue.

If you are still getting this issue, please show me the configuration of the list “JobDetails”.

If possible, please also provide your Session ID. You could get your session ID under File>Account>Diagnostics> Session Details.

Best regards,
Mabel Mao

[paNewby]

Hi,

Thanks for offering to help. In response:

1. open the SharePoint Central Administration site and click “Manage Web Application” link located under Application Management Group. Select the web application that has the problem. Select the “Resource Throttling” link under the “General Settings”

Navigate to List View Lookup Threshold section and change the value to a higher value depending on the count of Lookup, Person/Group, or workflow status field available in the list that caused the issue.

Afraid I am a Newby to all the functions associated with this so I don't know which/where the SharePoint Central Administration site is. I can't find what you're referring to anywhere in the places I looked.

If you are still getting this issue, please show me the configuration of the list “JobDetails”.

Following are the columns in JobList

Columns

A column stores information about each item in the list. The following columns are currently available in this list:

Column (click to edit) Type Required Id Integer   DetailId Number Jobnum Single line of text   JobName Single line of text   Customer Single line of text   Supervisor Single line of text   SupervisorMobile Single line of text   MapRef Single line of text   Activity Single line of text   Priority Number   WorkStarted Yes/No   WebWorkStarted Yes/No   DateRequested Date and Time   TimeRequested Date and Time   DatePlanned Date and Time   AssignedTo Single line of text   CompletedDate Date and Time   CompletedBy Single line of text   WebCompletedDate Date and Time   WebCompletedBy Single line of text   ActivityInstructions Multiple lines of text   Comments Multiple lines of text   QACheckedBy Single line of text   QACheckedOn Date and Time   QAComment Multiple lines of text   Attachment Hyperlink or Picture   StreetName Single line of text   Modified Date and Time   Created Date and Time   Created By Person or Group   Modified By Person or Group

If possible, please also provide your Session ID. You could get your session ID under File>Account>Diagnostics> Session Details.

Session ID: 39fce001-718c-817a-a581-cb7f94d5367d