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: Power Up

This is pretty much essential to be able to interact with any well designed database.  Without it the ability to interact with many-to-many type relationships becomes ridiculously difficult unless all the data keeps within the 500 record limit.

 

 

 

Power Automate Staff
Status changed to: Planned
 
Level: Power Up

definitely needed.

Level: Power Up

I can't believe this is even a request. It seems this is such a clear need that I'm surprized it's not already implimented. This connection is useless without access to views and stored procedures.

Level 8

@AllenB, welcome to the new world of Minimum Viable Products 🙂

 

I agree fella, I hope they hurry up with this, it should have been part of release 1.

Level: Power Up

Throwing out my two cents, we need views!

Level: Powered On

Views and Stored Procedures. Not only in Azure but in on Premise MSSQL and also for the Oracle connector

Level: Power Up

most of our analysis is using SQL views so we need PowerApps to support SQL on premise views otherwise PowerApps wont be of us to us. thanks

Level: Power Up

Seriously?  Only tables? 

Level: Power Up

Great to see that MS plans to make it possible to use views from SQL. Any idea about timing? When will this be available?