Using the Common Data Service

The CDS is one possible connector for use with canvas apps. The CDS connector has a number of advantages over other connectors due to its built-in capabilities that can be leveraged by your apps; the Power Platform tools have been designed to work together, with the whole being greater than the sum of its parts.

Some advantages of using the CDS over a SharePoint list are as follows:

• Metadata: Common Data Service entities and fields have metadata that a Power App can use to set, for instance, the data type on fields, the length on string fields, or whether to automatically reuse option sets.
• Scale: The CDS can scale to large record sets, whereas you may find issues with query delegation using SharePoint.
• Logic: Business rules in the CDS can perform data validation, simplifying your apps.

Some advantages of using the CDS over an Azure SQL database are the following:

• Metadata: The range values for fields, such as min and max, are stored in...