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.?
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.
Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.
The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.