cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
User237
Helper III
Helper III

How to show different datasource columns in a gallery?

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.

2 REPLIES 2
VijayTailor
Resident Rockstar
Resident Rockstar

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
Community Support
Community Support

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,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

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