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

Amandeep Singh 0 Reputation points
2023-01-19T18:06:49.52+00:00

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'?

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,175 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emily Du-MSFT 49,846 Reputation points Microsoft Vendor
    2023-01-20T09:02:27.82+00:00

    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.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.