cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Migrated_User

PowerApps must also see SQL Azure Queries, not only Tables

Submitted by Solution Sage on ‎04-26-2016 03:01 AM

On making the connection, I only see Tables, not Queries. This cannot be workable as Tables usually have many IDs and IDs are meaningless, Connection to Queries is a must: same as Excel and Power BI.

Yahya shared this idea  ·   ·

Status: Completed

 Using SQL Views in PowerApps is now available.  See the blog to find out more: https://powerapps.microsoft.com/en-us/blog/using-sql-server-views-in-powerapps/

154 Comments (154 New)
Comments
Meneghino
Community Champion
Community Champion
‎02-01-2018 02:53 AM

Important: you will need to Refresh each view that depends on a table that you patch/update etc. in PowerApps. This is currently not done in the background.  It would be good to update the blog and documentation with this information.

EvanChakiMSFT
Power Apps
Power Apps
‎02-01-2018 07:11 AM
Status changed to: Completed

 Using SQL Views in PowerApps is now available.  See the blog to find out more: https://powerapps.microsoft.com/en-us/blog/using-sql-server-views-in-powerapps/

DavesTechTips
Super User
Super User
‎08-26-2019 07:46 AM

Hello everyone,

 

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.

DookieDuke
New Member
‎05-03-2020 03:04 AM

The same here: I linked my app with an SQL database but this is impossible to see my stored procedures in addition to the tables. So sad. Workaround solutions are less powerful, because of time to transport the data and to recreate somewhere a set of them.