Issue viewing SharePoint List: Unknown render failure. Invalid statement, ResultCode: 1

Question

I have a Microsoft SharePoint site that my team uses. I created a list in order to store alerts that are automatically added using Power Automate. The list has columns Title, location, Date/time, category, and a hidden year-month column. I added the list as a tab on our Teams chat for each of access.

A few days ago, someone on my team mentioned that the list was down on Teams, yet I was able to view it online. After going through the settings, I saw the following message:

At the time, I had two views: an all items view, and a calendar view. Neither of these was filtered, so I understand the cause. Additionally, neither of my columns were indexed either. So after some research, it appears breaking this threshold was the reason it wasn't loading it Teams. So first, I indexed two columns that I used to group and occasionally filter on, which was Date/Time and location. I still could not view it on Teams, and nothing seemed to change for viewing it online.

Next, I saw that I should try to split the views so each one isn't over the 5000 item threshold. So, I created views for quarterly views for the year (Q1,Q2, etc) and removed the all items view, as well as the calendar view.

But now, I can view the quarter views on Teams, but now I get the following error for SharePoint online every time I open it:

(there is a correlationID below the retry button, not sure if it's confidential or not so I chose not to include it intentionally. If that can be useful in anyway, please let me know!!!)

Now, I've tried that retry button a dozen times, tried removing SharePoint from my browser data, nothing. But the strange thing is, when I swap to classic SharePoint and try to view the list, it works fine. Even though when I check my settings, the item threshold error is still showing, and I know it's updating because I get new alerts daily and the number keeps climbing.

How can i resolve the viewing the list on modern SharePoint, AND remove that item threshold error from my settings?

Thank you in advance!!!

Answer 1

Dear @Joris,

Thank you for reaching out to Microsoft Q&A forum. We are happy to assist.

Regarding the issue “Error: Invalid statement, ResultCode: 1”, below are suggestions that have been confirmed to resolve similar cases reported by other users:

Please try navigating to List Settings > Advanced Settings > Offline and Sync, and set this option to No.

【Invalid statement, ResultCode: 1】 Ｗhen I refresh the Sharepoint

Additionally, the following article may be helpful for understanding and managing scenarios related to the List View Threshold limit in SharePoint:

• Working with the List View Threshold limit for all versions of SharePoint
• "The number of items in this list exceeds the list view threshold" when you view lists in Microsoft…

In the meantime, if the issue persists, reoccurs, or appears to be tenant-wide (for example, if other users experience the same behavior), I recommend raising a support ticket. The Microsoft Support team has the appropriate tools and access to examine your tenant in detail and provide the most accurate guidance

The Global Admin can create a support ticket by sign in to the Microsoft 365 Admin Center > Support > Help & Support.  

For detailed instructions on how to get support, please refer to Get support - Microsoft 365 admin.   

Note: If you’re an end-user, please coordinate with your Office 365 Global Administrator to handle these steps.

I hope this information is helpful. If you need any further assistance, please feel free to reach out. We are here to help. Thank you very much for your understanding and cooperation.

---

If you found the answer useful, please click "Accepted Answer" and kindly give it an upvote.

If you have any follow-up questions, feel free to click "Comment" to continue the discussion.

Note: To receive email notifications related to this thread, please follow the steps in our documentation to enable email alerts.