You’re offline. This is a read only version of the page.
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):
App monitor shows data is retrieved successfully:
Daniel Christian's Youtube video explaining the new feature
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.
Share
Report
All responses (
Answers (
834
