How to show different datasource columns in a gallery?

[User237]

Hi Experts,

I have added SQL Server as a connection to my powerApp and added two tables as data sources to my app.

In that two tables one is header table and another is line table.

I created a gallery to my powerApp. For each record 5 columns need to show. In that,

1. The journal number in header table.

2. Journal name in header table.

3.Currency code and sum of amount these two columns are from line table.

4. Account number in the line table.

Journal number is the unique id in the header table and for one journal id multiple lines in the line table.

I need help for 3 & 4 columns and need to filter the gallery based on journal number and column 4.

whether i need to use filter inside another filter or any other?

Please can anyone help me to solve this by suggest formulas.

Thanks,

with regards,

User237.

[VijayTailor]

Hi @User237 

as per my understanding, you need to use Join functionality.

for that, you can check the below URL , Hope this solution help you to resolve your issue.
https://powerusers.microsoft.com/t5/Building-Power-Apps/join-two-sql-tables/m-p/348783#M100124

Thanks,
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[v-yutliu-msft]

Hi @User237 ,

Could you show me the structure of the two tables?

From your description, do you have these fields in your two tables?
1)you have fields named  journal number, Journal name in header table;

2)you have fields named Currency code, sum of amount, Account number in the line table.

Do you want to filter the gallery based on  journal number and Account number?

Could you tell me:

1)the relationship between the two tables?

2)formula in the gallery's Items?
3)the filter rule?

Based on your description, I do not quite understand your filter rule.

Best regards,