Requirement :

In Microsoft Power Apps there are 2 collections – “Customer” & “CustomerAddress”.

“Customer” collection contain records where CustAccount is unique Key

“CustomerAddress” contains records of customer addresses. “CustomerAddress” contains multiple records of one customer. It means “CustomerAddress”

 “Customer” and “CustomerAddress” collections are in 1 to Many(*) relationship.

In the end, we want our end result as mentioned below in SQL Statement;

select * from “Customer” inner join “CustomerAddress” on “Customer”.CustAccount = “CustomerAddress”.CustAccount

Power Apps Sample Code

ClearCollect(  
     CustCollection,  
     AddColumns(  
         CustomerAddress,  
         "CustName",  
         LookUp( 
             Customer,  
             CustAccount = Customer[@CustAccount], CustName
         )  
     )
 )