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.
Read the latest about new experiences and capabilities in the Power Automate product blog.
If you are a small business ISV/Reseller, share your thoughts with our research team.