Using Power Automate inserting data into SQL DB using stored procedure
About 14 years ago I started creating stored procedured in my first project. Now, I am creating flow (power automate) to insert data into SharePoint and via stored procedure into SQL DB. I am just asking my self, what would I do in the next 10 years? :P
Basically we do not need a stored procedure to inserting data into SQL DB, but with stored procedure I notice the different of the performance.
Here are some helpful links to get start building it:
- Building the Gateway
On-premises data gateway - Power Automate | Microsoft Docs
2. Adding Connections
3. Flows Templates with SQL
SQL Server | Microsoft Power Automate
Tips: do not forget giving the flow user enough permission into your SQL-DB.