Power Platform Community Forum Thread Details

Execute Stored Procedure (V2) On premise Database wont update stored procedure query

Hello Folks,

I created a flow which will trigger an "Execute stored procedure (V2)" which has a query below.

ALTER PROCEDURE [dbo].[sp_update_submitted_powerapps]	
		@DocumentNo				NVARCHAR(200)		
AS
BEGIN TRANSACTION	
	UPDATE 
		tblRFPHeader
	SET 
		RFPStatusID = 2
	WHERE 
		DocumentNo IN(@DocumentNo)
COMMIT

I've been passing the parameter from PowerApps collections and parsing it to JSON format like 'DocNo-00001','DocNo-00002' . Please see the complete flow below.

In the execute stored Procedure (V2) action, it returns statuscode 200

{
 "statusCode": 200,
 "headers": {
 "Pragma": "no-cache",
 "Transfer-Encoding": "chunked",
 "Vary": "Accept-Encoding",
 "x-ms-request-id": "a3e1d811-390d-4c0b-b98c-ee4828a486b4",
 "Strict-Transport-Security": "max-age=31536000; includeSubDomains",
 "X-Content-Type-Options": "nosniff",
 "X-Frame-Options": "DENY",
 "x-ms-connection-gateway-object-id": "07807ecc-61c7-436a-869c-cfcf161f434f",
 "Timing-Allow-Origin": "*",
 "x-ms-apihub-cached-response": "false",
 "x-ms-apihub-obo": "true",
 "Cache-Control": "no-store, no-cache",
 "Date": "Wed, 21 Sep 2022 03:00:18 GMT",
 "Content-Type": "application/json; charset=utf-8; odata.metadata=minimal",
 "Expires": "-1",
 "Content-Length": "39"
 },
 "body": {
 "ResultSets": {},
 "OutputParameters": {}
 }
}

Can someone confirm if this is a bug from Action Execute Stored procedure (V2) by using on premise database?

Thank you in advance.

Quick Links

Leaderboard