web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Season of Giving Solutions is Here!
Explore Copilot Studio Forums, Blogs & Galleries!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio / SQL Server how to run ...
Copilot Studio
Unanswered

SQL Server how to run a select statement in PVA and power automate

(0) ShareShare
ReportReport
Posted on by CariRodz 15

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,

 

Categories:
General topics
I have the same question (0)
  • Pstork1 Profile Picture
    Pstork1 68,697 Most Valuable Professional on at

    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

    image.png

  • SwapnaNalimela Profile Picture
    SwapnaNalimela 2 on at

    Hi Team,

     

    while integrating Azure SQL to PVA i'm facing with below error, could anyone please help me to sort out this issue. and i am unable to load my table details in the table name field.

    Screenshot 2023-0...
  • HenryJammes Profile Picture
    HenryJammes on at

    Hi @SwapnaNalimela, can you check and fix the connection used by the SQL connector, clicking on the "...", like this?

     

    HenryJammes_0-1683191347244.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Season of Giving Solutions is Here!
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Copilot Studio

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 265 Super User 2025 Season 2

#2
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 240 Super User 2025 Season 2

#3
S-Venkadesh Profile Picture

S-Venkadesh 101 Moderator

Last 30 days Overall leaderboard

Featured topics

Announcing the "Microsoft Copilot Studio ❤️ MCP" lab
Welcome to the Copilot Studio forum!

Product updates

Microsoft Power Platform Community release plans