SOLVED

Data Gateway and SQL Database Views

%3CLINGO-SUB%20id%3D%22lingo-sub-49285%22%20slang%3D%22en-US%22%3EData%20Gateway%20and%20SQL%20Database%20Views%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-49285%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20you%20use%20the%20PowerApps%20data%20gateway%20to%20connect%20to%20a%20view%20in%20a%20SQL%20database%3F%20From%20the%20testing%20I%20have%20done%20it%20appears%20you%20can%20only%20connect%20to%20tables.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-49285%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-146931%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Gateway%20and%20SQL%20Database%20Views%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-146931%22%20slang%3D%22en-US%22%3EHas%20Microsoft%20been%20able%20to%20allow%20to%20build%20a%20PA%20app%20from%20on-premise%20sql%20view%20or%20from%20queries%3F%20And%20as%20far%20as%20getting%20calling%20store%20procedures%20from%20MS%20FLow%20an%20listing%20all%20the%20records%20in%20a%20view%20by%20using%20SQL%5CGet%20Rows%20function%20in%20MS%20FLow%2C%20would%20you%20be%20so%20kind%20of%20pointing%20me%20to%20this%20info%20and%20do%20you%20know%20if%20there%20is%20some%20sort%20of%20training%20courses%20to%20learn%20this%3F%20Please%20let%20me%20know.%20Thanks%20in%20advance.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-118133%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Gateway%20and%20SQL%20Database%20Views%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-118133%22%20slang%3D%22en-US%22%3E%3CP%3EKeep%20in%20mind%20that%20a%20stored%20procedure%20can%20be%20called%20from%20MS%20Flow.%3C%2FP%3E%3CP%3EAnother%20option%20is%20to%20list%20all%20records%20in%20a%20view%2C%20by%20using%20the%20SQL%5CGet%20Rows%20function%20in%20MS%20Flow%20and%20entering%20the%20view%20name%20(case%20sensitive)%20as%20a%20custom%20value%20in%20the%20table%20name%20field.%20This%20seems%20to%20be%20undocumented%2C%20but%20it%20returns%20a%20list%20of%20records%20form%20the%20view.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-94393%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Gateway%20and%20SQL%20Database%20Views%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-94393%22%20slang%3D%22en-US%22%3E%3CP%3EBump!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20this%20is%20a%20fair%20question%2C%20and%20I%20would%20really%20appreciate%20an%20answer%20to%20it!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20is%20the%20ETA%20for%20on-premise%20gateway%20connections%20to%20SQL%20Server%20making%20connections%20to%20views%3F%20%26nbsp%3BThis%20is%20a%20really%20important%20feature%20that%20needs%20to%20be%20added%2C%20and%20an%20ETA%20would%20really%20help%20for%20planning%20(especially%20if%20the%20ETA%20is%20%22never%22%20so%20that%20I%20can%20start%20planning%20to%20use%20something%20other%20than%20PowerApps!).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-75242%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Gateway%20and%20SQL%20Database%20Views%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-75242%22%20slang%3D%22en-US%22%3E%3CP%3EVoted%2C%20but%26nbsp%3BIs%20there%20and%20ETA%20for%20this%20feature%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-49481%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Gateway%20and%20SQL%20Database%20Views%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-49481%22%20slang%3D%22en-US%22%3E%3CP%3EVoting%20Done.%20Thank%20You%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-49294%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Gateway%20and%20SQL%20Database%20Views%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-49294%22%20slang%3D%22en-US%22%3E%3CP%3ENot%20yet%20possible.%3C%2FP%3E%3CP%3EPlease%20vote%20here%20to%20have%20ir%20faster%3A%20%3CA%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FPowerApps-Ideas%2FPowerApps-must-also-see-SQL-Azure-Queries-not-only-Tables%2Fidi-p%2F863%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FPowerApps-Ideas%2FPowerApps-must-also-see-SQL-Azure-Queries-not-only-Tables%2Fidi-p%2F863%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3ETiago%20Costa%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

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.

6 Replies
best response confirmed by Tiago Costa (MVP)
Solution

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...

 

Regards,

Tiago Costa

Voting Done. Thank You

Voted, but Is there and ETA for this feature?

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!).

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.