Scenario: We have a large document library (roughly 122k documents/folders), housing most of our sales documents. We use Power Automate (replacing SP Designer 2013 workflows) to dynamically add metadata to documents and auto-folder documents to associate them with specific deals. We now have 65 columns in the library, around 15 of which are no longer needed (many of which were auto-created designer workflow fields). We have indexed columns, set up views, and have Flows keeping the library in relatively good condition, and are using modern view and foldering to manage the >5,000 item limitations. I have SharePoint admin & am permissioned properly to modify the library.
Issue: We are trying to clean up the library (delete columns, consolidate content types, etc.) and are running into dead ends with managing the library. To delete columns, we have so far tried:
- Standard SharePoint online column edit --> delete - running into the classic "exceeds the list view enforced by the administrator". Being SharePoint online, we're not able to temporarily override the list view cap to work around this one. .
- Open library in MS Access & delete field - Also stating that the library is too large
- Powershell (referencing this script)- After working through the 403 (forbidden) errors, I get the same error message as the standard, UI-based delete ("... exceeds the list view enforced by the administrator".
BIG disclaimer: I'm not a programmer, but can fumble/fake my way through PS code, and am moderately proficient with Flow and SharePoint (and SP admin).
I figure there has to be a way to delete columns. Any creative minds out there have another way of modifying a library that is agnostic to the number of documents/folders?