PowerApps must also see SQL Azure Queries, not only Tables

Status: Completed
by Community Support Team 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/

by Community Support Team
on ‎04-26-2016 03:01 AM

For that matter it should allow for the selection of SQL Views and Stored Procedures as well. I prefer not to provide access directly to the data tables, while PowerApps enforces quite the opposite.

on ‎04-30-2016 08:05 AM

Yes, access to views would allow us to decide which rows are brought into the apps 5000 limit.

by Maxibus
on ‎05-02-2016 11:22 AM

I would second the "need" for access to Views.

by stvcdms
on ‎05-06-2016 03:36 PM

This is incredibly important for the current apps we would like to develop. 

by Josefehse
on ‎05-26-2016 05:30 AM

This is a must have. It won't make sense to give access to a full table to users, most of the time. It is my first try with Azure SQL in PowerApps and it is quite disappointing that it is not there.

by dreeddri
on ‎06-03-2016 10:17 AM

Very important

by pjmendes
on ‎06-15-2016 06:51 AM

This is a very important need indeed!!

by Steelman70
on ‎06-29-2016 04:01 AM

This is very important for any serious business application

on ‎07-20-2016 01:12 AM

This should definetly be there, accessing the stored procedure and views through SQL Azure connection will be super helpful.

by Merlin
on ‎08-05-2016 11:14 AM

Queries would make PowerApps so much more powerfull 

Idea Statuses