web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Gallery with sub galle...

Power Apps

Unanswered

Gallery with sub gallery filter

(0) Share

Report

Report

Posted on by danieller365

Hi All,

I have a business requirement where I need to filter distinct items in gallery and its sub-gallery.

For illustration, this should be the result.

However, in my gallery this is the one that currently appears:

Main gallery - Items property:

SortByColumns(Filter(M3L1,Col1=m3l1id),"OData__x0043_ol2")

Sub gallery - Items property:

SortByColumns(Filter(M3L1,Col1 = m3l1id,Col2 = ThisItem.Col2), "OData__x0043_ol2")

Every time I add a sub-item, it also appears in the main gallery. I tried the Distinct function but it returns a blank gallery.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

BCBuizer 22,638 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @danieller365 ,

There is nothing in the formula of the main gallery to filter out the distinct value, so that is creating the issue. Try the below to group the items by 'Col2' whilst still having 'Col1' and 'OData__x0043_ol2' in there:

SortByColumns( AddColumns( GroupBy( M3L1, "Col2", "GroupedByItem" ), "Col1", First(GroupedByItem).Col1, "OData__x0043_ol2", First(GroupedByItem).OData__x0043_ol2 ), "OData__x0043_ol2" )

Was this reply helpful? Yes No

Join the conversation