I am trying to connect create a chat bot using power virtual agents, so i need to connect PVA to Azure SQL server using power automate to execute the query so that the bot will fetch the answers, i need help in connecting PVA to azure SQL database.
Hi @Subha ,
Thanks for using the PVA! 🙂
You can question the user to get the variables and parameters that you want to use inside your Query like "Project name, Status, or something like that".
After to question to the user, you can create an action calling Power Automate.
Inside your Power Automate, you can create inputs (parameters) that you want to receive.
Inside your Power Automate, you can create a connector SQL Server: https://flow.microsoft.com/pt-br/connectors/shared_sql/sql-server/
And the result, you can use markdowns to return using outputs to the PVA: https://docs.microsoft.com/en-us/power-automate/approvals-markdown-support
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.
I am facing issues in connecting to the sql server using power automate.. so step wise instructions would be helpful or any blog which clearly explains about the connection to the SQL server would be great . Thanks
Check out new user group experience and if you are a leader please create your group
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Check out how to claim yours today!