Need some help on Filtering item by using Gallery

[Kentgladwin99]

I created a "List" in my SharePoint called "Contracts". There are different suppliers that belong to the same "Title". 

However, when comes to PowerApps, how can I use a "Gallery" to filter another Gallery by the "Title". But these Galleries are belong to the same "List". I would like to have a left Gallery as a "Filter" for the right Gallery to display the "Suppliers" that categories by the Title. 

Regards,

Kentgladwin

[eka24]

This post would address your issue:
https://powerusers.microsoft.com/t5/Building-Power-Apps/IS-IT-POSSIBLE-TO-SHOW-AN-ITEM-FROM-A-SAME-D...

If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution

[v-siky-msft]

Hi @Kentgladwin99 ,

Could you please share more information about your list construct? what is the type of Suppliers column?

You want the left gallery to show Title column, right?

If there are a lot of repeating values in Title column, please try this to LeftGallery Items property:

Distinct(Contracts, Title)

and set RightGallery Items property: 

Filter(Contracts,Title=LeftGallery.Selected.Result)

Test Result:

Hope this helps,

Sik

[Kentgladwin99]

Hi @v-siky-msft 

Thank you for the message. The structure you demonstrated is exactly what I am looking for. 

These are the columns in my "List - Contracts": 

.Title (Text)

.Suppliers (Text)

.Services(Text)

.StartDate (Date)

.EndDate (Date)

For the left Gallery, Title will be the main item to filter the Gallery on the right. 

For the right Gallery, .Suppliers & .Services are displaying as the Title and Subtitle on the Gallery. 

However, the code you are using to displaying the result, how would I relate them to my scenario?

Thank you @v-siky-msft 

Regards,

Kentgladwin

[v-siky-msft · Accepted solution]

Hi @Kentgladwin99 ,

OK, let's  simplify the issue.

1. set the LeftGallery Items property: Contracts

2. set the RightGallery Items property:  Filter(Contracts,Title=LeftGallery.Selected.Title)

Then it should work as your expectation.

Sik