cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GhassSD
Helper III
Helper III

Execute SQL Query(V2) error

When executing a query this error appear:

GhassSD_1-1600332516066.png

Any solution

1 ACCEPTED SOLUTION

Accepted Solutions
abm
Super User
Super User

Hi @GhassSD 

 

The “Execute a SQL query” action is not currently supported in Microsoft Flow using an on-premises gateway connection. 

 

Please vote for this idea.

 

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Support-quot-Execute-a-SQL-query-quot-actio...

 

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

7 REPLIES 7
manuelstgomes
Super User
Super User

Hi @GhassSD 

 

This can be anything. Can you please share the Power Automate and obfuscate anything private that you can't share so that I can have a better understanding of what you're trying to do and the issues.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Hi @manuelstgomes,

 

Thanks for your reply,

When i am trying to execute a SQL Query(V2) (wherever in the begin, middle or end of the flow), directly when i choose the database, this error appear

 

 

abm
Super User
Super User

Hi @GhassSD 

 

The “Execute a SQL query” action is not currently supported in Microsoft Flow using an on-premises gateway connection. 

 

Please vote for this idea.

 

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Support-quot-Execute-a-SQL-query-quot-actio...

 

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
Mark-Shenouda
Microsoft
Microsoft

Hi @GhassSD 

 

You can try using "Execute Stored Procedure" Action instead, and convert the native query to stored procedures.

Also find below link for the Connector documentation and limits 
https://docs.microsoft.com/en-us/connectors/sql/#known-issues-and-limitations 

 

Best Regards

Mark 

abm
Super User
Super User

Hi @GhassSD 

 

If your problem has solved, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

 

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
PrajwalShambhu
Regular Visitor

I'm trying to run execute Stored Procedure Action on the Power Automate workflow, however in the design time, right after providing the SQL server and Database name, Stored Procedure list not appearing and throwing the below error. Not sure though it has go something to to do with respect to the permissions.

 

PrajwalShambhu_0-1629911502515.png

PrajwalShambhu_1-1629911540292.png

 

 

I'm connecting to Azure SQl database, and I can confirm the trigger of Power Automate Flow based when new item is created in the DB, in addition I confirm the following checks, and so far no luck.

 

  • I can access the Database and the underlying stored procedures through SQL Management Studio.
  • I can execute the Procedure via SQL management studio without any issue.

Expect the above checks, not sure what else i need to verify and possibly missing from my end, appreciate if someone could shed some lights on to help me resolve the issue.

 

Thanks in advance.

 

Cheers,

Prajwal Shambhu

mthaker
Helper I
Helper I

I am also facing same issue.

 

Can anyone provide clarity on how to use or say what is the purpose of providing this option 'execute a sql query (v2)' in Power Apps ? (since one can't use it !).

 

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.

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.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (3,108)