Power Platform Community Forum Thread Details

Capture result from SQL Stored procedure and return to canvas app

I am totally new to this environment, the task to put together an canvas app fell on my laps and, thus far, I have been able to make significant progress and then, the need to use SQL Stored Procedure came in and I just have not been able to resolve my issue.

Scenario:

PowerApp runs a flow which executes a SQL Store procedure. The procedure renders the results from an SQL Query. The expected output is very simple (for now), just one column: rowID

Sample output from procedure:

ISSUE:

Using

[

{

"ResultSets": {

"Table1": [

{

"rowID": 1083

}

]

"OutputParameters": {}

}

]

as input within a SELECT, I am not able to extract rowID and return it to PowerApp

I am using an expression: if(isblank(item()?['rowID'],0,item()?['rowID']) as value when mapping the field:value pair in the SELECT definition.

Even if rowID has a value, I am always getting 0 as if isblank() is true thus possibly because bad referencing - For the life of me, I have changed this in so many ways and they all yield the same result.

Thank you all in advance for your assistance!

Quick Links