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.
2 REPLIES 2
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?