cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Filtered Gallery Control

I'm creating a classroom management app where I can information about my students. Essentially, students receive points for things like effort and achievement. 

What I want is a browse gallery that brings up all the students' names (already have this set up).Capture.PNG

 

 

Then, when I click on a student's name, it will take me to a new screen with another browse gallery that will have all the records for that particular student.

Being that I teach about 100 students, I don't want to have to manually filter by writing their student names into the function.

 

Any ideas???

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Champion
Community Champion

Re: Filtered Gallery Control

Hi,

It's good that you're making classroom apps for yourself--I have made a similar app.

 

Here's what to do:

  • Gallery1--this is the gallery with all the students' names
  • Gallery2--this is the second browse gallery that shows all their points

In the Items property of Gallery2, set it to reference whomever is selected in Gallery1:

Filter(datasource,Student=Gallery1.Selected.Student)

This means, "Filter the datasource where all points are contained to show all records that belong to the student selected in Gallery1." Student is the name of the column that identifies the student.

 

You can get fancy by specifying more conditions.

 

Let me know how that goes.

Microsoft Employee
@8bitclassroom

View solution in original post

2 REPLIES 2
Highlighted
Community Champion
Community Champion

Re: Filtered Gallery Control

Hi,

It's good that you're making classroom apps for yourself--I have made a similar app.

 

Here's what to do:

  • Gallery1--this is the gallery with all the students' names
  • Gallery2--this is the second browse gallery that shows all their points

In the Items property of Gallery2, set it to reference whomever is selected in Gallery1:

Filter(datasource,Student=Gallery1.Selected.Student)

This means, "Filter the datasource where all points are contained to show all records that belong to the student selected in Gallery1." Student is the name of the column that identifies the student.

 

You can get fancy by specifying more conditions.

 

Let me know how that goes.

Microsoft Employee
@8bitclassroom

View solution in original post

Highlighted
Anonymous
Not applicable

Re: Filtered Gallery Control

I got it working!

I needed to slightly change it to:

filter(tablepoints,student=gallery3.selected.student.text)

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (6,861)