cancel
Showing results for 
Search instead for 
Did you mean: 

PowerApps must also see SQL Azure Queries, not only Tables

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/

Comments
Level 10

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.

PowerApps Staff
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/

Level 10

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.