cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
PatrickInLaw
Level: Powered On

How to use the "Execute a SQL Query" part of the Azure SQL Connector in PowerApps?

So the SQL connector page seems to say that you can execute an SQL query through the PowerApps SQL Connector (see here: https://docs.microsoft.com/en-us/connectors/sql/#execute-a-sql-query ). The thing is, there's no guidance on how to actually do this. 

I've tried using both the ExecuteProcedure and GetItems operations in my Data (Items) field and Action (OnSelect) fields in designing my app, but both error out. There's no documentation on how to use these features beyond the minimal info on the connector page (given above). Can anyone shed more light on this?

Thank you!

-Patrick

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: How to use the "Execute a SQL Query" part of the Azure SQL Connector in PowerApps?

That feature of the connector only works in Microsoft Flow.



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
3 REPLIES 3
Super User
Super User

Re: How to use the "Execute a SQL Query" part of the Azure SQL Connector in PowerApps?

That feature of the connector only works in Microsoft Flow.



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
PatrickInLaw
Level: Powered On

Re: How to use the "Execute a SQL Query" part of the Azure SQL Connector in PowerApps?

Well that's no fun! So is Flow the only way to run a Query on a SQL DB and get the result into a PowerApp?

Dawidvh
Level 10

Re: How to use the "Execute a SQL Query" part of the Azure SQL Connector in PowerApps?

Hi @PatrickInLaw 

 

Below are two videos dealing with advanced queries to SQL from PowerApps (using Flow).
For SQL Azure you can use direct (native) queries:
https://youtu.be/DII10gK715I

 

For on-premesis SQL servers, native queries are not supported from Flow (you will get an error: operation Execute Native Sql is currently not supported using an on-prem gateway connection), so we have to use stored procedures to accomplish the same:
https://youtu.be/BAGBzI4zdww

 

Please let me know if you don't come right.

 

Dawid van Heerden
Follow on Twitter: @davestechtips
Subscribe to YouTube: https://www.youtube.com/davestechtips?sub_confirmation=1
**If you found this reply helpful, please mark this as the answer to close the topic and make it easier to find for other people with similar questions.

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Next Wednesday, September 18th at 8am PDT

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Users Online
Currently online: 211 members 4,133 guests
Please welcome our newest community members: