Error saving flow with "Execute a SQL Query" action

[sujan]

Hi,

In my flow I am connecting to onpremise database, "Get rows" action is executing successfully but when I add "Execute SQL query" action flow is not saving. Below error is popedup while trying to save flow, not sure what is going wrong. Please guide.

Error while saving: Flow save failed with code 'MultipleErrorsOccurred' and message 'Multiple errors occurred: 'BadRequest,BadRequest'.'.

Flow screenshot

Thanks,

Sujanakar Reddy

[abm]

Hi @sujan 

Try the following:

Click on the three dots of the Execute a SQL Query step. Add a new connection.

Save the flow.

If you getting the same error then remove the * (start) from the select statement and mention the column names.

Thanks

[abm · Accepted solution]

Hi @sujan 

Did you resolved the issue? Also remember Execute a SQL Query Power Action step will NOT work for on-premise SQL instances.

Thanks

[sujan]

Hi All,

I applied filter on Get Rows action, it solved my problem.

Thanks,

Sujanakar Reddy

[vissvess]

Hi @sujan ,

Is there any roadmap for Execute SQL query connector to work for On-prem sqls server.?

Also, if I want to filter some rows in Get rows action, how it can be fulfilled.?

For instance, I want to filter like all rows after '20201-01-24T11:34:35Z' datetime in SQL datetime field.?