Do you want to create a connection to your Azure Cosmos DB connector from your canvas app?
Yes, you are right. Currently, the data stored in Azure Cosmos DB is unstructured and semi-structured data, but PowerApps canvas app could not handle unstructured data.
If you want to use Azure Cosmos DB connector to retrieve data within your canvas app directly, I afraid that there is no way to achieve your needs currently.
If you would like this feature to be added in PowerApps, please submit an idea to PowerApps Ideas Forum:
https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas
As an alternative solution, you could consider fire a Power Automate flow from your canvas app, then use the flow to call Azure Cosmos DB actions to retrieve data, then return the retrieved data back to your canvas app.
Please check and see if the following blog would help in your scenario:
https://agazoth.github.io/blogpost/2018/12/31/Using-CosmosDB-In-PowerApps.html
In addition, you could also consider create a custom connector to achieve your needs. You could consider set up a custom connector based on Azure Function, within the Azure function, perform CRUD operations on data residing in Azure Cosmos DB. After that, you could create a connection to the custom connector from your canvas app, then you could call the Azure function to do CRUD operations on data residing in Azure Cosmos DB.
Please check the following article for more details:
https://docs.microsoft.com/en-us/archive/blogs/srikantan/using-azure-functions-cosmos-db-and-powerap...
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
Subscribe to my YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218
