My second attempt to post here as my first seems to have disappeared into the ether.
Despite never having used Powerapps or Azure previously I've been tasked by work to evaluate if the combination could be used on a project we have. So as a total newbie I apologise now if my query is inane 🙂
I have an Azure Cosmos DB called CasualWorkerPayments which has a collection called CasualWorkers. There are 2 documents in the collection.
I've created a connection using the Azure Cosmos DB connector.
I have then created a canvas app in Powerapps which contains a datatable. Set the data source as the Azure DB connector.
I thought as an initial test I'd return the document ids to the table. So under the 'items' property I've got 'Table(AzureCosmosDB.GetDocuments("CasualWorkerPayments","CasualWorkers"))'. But nothing is returned to the 'Documents' field.
I've also tried using 'AzureCosmosDB.GetDocuments("CasualWorkerPayments","CasualWorkers")' in the OnSelect property of the 'Documents' field but again no data is returned.
I'm sure I'm missing something quite basic but for the life of me I can't figure it out.
Ultimately, I'd not only return the document ids or names but also query the data in the documents and bring those values into a table as well.
Can anyone please point me in the right direction?
Thanks in advance,
I have the exact same issue.
If I try to go for a specific document with something like:
I just get nothing, eventhough the document contains fields.
I've tried that as well and, like you, nothing gets returned.
I'm hoping that it's something that I'm missing as opposed to an issue between powerapps and a cosmos db.
This is completely new territory for me. The last few years I've been working with Oracle pl/sql, writing queries, functions and procedures.
The closest I've come to developing in this way is working with Oracle forms which uses event driven triggers. But that was a few years ago.
Hopefully, someone will come along and point out where we're going wrong 🙂
Thanks for that link. I think you're right that the connector is obsolete.
Ah well more things to learn. Not sure my 56 year old brain has enough capacity 🙂
If the information provided doesn't help please reply in this thread and I will find a more applicable solution.
In reviewing other posts pertaining to Azure Cosmos DB in the Community I came across this thread. @Axel666 I know you're already aware of this as your replied in that thread as well. I will include the link to the thread below.
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
We are excited for the next Super User season.
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021