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
Solved! Go to 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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi @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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi @sujan
Did you resolved the issue? Also remember Execute a SQL Query Power Action step will NOT work for on-premise SQL instances.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi All,
I applied filter on Get Rows action, it solved my problem.
Thanks,
Sujanakar Reddy
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.
User | Count |
---|---|
26 | |
25 | |
25 | |
22 | |
15 |
User | Count |
---|---|
50 | |
37 | |
36 | |
31 | |
30 |