Sharepoint: Create Notification when SQL Table is Inserted Updated

AlanSmith4572 6 Reputation points
2021-01-08T20:03:04.907+00:00

Is there method in Sharepoint 2019 to create a Notification when SQL Table is inserted or edited?

This following article mentions how to create a Workflow, I want to create a Notification

We are trying to use the Adminstrative Menu options, rather than using CSOM Api. (So anyone not only developers can customize)

https://social.technet.microsoft.com/Forums/systemcenter/en-US/2dc082ec-3c4f-4233-8ca7-e8c7dcd34746/sharepoint-workflow-sql-data?forum=sharepointadminprevious

54974-image.png

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,190 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,482 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,405 questions
SharePoint Server Development
SharePoint Server Development
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Development: The process of researching, productizing, and refining new or existing technologies.
1,565 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,783 questions
{count} votes

1 answer

Sort by: Most helpful
  1. MichaelHan-MSFT 18,016 Reputation points
    2021-01-11T06:26:15.773+00:00

    Hi @AlanSmith4572 ,

    You could refer to that article create a Workflow, then in the workflow add the action Send an Email to send notification.

    55073-image.png

    Also, you could use the Alert me feature to send notifiactions (You need to create a column which type is external data in the list/library):

    https://support.microsoft.com/en-us/office/create-an-alert-to-get-notified-when-a-file-or-folder-changes-in-sharepoint-e5a79e7b-a146-46da-a9ef-d65409ba8918#Pick_tab=SharePoint_Server_2010_-_2019


    If an Answer is helpful, please click "Accept Answer" and upvote it.
    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.

    0 comments No comments