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.?
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Learn from the top Power BI, Power Apps, Power Automate & Power Virtual Agents experts!
Did you know that you could restore a deleted flow? Check out this helpful article.