question

AlanSmith4572-9956 avatar image
0 Votes"
AlanSmith4572-9956 asked MichaelHan-MSFT commented

Sharepoint: Create Notification when SQL Table is Inserted Updated

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


sql-server-generaloffice-sharepoint-onlineoffice-sharepoint-server-administrationoffice-sharepoint-server-developmentoffice-sharepoint-server-customization
image.png (109.4 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AlanSmith4572-9956,

Is there anything update? If my answer if helpful to you, please click "Accept Answer" and upvote it.

0 Votes 0 ·

1 Answer

MichaelHan-MSFT avatar image
0 Votes"
MichaelHan-MSFT answered

Hi @AlanSmith4572-9956,

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.



image.png (34.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.