Forum Discussion
Can anyone shed some light on what happened with SharePoint lists? SUPER slow to non-functional
Hi. We currently update a SP list using an Excel spreadsheet that compares new stuff to what's already in the list. Anything new in the spreadsheet that isn't in the list gets copied/pasted to the bottom of the list. That still works. But we also identify anything that needs to be removed (i.e., it's in the SP list but not in the updated Excel sheet, and the only way to transfer that info to the SharePoint list is to copy from the Excel sheet and paste into the SP list (grid view). Then the list can be filtered on flagged items to remove them. That part is no longer working.
Prior to June 2024, that process did work, albeit very slowly and poorly; could paste in only ~100 records at a time. Then in June, something changed with SP, and the look of list changed, but so did the performance - to the better! Still not 100% great, but way better than before. But, sometime during the first week of September, Microsoft rolled SharePoint back, and now I don't seem to be able to paste in anything. At all.
This is a major impact and setback to our processes. Does anyone have any information on what MS did and why? I've even got a ticket in with a Microsoft Support Escalation Engineer, and she said, "I have not found anything indicating why they made the change but I know they made a lot of changes to the Lists recently.". I appreciate any information folks may have - including a better way to update a SP list. Thank you!
Hello,
Thank you for sharing this. It sounds like you're dealing with a significant impact on your process due to recent changes in SharePoint Lists.
From what you've described, it seems that the update Microsoft made in June improved list performance temporarily but was subsequently rolled back in early September, causing your issues with pasting data. While it's frustrating that the Microsoft Support Engineer hasn’t been able to provide details on the exact changes, it's possible these adjustments are part of broader, ongoing updates to SharePoint and Lists.
In the meantime, here are a few suggestions that might help:
Smaller Batches
Power Automate
Data Import via Excel
Temporary Workaround
That said, since you already have an escalation ticket open with Microsoft, it's worth keeping in close contact with them to track progress on a potential fix. I hope some of these suggestions can serve as a temporary workaround until more information or an update is provided.
OludareF Thank you for your reply. I had posted this before our IT escalated the ticket to Microsoft. They did that, and the Microsoft folks got in touch with me and really tried to help with the situation. They also recommended the smaller batches and especially Power Automate solutions. The smaller batches did work, not as efficiently as the improved SharePoint did, but it will enable us to limp along until I can get the Power Automate solution implemented.
Thank you again for replying - I'm sure if MS hadn't stepped in yesterday, your suggestion of smaller batches would have prompted me to try that and gotten me where I am today. Thank you!
- You're very welcome, and I’m glad to hear that Microsoft was able to assist you with the situation. It’s great that the smaller batch approach has provided some relief in the meantime, and I’m confident that once Power Automate is fully implemented, it will streamline the process even further.
If you need any additional support as you transition to the Power Automate solution, I’d be happy to recommend an expert who can help ensure a smooth implementation. Please don’t hesitate to reach out, and I wish you continued success with your SharePoint improvements!
