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
dogjumpjump
Frequent Visitor

Definitely agreed with you, Luis8888.  

CDS is paid database based on number of user,  so MS can earn a lot on this phatform.. 

 

btw, CDS really has limitation comparing to MSSQL  directly connection.  I will not use it even if it is free

 

 

monty241
New Member
Workaround is to First use table with identical structure. Add it. Replace in database by view.
tmpsa
New Member

Hi monty241,

 

This is an interesting point. I will dive into your suggestion, it might be the solution to a lot of apperent limitations. Thanks for the advise 🙂

 

/Peter W

 

 

tmpsa
New Member

Hi monty241,

 

I have testet you principle, and it does work. By creating a table with the same structure as your view, setting up PowerApps to point to this table, and then later replacing it with a view will do the trick!

This is a major step in the right direction 🙂

 

/Peter W

BrendonBrooksP1
Post Patron

Confirmed, that actually worked. Now for how long....that's the real question. You the man, @monty241

Yahya
Kudo Kingpin

FINALLY! Thanks. 

Meneghino
Community Champion

Hurrah!  Now the only thing left is to be able to patch null values to SQL Server columns.

Then the rest is detail.

DavesTechTips
Super User

Hi everyone. This seems to have been actually released as a feature now, so workarounds are no longer required.

 

https://powerapps.microsoft.com/en-us/blog/using-sql-server-views-in-powerapps/?utm_content=buffer00...

 

 

 

Anonymous
Not applicable

Superb, Bravo to the PowerApps Team

dogjumpjump
Frequent Visitor

Today should be an milestone of PowerApps development.  Good to see supporting View !!

 

Thanks to MS Team