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)

Sort by

Michael E. Gernaey 53,963 Moderator on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!
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