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

Data Table with Column value from another table

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.

 

1 REPLY 1
Florian_Kleinz
Resolver II
Resolver II

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 

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (4,827)