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/
Important: you will need to Refresh each view that depends on a table that you patch/update etc. in PowerApps. This is currently not done in the background. It would be good to update the blog and documentation with this information.
Below are two videos dealing with advanced queries to SQL from PowerApps (using Flow).For SQL Azure you can use direct (native) queries:https://youtu.be/DII10gK715I
For on-premesis SQL servers, native queries are not supported from Flow (you will get an error: operation Execute Native Sql is currently not supported using an on-prem gateway connection), so we have to use stored procedures to accomplish the same:https://youtu.be/BAGBzI4zdww
Please let me know if you don't come right.
Dawid van HeerdenFollow on Twitter: @davestechtipsSubscribe to YouTube: https://www.youtube.com/davestechtips?sub_confirmation=1**If you found this reply helpful, please mark this as the answer to close the topic and make it easier to find for other people with similar questions.