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/

Comments
by PiebePost
on ‎08-30-2016 12:30 AM

Hello archanan,

 

I'm sorry for the late response, I've been hiking in a place without internet connection.

 

CRUD would certainly come in useful and I would find a use for it for sure but it would not be essential for me. Read-only scenarios however, are essential to my application.

by HansH
on ‎10-20-2016 12:50 AM

Giving the EOL of Silverlight and the Microsoft advise to use PowerApps, indeed better database inintegration (lookups, paging of large datasets, views, stored procedures etc) is a must.

by jcap
on ‎10-31-2016 01:44 AM

This is critical!

by MRCL
on ‎10-31-2016 04:51 PM

Read only would work for me. I need to download filtered data to local storage (many related tables). With that data updated I should be able to update the tables in the datasource with the new bulk update.

by Lain
on ‎11-03-2016 11:42 PM

Hi,

 

There really should be both (meaning CRUD). Moreover, as the original poster has suggested, we need the same capacity to manage the data sources as is in PowerBI.

 

The issue I've run into just now is that I want to use two tables, each located in a separate database, yet PowerApps - through not letting me specify a query or relationship prior to pulling the data, is trying to pull over two millions rows where only 200 are required. That's just not practical, and in not being able to use views, not even addressable in either read or CRUD format.

 

At this point in time, on-premise SQL just isn't usable for anything I can think of as we don't have any one application that works entirely from a single table. I'd be surprised if anyone does.

 

Cheers,

Lain

by Malm66
on ‎11-06-2016 03:20 AM
Having access to SQL Server views is a must have feature in my opinion
by drewc
on ‎11-10-2016 05:09 AM
Agreed...views are a must!
by drewc
on ‎11-10-2016 05:12 AM
The ability to write queries is also imperative in order to narrow the dataset.
by jhoward603
on ‎11-16-2016 05:08 AM

Spent an hour putting togehter an app and find out no views or more importantly Stored Procedures...

Cant use with out it... I specidically use it to get only relevant sales data and nearest nth accounts from a location (Lat/Log) point

 

 

 

 

by Meneghino
on ‎11-16-2016 05:13 AM

I think you can now call stored procedures via Microsoft Flow, that you can easily call from PowerApps...

https://flow.microsoft.com/en-us/blog/connecting-flow-sql-twilio/

Labels
Idea Statuses