Forum Discussion

sbraun's avatar
sbraun
Occasional Reader
Sep 01, 2026

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 

No RepliesBe the first to reply