Power Automate Ideas

americanmussel · ‎11-14-2017

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" }

Erick · ‎01-18-2018

When a flow is created with connections both to on-premise systems and cloud based systems there is a risk of data leakage. For example let's say that a flow gets data from a SharePoint site and exports it to a SQL Server database in the cloud. Let's suppose that this flow runs everytime a file is uploaded on a SharePoint library. If the flow is assigned to several owners and one of them leaves the company this guy will loose access to the on-prem SharePoint but not to the database that is in the cloud. The flow can continue running and copy data to the external database without no one being aware. To prevent that from happening I suggest that a special permission is given to the SQL Server connector : allow connection to cloud base databases or not. This permission would be manage by company administrators at the same level than Data Loss Policies.

Share your ideas and vote for future features

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

Prevent data breach with the SQL Server connector

Helpful resources

Make it possible to duplicate actions in a Flow

Copy action - time saver

Sharepoint Create Folder

set item level security in SharePoint

Need Triggers for Dynamics 365 Operation