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
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,248)