cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Connecting PVA and SQL server using power automate

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.

3 REPLIES 3
Highlighted
Super User
Super User

Re: Connecting PVA and SQL swerver using power automate

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.

Thanks!
Renato Romão
https://www.linkedin.com/in/renatoromao/

 


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Power Virtual Agents Course: https://udemy.com/pva-beginners
Highlighted
Regular Visitor

Re: Connecting PVA and SQL swerver using power automate

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

Highlighted
Super User
Super User

Re: Connecting PVA and SQL swerver using power automate

@Subha ,

 

Can you take some pictures of your workflow, please?

 

---

Thanks!

Renato Romão

https://www.linkedin.com/in/renatoromao/


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Power Virtual Agents Course: https://udemy.com/pva-beginners

Helpful resources

Announcements
BOT Sharing Gallery

BOT Sharing Gallery is now LIVE!

Want to Share a ChatBot? Post it in our Bot Sharing Gallery!

PVA Use the Community!

Are you new to the Power Virtual Agents Community?

Check out Using the Community to learn more!

PVA Thumb

Video of the Week

Travel Approval Bot

PVA Thumb

Video of the Week

Returning an image as a message

Top Solution Authors
Users online (6,867)