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
mr-dang
Level 10

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
mr-dang
Level 10

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

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,952)