SharePoint External List Limitations

external list limitations sharepoint 2013

In this article, we will explore SharePoint External List Limitations in SharePoint 2013 and SharePoint 2010.


What’s the External List?

The external list is a type of SharePoint list that used to hold data from external data sources.

You might also like to read how to Create External Content Type in SharePoint Designer 2013

External list limitations SharePoint 2013

Before we getting started, please let me first raise one of the major SharePoint External List Limitations that is Business Connectivity Service Throttle.

So if the number of retrieving items becomes more than 2000 items, the list view will not be rendered and you will get this error:

Database Connector has throttled the response. The response from database contains more than ‘2000’ rows. The maximum number of rows that can be read through Database Connector is ‘2000’. The limit can be changed via the ‘Set-SPBusinessDataCatalogThrottleConfig’ cmdlet.

In this case, any solution or web part read data from an external list will not working properly, and you will face a performance issue and the external list may be stuck to render!

How to get Business Connectivity Service Throttle?

To get the BCS Throttle, you should run the below cmdlet

Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy (Get-SPServiceApplicationProxy | where {$_.TypeName -eq ('Business Data Connectivity Service Application Proxy')})
SharePoint External List Limitations

How to exceed Business Connectivity Service Throttle?

Fortunately, you can exceed the default max limit (2.000 items) using Set-SPBusinessDataCatalogThrottleConfig cmdlet.

$BCSProxy = Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy (Get-SPServiceApplicationProxy | where {$_.TypeName -eq ('Business Data Connectivity Service Application Proxy')})
$BCSProxy | Set-SPBusinessDataCatalogThrottleConfig -Maximum 1000000 -Default 50000
$BCSProxy

However, you should be first aware of the following:

  • Exceeding the default max size is not recommended based on Microsoft support reply. Moreover,
  • The export option will work only for 2000 items.
  • You may still face a performance issue specifically if you increase the Item limit in List View setting. (I tried to set Item limit to 300 for each page and the list stuck in the second navigation)

So it’s strongly recommended to use Filter Parameter Configuration for large data to filter the returned data during configuring the ECT in the Read List Operation.

Filter Parmater Configuration

Additional SharePoint External List Limitations

Beside the the above mentioned major limitation, in this section, we will list most of common limitations for External List in SharePoint 2013 and SharePoint 2010:

  1. The datasheet view is not available.
  2. No Datasheet view means the Inline Editing is not available.
  3. Export to Excel option is not available.
  4. Workflows cannot be configured for External Lists.
    • Unfortunately, you cannot actually run a workflow on an external list.
    • You neither have the option to define any workflows nor can you actually start one. External List = No Workflows!
  5. Cannot create Information Management Policies (IRM).
  6. No version or version history
    • You cannot enable the version, and there is no version history for an External List.
  7. No Rating Widget.
    • You cannot rate any items in an external list.
  8. Can’t create Visio Diagrams.
  9. Open with Access/Open with Project is not supported
  10. There is not REST access via ListData.svc for External Lists.
  11. All WCF services are not available.
  12. There are not Lookups fields.
    • Unfortunately,  the only thing that you can do a lookup on in an external list is on the ID column, anything else and you are out of luck.
  13. The Send To operations is not available.
  14. Events Receivers are not supported.
  15. LINQ does not support external lists
  16. No Item Level Permissions
  17. No item or field level validation or Formula supported
  18. Document templates are not supported.
  19. Alerts are not supported.
  20. Attachments will not be available.
  21. Additional data connections in InfoPath 2010 list forms not supported.
  22. U2U CAML Query builder doesn’t work!.
  23. No Check-In / Checks Out options.
  24. Drafts of items are not supported.
  25. No, Write support for the BLOB.
  26. Metadata-based navigation is not supported.
  27. No RSS Feeds.

SharePoint 2013 External List Improvements

  • Supports OData.
  • Export to Excel option.
  • Alert Option.
  • Event Receiver on external lists
  • Support for SharePoint Apps.
  • Sorting external lists.
  • Data Source Filtering.

Conclusion

In conclusion, we have learned what’s the SharePoint External List and we have listed the most common SharePoint External List Limitations in SharePoint 2010 and SharePoint 2013. We have also explained how to get and exceed the BCS threshold.

Applies To

  • SharePoint 2013.
  • SharePoint 2010.
See Also
Reference

6 thoughts on “SharePoint External List Limitations”

  1. Pingback: SharePoint 2019: SQL Server Recommendations | SPGeeks

Leave a Reply