Feb 28 2017 12:41 PM
Can you use the PowerApps data gateway to connect to a view in a SQL database? From the testing I have done it appears you can only connect to tables.
Feb 28 2017 01:40 PM
SolutionNot 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...
Regards,
Tiago Costa
Jun 05 2017 04:32 PM
Voted, but Is there and ETA for this feature?
Aug 08 2017 01:19 PM
Bump!
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
Feb 28 2017 01:40 PM
SolutionNot 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...
Regards,
Tiago Costa