Multi-Table lookup – Power Platform – PowerApps Feature – July 2021

When we are trying to create a lookup field that lets you check out media to the users.
We will have a table of Books with book publilsher details, a table of Audio offerings with audio type, and a table of Video offerings with video type.

There was no easy way to create a lookup that would pull data from all three tables at once.
We may end up with three separate lookups as shown below.

The solution is to have a single lookup, that can search data from all the media tables.

Watch this full video with a demo on this.