Data Table with Column value from another table

[jamesp24]

Hi

I have a Data Table that is based on a filter:

Filter('[dbo].[tblBankAccountBalance]',BankAccountID in variable1.BankAccountID)

It has the following columns:

StaffID

BankAccountID

BalanceAmount

Comment

I have another table tblBankAccounts that has fields BankAccountID and CCYName

On my Data Table I would like it to display the following fields, where it looks up CCYName based on the BankAccountID

StaffID

BankAccountID

CCYName

BalanceAmount

Comment

I am pretty new to powerapps so if any chance to explain as simply as possible that would be greats.

Thanks all for the help.

[Florian_Kleinz]

Hello,

you could use Addcolums and lookup.

AddColumns(
   Filter('[dbo].[tblBankAccountBalance]',BankAccountID in variable1.BankAccountID), 
   "CCYName",LookUp(tblBankAccounts,BankAccountID = tblBankAccountBalance.BankAccountID,CCYName)
)

Please check it out and let me know. You might need to adapt the table name since you are probably connected to SQL database.

Best regards