cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sujan
Microsoft
Microsoft

Error saving flow with "Execute a SQL Query" action

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

FlowError.JPG

 

Thanks,

Sujanakar Reddy

1 ACCEPTED SOLUTION

Accepted Solutions
abm
Super User
Super User

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

View solution in original post

4 REPLIES 4
abm
Super User
Super User

Hi @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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
abm
Super User
Super User

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Hi 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.?

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

PWREduCon768x460.png

Join us at PWR EduCon - A Power Platform Conference

Learn from the top Power BI, Power Apps, Power Automate & Power Virtual Agents experts!

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Users online (3,680)