Execute SQL Query(V2) error

[GhassSD]

When executing a query this error appear:

Any solution

[manuelstgomes]

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

[GhassSD]

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 · Accepted solution]

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

[Mark-Shenouda]

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]

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

[PrajwalShambhu]

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.

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]

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 !).