Unanswered

Unable to access response from stored procedure when assigning to a property using Power FX

(1) Share

Report

Posted on by SD-12081949-0

I am trying to execute a SQL Server stored procedure from power apps. The Power FX command I am using is DBName.Stored_Procedure().ResultSets.Table1
But I am not able to access the Table1 or the ResultSets. I tried assigning it to a collection but nothing seems to be returned.
Surprisingly when I use the monitor I see that the Response Tab does have the expected response:

"body": {
    "ResultSets": {
      "Table1": [
        {....

So the stored procedure is working and it is getting executed as well as expected. But something wrong with accessing the response.
This seems to be an issue for many people as seen in some youtube comments on tutorial videos on the same. Is there a fix to this? Or am I doing something wrong here?

Categories:

Experimental features

I have the same question (0)

All responses (2)

Answers (0)

Michael E. Gernaey 53,392 Super User 2025 Season 2 on at

Like (0)

Report

Hi

Is this a Model Driven or Canvas App

Are you trying to access via a Connector, or are you using Power Automate?

Please share the code that you are having an issue with and the error it is giving you.

Power Apps don't simply "access" JSON things, so I have no idea how you are trying because you didn't share

Was this reply helpful? Yes No
MB-23070938-0 48 on at

Like (0)

Report
You need to give the power FX a detailed list of what results you're expecting. As per documentation https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/connections/connection-azure-sqldatabase

Set( <MyUntypedObject>, <datasourceName>.<StoredprocedureName>( { <paramName1>: "someString" } ).ResultSets ); Set( table1, <MyUntypedObject>.Table1 ); Set( TypedTable, ForAll( table1, { BookID: Value(ThisRecord.BookID), BookName: Text(ThisRecord.BookName) } ) );

Was this reply helpful? Yes No