cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LazyLazy
Frequent Visitor

Join 2 table in Power Apps

How can I join two of table with the same value, my code of each table be like
A: Filter(Filter('DB2',Email=User_Email,Status="Waiting for Approve"),RequestNo in Search('DB1',"Pending", "Status").RequestNo)

B:  Filter('DB1',Right(Status,1) in Right(Search('DB1',"Pending", "Status").Status,1),Status)

LazyLazy_1-1613544358725.png

 

I try to use Filter(Filter('DB2',Email=User_Email,Status="Waiting for Approve"),RequestNo in Search('DB1',"Pending", "Status").RequestNo, Seq = (RequestNo.status of B)) but it does't work and I don't know how to define RequestNo.status of B.

 

Thanks.

Best Regards.

1 ACCEPTED SOLUTION

Accepted Solutions
VijayTailor
Resident Rockstar
Resident Rockstar

Hi @LazyLazy ,

Below is the Way to Join 2 table.

ClearCollect(  
    TestColl,  
    AddColumns(  
        ChildDataColl,  
        "Status",  
        LookUp(  
            MasterDataColl,  
            ID = ChildDataColl[@MasterID]  
        )  
    )  
) ;

 

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up." - Vijay



View solution in original post

1 REPLY 1
VijayTailor
Resident Rockstar
Resident Rockstar

Hi @LazyLazy ,

Below is the Way to Join 2 table.

ClearCollect(  
    TestColl,  
    AddColumns(  
        ChildDataColl,  
        "Status",  
        LookUp(  
            MasterDataColl,  
            ID = ChildDataColl[@MasterID]  
        )  
    )  
) ;

 

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up." - Vijay



Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (3,041)