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'.'.
Solved! Go to Solution.
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.
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.?