Unanswered

Use Data from DocumentDB

(0) Share

Report

Posted on by benninyze

Hey Community,

I'm really struggeling using DocumentDB and PowerApps. I connected my database to PowerApps and now just want to show the documents within a collection. Is there somekind of a instruction? I saw this, but this doesn't help me. Any suggestion :)?

- I'm using the vertical gallery

- Tried several things, like

- AzureDocumentDB.GetCollection...

- AzureDocumentDB.GetDocuments ...

- Here PowerApps wants several attributes.

Would appreciate it if someone could help me.

Cheers

Ben

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (0)

Meneghino 6,949 on at

Like (0)

Report

Hi @benninyze
Frankly I have never used DocumentDB but maybe we can solve this with some common sense.
Since you have managed to connect the database and you have managed to create a vertical custom gallery, then the next logical step would be to set the Items property of the gallery simply to the name of the database as shown in the PowerApps connections.
What does that give you?
Then you place controls in the gallery template to show the database fields.
I hope I can be of more help this time.

Was this reply helpful? Yes No
benninyze 11 on at

Like (0)

Report

Hey,

thanks for helping. So I'm trying this right now.

After I connected to my Azure DocumentDB and inserting a gallery I change the Items function. I want to get the collection 'Contract' with several documents in it.

See, no errors.

Then in the items list itself I try to change the Text function.

For this I'm using the 'attribute' ThisItem.

I choose for example ThisItem.id.

I think it is somewhat correct, but it doesn't show me any documents. And yes, in the collection 'Contract' there are several documents.

Anyone facing similar problems?

Cheers

Ben

Was this reply helpful? Yes No
Meneghino 6,949 on at

Like (1)

Report
Hi @benninyze

I would suggest to take a step back and create a simple textbox outside the gallery and use the CountRows function to see if you are getting anything returned, something like:
CountRows(AzureDocumentDB.GetCollection(1;"Contract"))
If you get 0 or blank then we have a problem to resolve. If you get 1 or more (hopefully the number of docs you expect) then you can create a button, again outside the gallery, and set its OnSelect property to this:
ClearCollect(MyTest; AzureDocumentDB.GetCollection(1;"Contract"))
After you run the app, press the button and return to edit mode, you will be able to inspect the contents of the collection in the Content tab of Studio.

Please let me know how you get on.

Was this reply helpful? Yes No
benninyze 11 on at

Like (0)

Report

Thanks! Good point.
I did CountRows(AzureDocumentDB.GetCollection(1;"Contract")) but get a BLANK value. At least no error. When i missspell Contract I get back an error, so at least this is correct.
Is it any problem with the rights management?

Was this reply helpful? Yes No
Meneghino 6,949 on at

Like (0)

Report

As I mentioned I have no experience with DocumentDB, but at least we have identified the issue.
Maybe someone else can help further.

Was this reply helpful? Yes No
benninyze 11 on at

Like (0)

Report

Little pushing of topic 🙂

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi,

How did you connect to DocDb, I cant find anything that will work as an acount id ?

Gary

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Solved my own issue 🙂

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi,

I got a little further, if you set the Gallery date element to

AzureDocumentDB.GetDocuments("your db", "yourcollection").Documents

Then the gallery populates with the number of documents.

Now I'm stuck on accessing data elements within the doc. 😞

Was this reply helpful? Yes No