Hi @Vikz_19
The best thing to do here is to create a view in SQL Server that joins the 3 tables. Here's an example of how this would look.
CREATE VIEW vwPostConfiguration AS
SELECT
pc.PostConfigId,
pc.AccountType,
pc.AccountNumber,
pc.Description,
pc.Currency,
pc.BalancingAccountType,
pc.BalancingAccountNumber,
pc.Dimension1,
mip.MIPDocumentNoPrefix,
mip.ProcessorDescription,
sdc.SettleDocumentNoPrefix,
sdc.BankAccountDescription
FROM
PostConfiguration pc
JOIN
MIPDocumentConfig mip ON pc.MIPDocumentConfigId = mip.MIPDocumentConfigId
JOIN
SettlementDocumentConfig sdc ON pc.SettlementDocumentConfigId = sdc.SettlementDocumentConfigId;
Add this view to your Power App.
Let's say your combobox is called cboProcessorDescription. You would set the Items property of your combobox to MIPDocumentConfig.
To filter the data, you would set the items property of your table control to the following:
Filter(vwPostConfiguration,
MIPDocumentConfigId=cboDocumentConfig.Selected.MIPDocumentConfigId
)
