Microsoft Lists - "Unknown Render Failure". I'm now unable to access the document at all

Hi,

This isn't a total fix but try switching back to the classic sharepoint experience.

Thanks

Hi Andre,

Thank you so much for sharing this detailed workaround! I followed your guidance, and it worked seamlessly. Using Power BI to archive the data was incredibly helpful, and having everything readily accessible in Excel has given me much-needed flexibility while dealing with the 5000-item list limit.

Setting up the Power Automate flow to delete older items also worked perfectly. Your step-by-step instructions made it straightforward, and I was able to filter my list view for recent data without any issues.

That said, I feel Microsoft should investigate this issue further. While your workaround is effective, it’s clear that such a complex approach should not be necessary to prevent these errors. This limitation creates an unnecessary barrier for users managing large lists, and addressing it directly would provide a more seamless experience for everyone.

I truly appreciate the time and effort you took to share this solution; it made all the difference. Thanks again for your help!

Very Respectfully,

Damon

I've been experiencing the same issue and I've been able to find a workaround that's annoying but does work.

1. Archive data: You can still load and view the data from your 5000+ item MS list by loading the data into Power BI. If you're not familiar, Power BI desktop is free to download. In the program simply go to Get Data > More > ShaprePoint Online List. You then add your List Site to the URL bar, choose the correct list > Load. Once it's been loaded into Power BI, you can go to the Table View > right click on your list under the Data tab > Copy Table. Then open Excel and paste it into a blank spreadsheet. You now have access to all your data from that MS List
2. Delete some items from your list: You need to delete some items from your list so that you have less than 5000 items. You can use MS Power Automate to do this:
   • New Flow > Instant cloud flow
   • Select Manually trigger flow
   • Insert a new "Get Items" Step.
     • Site Address = your MS List address
     • List Name = Select your list from the dropdown
     • Select "Show All" under advanced parameters
     • Under "Filter Query", add a query that will isolate list items to delete. In my case, I deleted all items that were created before a specific date (June 2, 2024). So in my case, I added the query "Date lt '2024-06-02T00:00:00Z'". You would need to adjust your query based on the records you want to isolate for removal. AI software like ChatGPT can help you write this query
   • Insert a new "Apply to each" step
     • In the Output field, click on the lightning bolt and select the "body/value" under Get items
   • In the "Apply to each" section, add a "Delete item" step.
     • Add your MS List URL again and select your list name.
     • For the ID, click on the lightning bolt and select "ID" under "Get items"

Once you run this Power Automate Flow, you'll delete some items so that your MS list will again be under 5000. You should now be able to load the list, then go to Settings to address the issue. In my case, I just added a filter to the "All Items" view so that it only displayed items from the last 30 days. Once you've set this filter, you can then re-add the data you archived & deleted previously and your list should continue to load.

It's not an ideal workaround but it does work if you need a quick solution!

Hi I have almost the same issue

Unknown render failure. The number of items in the list exceeds the list view threshold, which is 5000 items. You can return to the list to select a different view or visit the following article for guidance on how to work around the issue: manage list and libraries with many items.

Correlation ID: 2e7e68a1-705a-4000-2879-4d29d074c5cb Kind frustrating, not able to change settings...

i was forced to create a new copied list.

Lists Settitngs, eternally LOADING: ..........

Dear Tom M_006,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

We are sorry to hear that you’re having trouble with opening your Microsoft list. I deeply understand the inconvenience caused and apologize for it.

We appreciate your understanding that sometimes the initial response may not resolve the problem immediately. However, we can work together to narrow down and resolve the situation. So, for further troubleshooting, could you please provide the information below:

1. Could you please let me know if you have tried opening the list in a different browser, in private or incognito mode?
2. Could you please let me know if other users are able to open the list?
3. Could you please let me know if this issue is occurring with this specific list or with all lists?
4. May I know what happens when you try to create a new list? Does it also experience the same issue?

Once again, I apologize for the inconvenience this has caused. We appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely,

Ralph Chawatama | Microsoft Community Moderator