Now that you have a SharePoint list (See post from March1st) populated with external data from a SQL Server table, what can you do with it and what limitations do you have to deal with? Perhaps it is easier to say that the External List works just like any other SharePoint list except for the following:
- You cannot switch to datasheet mode to edit the data in the list. However, given the edit operation permmission, you can edit individual records by using the record dropdown and selecting Edit.
- You cannot create new columns for the list. If you need to add columns, you must update the SQL Server table and rebuild the External Content Type and the External List. On the other hand, if you want to remove some of the column or filter the rows, you can either modify the default view or create additional views to meet that need. (Next time we will look at adding external data columns to a custom list so that you can have columns unique to the SharePoint side of the list.)
- You cannot export the data to Excel or open the data with Access. Of course, both of these Microsoft tools support the use of data connections which could directly connect to the same SQL tables without the extra stop of going through a SharePoint list.
- You can not define an RSS Feed to notify someone when a change occurs to the list.
- You cannot assign a workflow to the list.
- You cannot create folders and store items in individual folders. This limitation makes sense if you remember that the data coming from a table or view in SQL Server is essentially a flat file.
- You cannot have attachments to individual records.
- There is no version history for changes to items in an External List.
- You cannot define item level permissions to items in an External List.
- Surprisingly and disappointingly, External Lists do not let you modify the form used to edit the list items. This limitation is the one that bothered me the most.
Next time we will look more at using External Content Types in conjunction with Custom Lists to see how well they work there.