SQL views for canvas apps

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Note

These release notes describe functionality that may not have been released yet. To see when this functionality is planned to release, please review Summary of what’s new. Delivery timelines and projected functionality may change or may not ship (see Microsoft policy).

Use SQL views to combine data in SQL Server before bringing it into PowerApps.

A common scenario is to have a single table (Product Category) with lookups to another table (Products) that contains data points such as the product number, name, and price.

Previously, you had to bring both tables into PowerApps, create a gallery of categories, and then look up the detail information for the product information. If this was done incorrectly, it could cause performance issues due to the number of data calls to SQL Server.

Another possible scenario is to aggregate (group and sum) data before bringing it into PowerApps. Rather than bringing all the records into PowerApps and using the Sum feature, you can do all of the advanced processing in SQL Server first.