Skip to main content

Notifications

Announcements

No record found.

Power Platform Community / Forums / General / SQL Server how to run ...
General
Unanswered

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

Posted on by 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:
  • HenryJammes Profile Picture
    HenryJammes on at
    Re: SQL Server how to run a select statement in PVA and power automate

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

     

    HenryJammes_0-1683191347244.png

     

  • SwapnaNalimela Profile Picture
    SwapnaNalimela 2 on at
    Re: SQL Server how to run a select statement in PVA and power automate

    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.

  • Pstork1 Profile Picture
    Pstork1 1,954 on at
    Re: SQL Server how to run a select statement in PVA and power automate

    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

Helpful resources

Quick Links

Exciting News for Copilot Studio Communi…

Get ready to experience a whole new level of engagement with the Copilot Studio…

Celebrating the May Super User of the…

LaurensM is an exceptional contributor to the Power Platform Community…

Check out the Copilot Studio Cookbook…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

Leaderboard

#1
renatoromao Profile Picture

renatoromao 6,459

#2
Pstork1 Profile Picture

Pstork1 1,954

#3
Expiscornovus Profile Picture

Expiscornovus 1,648