Power Apps

General availability of “Improve data source experience and Common Data Service views”

Lance Delano, Principal Program Manager, Monday, 11 November 2019

This week we are happy to announce the general availability of the “Improve data source experience and Common Data Service views” feature. At the same time we are also retiring the “Relational data, option sets and other new features for CDS” preview feature as that functionality is now superseded with this release. This feature is available now in the preview regions and will be in all regions next week.

With this feature, applications have the benefit of the improved user experience with access to Common Data Service views. See the Experience details section below. Additionally, customers will see a 2x+ speed improvement and greater reliability as well.

We recommend that customers migrate their applications with existing connections to the Common Data Service. This includes applications that use the Dynamics 365 connector. Expect us to continue to add new features and improve speed and reliability based on this feature.

As part of this general availability release we are also defaulting the preview Explicit Column Selection (ECS) feature to be “On” as well. This will provide additional speed benefits. Finally, this feature is not supported on the Windows Player. For more details on upgrading your application, see the Upgrade your app section below.

Experience details

New data sources pane

The sidebar now includes a Data sources panel icon and pane which replaces many of the data panels that open over the right edge of the canvas area. This panel allows adding data sources into the app or creating new connections without inserting a control. It provides an easy way to see the data source in your app and perform actions like refresh or delete.

Entity view selection

When a Common Data Service entity is used as a data source, a view can be selected in the property pane and the Items property is updated. The property pane will update the Items property to add the Filter function taking the the view name as the filter.

A big benefit of working with Common Data Service views is that the query for the view is run on the server – not locally on your device. This means you avoid delegation issues with the core query. In addition you have the flexibility to append other filter conditions that are delegated if supported. For more advanced queries just nest the Filter function within other functions using the formula bar.

Combo box data source selection

The combo box control also supports the data source selection call out and view selection. This is the same as the Gallery and Data Table controls.

Change Common Data Service environment

Data source selection call out can change the environment to get a Common Data Service entity from another environment. This works within the same tenant. The Current environment is app’s environment and changes when the app moves to a new environment. Other environment selections stay the same when the app moves to a new environment.

Improved data field defaulting

When a Gallery or Data Table control is bound to an entity, the fields are defaulted using the Default Public View. This improves the initial fields used and can be controlled by editing that view. Field defaulting only happens when the entity is set as the data source and after that fields are managed with the data panel.

Other improvements

In addition to the general experience improvements, this feature provides significant performance and stability improvements for working with the Common Data Service. Customers will find that all of the functionality enabled with the “Relational data, option sets, and other new features for Common Data Service” preview switch is also enabled with this new feature along with additional bug fixes and improvements.