Feb 28 2017 12:41 PM
Feb 28 2017 01:40 PMSolution
Not yet possible.
Please vote here to have ir faster: https://powerusers.microsoft.com/t5/PowerApps-Ideas/PowerApps-must-also-see-SQL-Azure-Queries-not-on...
Aug 08 2017 01:19 PM
I think this is a fair question, and I would really appreciate an answer to it!
What is the ETA for on-premise gateway connections to SQL Server making connections to views? This is a really important feature that needs to be added, and an ETA would really help for planning (especially if the ETA is "never" so that I can start planning to use something other than PowerApps!).
Oct 19 2017 03:09 AM
Keep in mind that a stored procedure can be called from MS Flow.
Another option is to list all records in a view, by using the SQL\Get Rows function in MS Flow and entering the view name (case sensitive) as a custom value in the table name field. This seems to be undocumented, but it returns a list of records form the view.
Jan 19 2018 01:58 PM