Notifications
Announcements
Hi,
I possess a recordset containing Header data and another recordset containing detail data. How can I efficiently send both back to Power Apps?
Thanks!
@usaman45 What is your database? You can create multiple data sources in PowerApps one for Header and another for details.
Alternately, you can return one JSON object combining the two datasets and use ParseJSON function in Power Apps to deserialize the input.
I can only use Store Procedure in Power Automate. Do you have an example show how to combine the two Record Sets in one Json string?
@usaman45 You can connect to the SQL tables or stored procedures directly from within PowerApps.
Connect to SQL Server from Power Apps - Power Apps | Microsoft Learn
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
trice602 398 Super User 2025 Season 2
David_MA 331 Super User 2025 Season 2
Expiscornovus 203 Most Valuable Professional
