The idea is we have a mobile app backed by an azure database. I am wondering if there is any way to send a notification to the mobile app in case an element has been added to a specific table. The app will receive this notification, check what value has been inserted into that azure sql table and then make a decision whether to send a warning to the app user or not, like a push notification.
Can this be achieved and if yes how ? Any help is appreciated.
It is possible, you can use Azure Logic Apps which have many connectors for Azure services.
For an instance.
When an item is inserted in a particular table Azure SQL DB, it will trigger the job. You can connect that trigger to send SMS to the mobile.
You can also use Azure Functions but current it's doesn't have a SQL Trigger. There is a SO post which deals with the solution for Azure function
For some reference see my answer in this S.O
