SharePoint 2019 Business Connectivity Services (BCS) - capturing "Last Modified" & "Last Modified By"

Question

My team is working with SharePoint 2019 (on prem) BCS.

We are using SQL Server DB Table and using SharePoint as presentation layer. Read & write are working as expected, using a service account.

Now, I am wondering how can we capture 'Last Modified" and "Last Modified by" fields? Ideally I would like these fields to be stored in SQL Server Table.

Another question would be - how can I keep basic info about 'version history'?

Answer 1

Based on your description, I understand that you want to show SQL server database table in the SharePoint external list.

In the external list, "Last Modified" and "Last Modified by" fields cannot be captured from SQL server database table. These fields are filled in by system.

Based on this Microsoft article, Versioning is not supported in the external list.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.