Display Many-to-Many Relationships in a PowerApps Screen

Displaying related records in a gallery and sub-galleries

In Part 3, you learn how to recognize many-to-many relationships in a relational database. You also learn how to display the related records in the PowerApps interface. The records in one table populate a gallery. The records in the related table populate embedded sub-galleries in that main gallery. I show you how to set up the sub-galleries and return the records needed to populate them.

I also show you how to create in-memory, temporary tables, or Collections, in PowerApps to minimize the number of times your application has to ask the database for those records. This technique is especially valuable for recordsets larger than the delegation limit in PowerApps.

If you can't connect to the internet, how do you create an online, searchable database for a research library?

The LTF Searchable Catalog is a full-featured app which can be supplemented with an Access desktop interface. Because of the unique environment and restrictions in the LTF museum, the interface must run on a cellular-enabled device, i.e. a tablet or smart phone.

Other Videos on Sub-galleries and retrieving large recordsets into collections.
Retrieving 10,000 records in PowerApps: https://studio.youtube.com/video/qlJAJeo7yDM/analytics/tab-overview/period-default

Mike's Mobile Library -- One-to-Many Records Using Nested Gallaries:
https://youtu.be/0I7LllbROT0