cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Share your ideas and vote for future features

Suggest an idea
americanmussel

Support "Execute a SQL query" action through an on-premises data gateway

Submitted on ‎11-14-2017 06:31 PM Submitted by Advocate I on ‎11-14-2017 06:31 PM
The “Execute a SQL query” action is not currently supported in Microsoft Flow using an on-premises gateway connection.    The "Get rows" action allows users to pull records from a single table, but there is currently no way to pull records from multiple on-prem SQL tables. To avoid executing a complex query from Flow, some users have combined "Execute a stored procedure" to build a single table with "Get rows" to query it, but this workflow is also not supported with an on-premises data gateway.   Adding this functionality would create a great deal of opportunities for automation of testing and reporting on complex data structures. Executing a Flow with this connector yields the following error: {    "status" :  400 ,    "message" :  "Gateway ExecutePassThroughNativeQueryAsync\r\ncli entRequestId: 0a3e8a93-45a6-4f29-ad28-d4375b6963a7 " ,    "source" :  "sqlconnectionprovider-westus.tip0-westus.p.azurew ebsites.net" }       ... View more
Status: New
See more ideas labeled with:
26 Comments (26 New)
yoshihirok

Get values of a row of array with no-expression

Submitted on ‎08-16-2018 05:35 PM Submitted by Memorable Member on ‎08-16-2018 05:35 PM
I want to get values of a row of array with no-expression. for reduce the expressions, for reduce Apply-to-each, for easy, for simple.   Scenario: - Get some values from SQL Server by multiple queries, and use these values without the apply-to-each operations   Problem: - A query of SQL Server output a recordset as array, even if only one row. - the query like: select top 1 Name, Value from table1 order by orderid - To use these value, need to the 'Apply-to-each' operation, and use each value in the scope. - When there are multiple queries, need to Nested 'Apply-to-each' operations, - In each scope of 'Apply-to-each' operation, can use each value with no-expresson    Therefore: - I want the operation 'Get values of a row of array'   Regards, Yoshihiro Kawabata ... View more
Status: New
See more ideas labeled with:
  • SQL
1 Comment (1 New)
Labels

Helpful resources