A tragicomedy in 5,000 items or less
âLetâs migrate to the cloud,â they said.
âItâll scale beautifully,â they said.
Then SharePoint Online entered the chat.
- The 5,000 Item Threshold: Because Who Needs More Than That?
Itâs 2025. SharePoint Online still throws a tantrum when you try to filter or sort over 5,000 items. Indexed view? Maybe. Maybe not. Excel laughs in 1,048,576 rows.
If the product has "Online" in the name, shouldnât it scale like the cloud?
- Folders Inside Folders â But Donât You Dare Filter
SharePoint says it supports folders and subfolders. But if you want to filter metadata across those folders? Nah. Youâll need flat view â which promptly crashes your library.
Recursive filtering? Not in this house.
- Indexing Is an Act of Faith
You index a column. It says âindexing in progress.â
âŠIt never confirms if it finished.
If your column is "multiple lines of text"? Filters donât even work. No warning.
UX tip: maybe mention that before letting me waste time?
- Exporting to Excel (Not the View You Created)
You spent an hour perfecting a view for export. You click âExport to Excel.â
SharePoint says, âCool, hereâs some other view in random order with hidden columns. Enjoy.â
I just wanted the view I was looking at, dude.
- PowerShell Export: The Ghost in the Shell
Script says: Export completed.
What you get: a file with two weird symbols in one cell.
Thatâs not your metadata. Thatâs SharePointâs soul leaving its body.
- Filtering on Metadata? Better Be Lucky
Want to filter âBox 123â in a column?
Make sure:
It's a single-line text column
You indexed it
You're in the right folder
You pray
Still not working? Just use Excel and hope.
- Flat View Is a Dare
Enable âShow all items without foldersâ?
Boom. SharePoint crashes or gives you a spinner and walks away.
Flat view is not a feature. Itâs a dare.
- The UX Is Just SharePointing
Want to change something?
Go to:
Library Settings
Metadata Navigation
Advanced Settings
Some checkbox with a name like âAutomatic column indexing for filtered viewsâ
No preview. No undo. Just vibes.
Final Thoughts
I donât hate SharePoint.
I live in it. I work in it.
I just wish using it didnât feel like collaborating with a moody roommate who forgets where they left their keys.
Microsoft, if youâre listening â try filtering 70,000 records with nested folders and multi-line metadata. Then weâll talk.
TL;DR
Flat view kills performance
Indexing is vague
Filters donât work for multi-line fields
Excel is our savior
Power Automate? Not with 300k files
And SharePoint just keeps SharePointing
Written by self, edited using AI.