Is displaying a list of tables from DB possible in Power Apps then double-click and open a table?

[kkpasi]

Good morning everyone,

I am currently working on an app that will have to display a list of tables coming from a Database.

Based on the search criteria, the user will need to be able to filter the list as per his/her needs and receive an updated list of table(s).

Then by clicking on the desired table it should open in a full format for the user to use the data it contains.

My questions are:

1. Can an app created in Power Apps be connected to a Database and display a list of ALL tables (probably hundreds) dynamically listed there?
2. Then to double-click the desired table and without having to manually connect each table to let's say a "Data Table" or a "Gallery" to display it fully?

Up until now I haven't been able to find documentation or examples of this being done dynamically in the way described above, so I would appreciate any help!

I welcome any other solutions/ideas!

Please let me know if more information is needed on my part.

Thanks

[RandyHayes · Accepted solution]

@kkpasi 

No, you cannot do this in PowerApps.  In PowerApps you must declare all the tables you are going to work with and connect to them in the app.

You cannot then reference a table by textual name - for example:  Filter("myTableName", ...)  is not allowed.  You would first need to connect myTableName into the app and then it is an accessible source and would then be referenced like with Filter(myTableName, ...)

So, dynamically listing tables and then selecting them to open is not available in PowerApps.

There are some potential options, but you need to decide (since you mention you have hundreds of tables) if you are going to take the effort to include them all in your app (which could be fairly bad on performance).

It seems that you are looking for more of a generic database tool...that would not be an App!

I hope this is helpful for you.

[kkpasi]

@RandyHayes 

This is what I suspected.

Thanks so much for taking the time to answer my questions, I appreciate it!

Have a good one!

[RandyHayes]

@kkpasi 

No problem!