When building enterprise-grade applications in Power Apps, it’s common to work with complex datasets that are interrelated—for example, customer information, orders, payments, and addresses. Instead of making multiple requests, you can retrieve all related data in a single SQL stored procedure call that returns multiple tables, and then organize them within your app efficiently and reliably.
✅ The Scenario
You want to fetch customer-related data in one go, including:
- ✅ Customer Profile – Personal details like name and email
- ✅ Orders – List of customer’s past orders
- ✅ Payments – Payment history
- ✅ Addresses – Shipping or billing addresses
Your stored procedure, sp_GetCustomerData, is already set up to return these tables in sequence using multiple SELECT statements.
Please refer to the full article using the 🗄️Handling Multiple Tables from SQL in Power Apps | LinkedIn
