Unanswered

Canvas App List All Dataverse Tables

(0) Share

Report

Posted on by SteveKnowles

Hi All

I'm looking to create an app that will display me a list of all the dataverse tables in my environment, the number of rows and the most recent date it was created. I can connect to data using a Gallery but it then asks if i can select a table.

ideally, i want to display all the tables with the information i need. Is this possible?

Thanks

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

cchannon 4,702 Moderator on at

Like (0)

Report

Yes, but...

The Dataverse WebAPI does provide an endpoint that elaborates the metadata of all tables ({rooturl}/api/data/v9.0/EntityDefinitions), but it will give you a HUGE volume of data, of which you're only interested in the logicalnames / displaynames AND it will not give you counts in that call, you will need to make subsequent calls for each table to get those counts and there are a lot of OOB tables in Dataverse. Offhand I would guess that depending on volume and extent of your customizations you could be looking at 1k-2k service calls to be able to display this.

So, possible, but it won't be fun.

Was this reply helpful? Yes No
SteveKnowles 20 on at

Like (0)

Report

No worries

Had a feeling this might be the case, thanks for letting me know

Was this reply helpful? Yes No
Verified answer

cchannon 4,702 Moderator on at

Like (0)

Report

Happy to help. Please mark the answer if this answers it for you so others can find this post as Solved.

Was this reply helpful? Yes No