web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps directly call SQL stor...

Power Apps

Suggested Answer

directly call SQL store procedure and return two table set

(3) Share

Report

Report

Posted on by usaman45

314

My Power Apps directly call a SQL stored procedure that return two sets of tables; however, it fails to retrieve the second set.

Any help welcome.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

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

Like (1)

Report

Hi

How in the world do you think we can help you with that statement by itself....

Come on, please respect your time and ours.

Was this reply helpful? Yes No
Jsunnb 61 on at

Like (2)

Report
I do think you are pretty vague with your question, but if I had to guess what you are trying to do is get to the second table your stored procedure returns.

This is the format I used to try and get a table to return and it seems to work:

ClearCollect( collectionName, Table( DataSourceName.StoredProcureName( { input1: SomeValue, input2: SomeValue, } ).ResultSets.Table1 ) )

You can see the .Table1, you'd replace that with .Table2 to get the second set of data. Hope that helps you.

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

Like (1)

Report
If you are using on - premises server, then you can only get 1 results set, multiple are only available on Azure.

https://learn.microsoft.com/en-us/connectors/sql/

The following limitations apply to invoking a stored procedure on an on-premises SQL server:

Output values for OUTPUT parameters aren't returned. You can still specify input values for OUTPUT parameters.

ResultSets value is Untyped.

Return value isn't available.

Only the first result set is returned.

Dynamics schemas aren't supported for result sets.

Was this reply helpful? Yes No

Join the conversation