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
Advocate I

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
Status changed to: Planned
 
New Member

definitely needed.

New Member

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.

Advocate III

@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.

New Member

Throwing out my two cents, we need views!

Regular Visitor

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

New Member

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

New Member

Seriously?  Only tables? 

New Member

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