cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AnthonyJrJr
Frequent Visitor

Filter Gallery based on SharePoint list relationship (one to many)

Hi guys,

 

I need a help, really don't understand how to achieve this.

Let's start with the data model.

I have 3 SP lists: Educations, Courses and SignUp table.

They have a one to many relationship in between themselves, one education can have many courses and each course can have many participants, as it is shown in the picture below.

 

relations.png

 

Education ID is primary key and it's used in Course table as a link between

Course ID is primary key and it's used in Sign-Up table as a link between

 

And I'm using this relationship to work with galleries in my App.

 

Gallery.png

My questions are:

1. How to exclude courses for which user have already applied ( i understand the querry: I have to filter the data WHERE active app login email = email in the "SignUp table" && course ID "SignUp table" = Course ID "Course table")

2. How to count number of courses for each education (number of children)

3. When deleting education, how to delete all corresponding courses and signups?

1 ACCEPTED SOLUTION

Accepted Solutions
AnthonyJrJr
Frequent Visitor

Solved with CountRows!

View solution in original post

1 REPLY 1
AnthonyJrJr
Frequent Visitor

Solved with CountRows!

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PWREduCon768x460.png

Join us at PWR EduCon - A Power Platform Conference

Learn from the top Power BI, Power Apps, Power Automate & Power Virtual Agents experts!

Top Solution Authors
Top Kudoed Authors
Users online (2,280)