Flow with result from MSSQL-Stored procedure - SORRY wrong forum

(0) Share

Report

Posted on by torsten156

Hi,

I use a stored procedure in MSSQL with an Output-Parameter. When I start this SP in SQL-Management Studio I receive an integer value as output. Ok, it works fine.

When I use this SP in Power Apps Flows, the result what i get is NULL. Here is the Outputs:

{
 "statusCode": 200,
 "headers": {
 "Pragma": "no-cache",
 "Transfer-Encoding": "chunked",
 "Vary": "Accept-Encoding",
 "x-ms-request-id": "035bc1ef-23d3-487c-bb58-61ee00130807",
 "Strict-Transport-Security": "max-age=31536000; includeSubDomains",
 "X-Content-Type-Options": "nosniff",
 "X-Frame-Options": "DENY",
 "Timing-Allow-Origin": "*",
 "x-ms-apihub-cached-response": "true",
 "Cache-Control": "no-store, no-cache",
 "Date": "Mon, 01 Mar 2021 08:47:42 GMT",
 "Content-Type": "application/json; charset=utf-8; odata.metadata=minimal",
 "Expires": "-1",
 "Content-Length": "39"
 },
 "body": {
 "ResultSets": {},
 "OutputParameters": {}
 }
}

What can I do here? I need the int-value from the Sp.

Thanks

Torsten

Categories:

Building Power Apps

I have the same question (0)