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,
Invoke a Power Automate flow to execute the SQL Query and return the results in a format the bot can use. There is a specific action you can use in a flow to execute a SQL query. You can even include one or more named parameters. When the results are returned you will need to format them as a string to return them to the BOT. If you need to return a table of data check out the markdown characters available. Format your bot messages - Teams | Microsoft Docs
Learn how to respond rapidly to your customers and employees at scale, using intelligent conversational chatbots.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
6 | |
5 | |
4 | |
2 | |
1 |
User | Count |
---|---|
15 | |
4 | |
3 | |
3 | |
2 |