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...
