cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CariRodz
Frequent Visitor

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

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,

 

1 REPLY 1
Pstork1
Dual Super User III
Dual Super User III

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



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Planning-build-bot-2-5-20-768x460.png

New Year’s Resolution - Build Conversational Bots!

Access all of the Power Virtual Agents learning resources and join the January learning challenge.

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Users online (1,485)