Return Stored Procedure (SQL On Prem) Result (Single Row) from Flow to Power App

(0) Share

Report

Posted on by AMJEE

Hi There,

I have a Power App button which executes a simple Flow that calls SQL (On Prem) stored procedure and the output generated in Execute Stored procedure (V2) is as below... i.e. Stored Proc just returning 1 row with 4 columns. I am having hard time to parse it and get this columns back to my APP. Please can someone advise? I was trying to play with 'Parse JSON' and 'Select' after my Execute SP in flow but may be I'm doing something wrong to generate schema etc.. somehow not getting these columns (ErrorCode (Int), ErrorMessage (Varchar200), ReturnData (int), ReturnMessage(varchar(200))

{

"Table1": [

{

"ErrorMessage": "Successfully Synched Data",

"ErrorCode": "0",

"ReturnData": "",

"ReturnMessage": "Successfully Synched Data"

}

]

}

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @AMJEE ,

You could use response action in flow.

variables('Thevar').Table1

[ { "ErrorMessage": "Successfully Synched Data", "ErrorCode": "0", "ReturnData": "", "ReturnMessage": "Successfully Synched Data" } ]

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No