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 · March 21, 2016 ·
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/
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
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 🙂
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 🙂
Confirmed, that actually worked. Now for how long....that's the real question. You the man, @monty241
Hurrah! Now the only thing left is to be able to patch null values to SQL Server columns.
Then the rest is detail.
Hi everyone. This seems to have been actually released as a feature now, so workarounds are no longer required.
Superb, Bravo to the PowerApps Team
Today should be an milestone of PowerApps development. Good to see supporting View !!
Thanks to MS Team