cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FredericForest
Kudo Kingpin
Kudo Kingpin

Azure SQL ApiExecutionFailed

Hi,

I'm having a weird error trying to connect to an Azure SQL DB. Anyone has a clue ?Capture.PNG

  • that connexion can retrieve data from PowerApps
  • the user can run the stored procedure from SSMS
  • the user can see the stored procedure using sys.procedure
  • the error happens even with a db_owner login
  • the error occurs even with no firewall rules on the server and the DB (which I could have eleminated as an error source with the fact it can retrieve table data directly from Power App)
  • A similar error occurs when I try pasting an EXEC statement in a simple SQL Query component, but not when I use a Get Rows

Help ? Smiley LOL

 

1 ACCEPTED SOLUTION

Accepted Solutions

Ok, I've isolated the problem. And the issue kinda made sense. 

The procedure contained a query where two fields had the same name (yay for naming conventions). SSMS didn't have any problem with that, Flow did. Solution : just aliased my fields in the SELECT statement and everything is fine.

 

Hope this helps others!

View solution in original post

2 REPLIES 2
FredericForest
Kudo Kingpin
Kudo Kingpin

The error also applies to LogicApps...

Ok, I've isolated the problem. And the issue kinda made sense. 

The procedure contained a query where two fields had the same name (yay for naming conventions). SSMS didn't have any problem with that, Flow did. Solution : just aliased my fields in the SELECT statement and everything is fine.

 

Hope this helps others!

View solution in original post

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,820)