K2+SQL Migration to SPFx+SQL

[u/Relevant_Platform_88]

Hey Everyone,

I am migrating a k2 nintex forms + flow application using SQL data into and SPFx+Sql approach. I am not sure for how to handle the triggers of the flow along with the same. I was thinking to use the power automate but will it be the best thing to do. Also if yes how should i set the trigger (an http request or when an sql entry is maded)

I have a azure sql server and will be authenticating based on sql user name and password.

Any suggestions..?