Join Multiple Tables in Canvas App using Lookup

 Hi all,

So, imagine that you have 2 tables

Table A: "Team Assignment" and Table B: "Player", with Player (Display Name: Player and Schema Name is new_playerid) is the Foreign Key

Now, I want to have gallery in CanvasApp that showing the Information:

Team Name, Player Name, and Date of Birth

I have been trying to find the answer and could not find it because typically if you just use lookup and without match the foreign key which is Player Id in this case, you will not get the correct Date of Birth, instead will just get the "first record" which is in the case is 1-Jul-95 (Donny's)

So, here is the answer:

Put the code in the Items property of the Gallery

AddColumns('Team Assignments', 

"PlayerObject", 

LookUp(Players, Player = 'Team Assignments'[@Player].Player))

With this, you can get all the columns from both tables, if you need just one column, you can just add it in the LookUp formula

Reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-table-shaping

Hope it helps!