Can PowerApps application connect to Azure SQL Database Managed Instance?
I have exisiting PowerApps application that connects to SQL database hosted in Azure VM server. Planning to move Database to new Azure SQL Database Managed Instance. I am reading through this link [https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance-connect-app] for different type of connections from Client Applications. PowerApps connectivity is not mentioned. Any pointers would be helpful.
I have not tried doing it with a managed instance, but I have done a SQL Connector to a regular Azure SQL database (SAAS not IAAS). If you look at the properties of the SQL Instance you should see a server name. Use that in the regular SQL connector with the database name and it should work. Note: you will need to have setup the managed instance with a proxy to the Internet. Otherwise it won't be reachable.