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
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,486)