Hi guys,
I am looking for guidance on what is the best approach to using SQL Server, and the best approach to configure a flow in order to do CRUD operations.
I have connected my database to power automate and its working.
I now want to create a query to select who is my head of team as a test.
I am not sure how to build the flow using the SQL connectors and what is needed.
I have attempted using execute query only to realize it doesn't work with SQL server.
Please help, currently all methods I have tried/ google have just confused me more.
Thank you,