Forum Discussion
Solved
Data Gateway and SQL Database Views
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.
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-only-Tables/idi-p/863
Regards,
Tiago Costa
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.
Has Microsoft been able to allow to build a PA app from on-premise sql view or from queries? And as far as getting calling store procedures from MS FLow an listing all the records in a view by using SQL\Get Rows function in MS FLow, would you be so kind of pointing me to this info and do you know if there is some sort of training courses to learn this? Please let me know. Thanks in advance.