Unanswered

Filter data by listbox inside nested gallery

(0) Share

Report

Posted on by AR-23070514-0

Hi All,

I have 2 galleries (outer gallery and inner gallery) inside the inner gallery have the container and inside the container we have list box.

suppose, the outer gallery contains the project name and inner gallery have the team name, list box contain team members name......since the inner gallery doesnt contain any column so how can we filter the inner gallery based on listbox.

Outer Gallery	for project
Project	Cost	Hour
Project 1	12	2

Inner Gallery	for team
Project	Team	Cost	Hour
Project 1	A	4	1
Project 1	B	8	1

And then we have the list box that contains the team members column from below table:
Project	Team	Team Members	Cost	Hour
Project 1	A	Ram	4	1
Project 1	B	Shyam	8	1

in combobox when we filter the list box by team members outer and inner galleries rows are not changing.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Power Platform 1919 1,890 on at

Like (0)

Report

Hi ,
can you share the items properties for outer gallery and inner gallery .
can i know, why are you using list box control for filter. (generally it is better to use dropdown or combobox)

Was this reply helpful? Yes No
MS.Ragavendar 4,979 Super User 2025 Season 2 on at

Like (0)

Report

@AR-23070514-0,

Please provide the visualization of gallery as well as the Items Property of the gallery (both) so that we can able to adjust the formula according to your business case.

Was this reply helpful? Yes No
AR-23070514-0 24 on at

Like (0)

Report

@Power Platform 1919 I have not used list box to filter, I want to use 3 nested gallery but power apps allows to create nested gallery for only 2 level so for that i have used the list box inside the inner gallery.

@MS.Ragavendar please find the below snapshot.

1-Outer gallery containing project.

2-Inner gallery containing Teams.

3-Listbox containing team members

I hope it will help you to understand my queries.

Was this reply helpful? Yes No
Power Platform 1919 1,890 on at

Like (0)

Report

Hi @AR-23070514-0,
sorry for confusion,
but Thanks for clarification,

can you share the formulas used for items properties in outer , inner galleries along with list box,
based on that we can help you better,

what i am trying to look , is the data for the 3 controls is same and is coming from same source with multiple nested levels or not.

outer - list (list+nested data for project (level1) + nested data for team members(level2))

inner - grouped data for project (level1)

listbox - grouped data for team members(level2)

Was this reply helpful? Yes No
AR-23070514-0 24 on at

Like (0)

Report

all 3 data sources are from 3 different collections. as I have already shown in tables

Was this reply helpful? Yes No
Power Platform 1919 1,890 on at

Like (0)

Report

Hi @AR-23070514-0,
Is there any common column or any relation between the three collections, from the sample data provided,
i assume project is present in all collections

and u want to filter on Team members name right? or do you want filters based on other columns?

Was this reply helpful? Yes No
AR-23070514-0 24 on at

Like (0)

Report

Yes right i want to filter based on team members

Was this reply helpful? Yes No
Power Platform 1919 1,890 on at

Like (0)

Report

Hi @AR-23070514-0,

sorry for the late reply:

here i am assuming few things

like you have a combobox with distinct team members from collection (team member collection)

This supports multi select

for outer gallery:

use this

Filter(col_project,Project in Filter(col_team_members, Team_Members in Cb_Team_Members.SelectedItems).project)

for inner gallery

use this

Filter(col_team,team in Filter(col_team_members,Team_Members in Cb_Team_Members.SelectedItems).team)

Note: This formula is not tested yet, this is written based on logic.

If you have already built any filter logic, please share it here, we can look and adjust the code as per requirement

Was this reply helpful? Yes No