powerbi - What is the correct way to join two tables together from the Common Data Service for PowerApps to use?

Question

I have two tables in a PowerApp - both are > 5,000 rows and therefore are subject to the delegation limit. So all my formulas have to be delegable in order to retrieve the records I need.

One table is a Workers or Staff table, and one is a Production or "Orders" table.

What is the right way to load the records into a gallery, that retrieves all of the Workers names, and then LEFT JOIN (in SQL terms) onto the production table to lookup the results?

I have done this so far in setting the datasource as the Workers table, and then manually looking up each field, but this is highly performance heavy, and slows down the app to an unusable state.

Is there a way of perhaps caching the records I need without hitting the delegation limit?

Answer 1

等待大神答复