I'm wondering if there a way, within a Power App flow to query multiple tables in dataverse at once similar to a SQL statement. For example, I have:
Table 1 = Item table and contains a field indicating active/inactive
Table 2 = Inventory Table and contains on-hand quantity
I would like to, query and return values for items that are inactive and have an on-hand quantity > 0
The only way I have found to do this so far is to query one table and then loop the results to get the values in another and then do a conditional test. I would love to think that there is a more efficient way to do this that I just haven't learned yet.

Report
All responses (
Answers (