Currently we are using AWS RDS Sql Server as a Data Source for PowerApps, my client is asking us to migrate these databases to some cost-effective DataSources like PostGresSQL/MySQL. We want to understand how PowerApps work best with PostGresSql in terms of delegation and till what extent these PowerApps functions support ? What is the alternative approach for non-delegable functions ? here we want to connect to Data Sources(PostGresSQL) through custom connector, and this custom connector will hit the Data API. Please provide your inputs on this.
Delegation depends on the connector being used so you should create a sample project to test your connector to ensure that it is generating the SQL statements which allow for delegation.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.