web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Data Table with Column...

Power Apps

Unanswered

Data Table with Column value from another table

(0) Share

Report

Report

Posted on by 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.

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (0)

Florian_Kleinz 227 on at

Like
a
(0)

Report
Copy link

Link copied!
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

Join the conversation