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.
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Check out the new Power Platform Community Connections gallery!