How to automate notifications using power automate when a new field is created in DB

So am working with a team of business intelligence analysts and they are to create a workflow for a certain task, my job now is to create a check notification for them, for instance in a field called PhoneNumber if the number of characters is supposed to be 11 and the user inputs 12, it should send a notification that wrong data set have been inputted

so my question is, which will do the work power automate or logic apps? Anyone that can shed light on this, please do, thank you

Solution

You can also do this using Azure Logic Apps.

- Fisrtly, you need to create an azure function or web app where you will check the condition of your phone number field.

- Then send the output of function or web app as Triggering http request or use can use Azure Service Bus Trigger to do so.

- Then you can use Azure Logic App to send notification to Outlook , Gmail, etc

Through Gmail:

enter image description here

Through Outlook:

enter image description here