I have a Data Table that is based on a filter:
Filter('[dbo].[tblBankAccountBalance]',BankAccountID in variable1.BankAccountID)
It has the following columns:
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
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.
you could use Addcolums and lookup.
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.
Join us for the next call on August 17, 2022 at 8am PDT.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.