Answered

SQL Server Execute Stored Procedure V2 error

(0) Share

Report

Posted on by DR-01081351-0

Hello,

I am just getting started using Power Automate and Power Apps (so real NEWBIE) and I am trying to use the SQL Server Execute Stored Procedure (V2) using a very simple SP (insert a new row in a table). After I select the server, database and stored procedure I get an error message : 'body" is required (see image below). What am I doing wrong?

I know my on premise gateway connection is working because I tested it with a SQL Server Insert row and that was working.

Any help/guidance would be much appreviated.

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (13)

Answers (1)

Sort by

fchopo 8,003 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hello @Dom32
Which type of authentication do you use to connect to SQL Server? Maybe it's something with the connection. Could you provide more detailed information?
Ferran

Was this reply helpful? Yes No
DR-01081351-0 on at

Like (0)

Report
Copy link

Link copied!

Hi Ferran

the connection is using SQL authentication. I was able to get the Execute Stored Procedure V2 working using a Power Automate button.

I just find it strange that it is not working with a Power Apps (even though they have a template for it). I would like to be able to trigger the SP within a Power App form.

thanks!

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hello @Dom32
Really weird. Have you tested it with another SP just in case there's something with it? There's an excellent video on how to call SP from PowerApps here: https://powerusers.microsoft.com/t5/Webinars-and-Video-Gallery/Calling-Stored-Procedures-from-within-PowerApps/m-p/161897
Hope it helps!
Ferran

Was this reply helpful? Yes No
DR-01081351-0 on at

Like (0)

Report
Copy link

Link copied!

Hello group

well, I added a variable as input in my stored procedure to update one of the field and everything started working as expected. I guess I should have pay more attention to the "requirements" 🙂

Initially I was trying to execute the SP without a variable.

Sorry for your time, love this Power Automate stuff.

D

Was this reply helpful? Yes No
dvtkiet 6 on at

Like (0)

Report
Copy link

Link copied!

I have the same problem, and my stored procedure doesn't need any input parameter (it creates a table from different tables.
The stored procedure executes well in SQL; but when I call the stored procedure using Execute Stored Procedure V2, I get the error "Body is required."
Thank you in advance for your help.

Was this reply helpful? Yes No
Verified answer

DR-01081351-0 on at

Like (0)

Report
Copy link

Link copied!

Hi dvtkiet

I think the stored procedured requires at least one "INPUT" per the online documentation. I added an input to my stored procedured and I was able to use it with a button no problem.

https://docs.microsoft.com/en-us/connectors/sql/#execute-stored-procedure-(v2)

Hope it works for you.

Cheers

Was this reply helpful? Yes No
dvtkiet 6 on at

Like (0)

Report
Copy link

Link copied!

Hi @Dom32, It works. Thank you so much for your help and the documentation.

Was this reply helpful? Yes No
Zap174 167 on at

Like (0)

Report
Copy link

Link copied!

Hi @dvtkiet
How did you add an input to your stored procedure? Could I see an example?

Was this reply helpful? Yes No
DR-01081351-0 on at

Like (1)

Report
Copy link

Link copied!

This is how I added my INPUT to my stored procedures
then in Powerautomate, the INPUT will be listed

Was this reply helpful? Yes No
Zap174 167 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much!

Was this reply helpful? Yes No