Forum Discussion
BC SharePoint External File Storage view threshold exceeded
I recently set up External File Storage in Business Central. The view and folder structure were automatic, and the file links and communication between the two applications seems tenuous. Very quickly I ended up with a view threshold exceeded error in the SharePoint library. I was told that this is a known issue and Microsoft suggested the below mitigations. I plan to do the indexing when I don't have users logged in. I simplified the default view. I can't apply a retention policy in BC because the associated table is not included in the allowed tables. I'll give some thought to the Azure Blob storage option. My question, however, is what do they mean by "Partition attachments across multiple libraries"? This option intrigues me but how do I do that without breaking the file link between BC and SP? TIA.
Recommended Mitigations
Action | Purpose |
Index key columns on the BC-managed library | Enables filtered views past 5,000 |
Simplify default view (remove sorting/grouping/lookup columns) | Avoids unnecessary joins that trigger LVT |
Partition attachments across multiple libraries (per company/environment/year) | Keeps each library under threshold |
Apply BC attachment retention/archival | Controls long-term volume |
Consider Azure Blob/Files for high-volume scenarios | No equivalent list-view constraint |