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

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
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

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

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,233)