web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Calling Stored Procedu...
Power Apps
Unanswered

Calling Stored Procedure inside Power Apps

(0) ShareShare
ReportReport
Posted on by

Hello,

 

I am using the preview feature for calling Stored Procedures directly in Power Apps.


I am using this feature so I can view SQl data in my galleries.

I have a SQL connection to our Microsoft SQL Server and was able to call the stored procedure I needed. But once I try to pull the table in Power Apps, it gives me an error. The table (Table1) should be embedded in the ResultSets, but it shows up as a question mark (?).

 

The data shows up in my app monitor, but just can't be accessed in the app.

 

What my data stored in a collection looks like (Should be a table under ResultSets column):

 

resultsets_error.png

App monitor shows data is retrieved successfully:

app_mon_data.png

 

Daniel Christian's Youtube video explaining the new feature

 

Categories:
I have the same question (0)
  • Verified answer
    cc_robot Profile Picture
    on at

    I finally solved it. This is what my code is like for the collection:
    ClearCollect(Col_Name, Table(StoredProcedureCall.ResultSets.Table1));

    Then to pull the data into the gallery, you would need to use:
    ThisItem.Value.attribute_name

    Hope this helps.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard