web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / Filter Display Lists B...
Power Pages
Suggested Answer

Filter Display Lists Based on Many-to-Many Relationships (Low-Code/No-Code)

(0) ShareShare
ReportReport
Posted on by karthikt29 18
Hello Community,

I have two tables, Contacts and Courses, in Power Apps with a many-to-many relationship between them.

I am displaying a list of Courses in Power Apps portals/power pages, and my requirement is to sort/filter courses assigned based on the logged-in or current portal user.
 
Preferably using low-code/no-code solutions, but using code is also acceptable.
 
The solution is needed as soon as possible.
Thank you in advance.
Categories:
Power Apps portals
I have the same question (0)
  • Suggested answer
    sannavajjala87 Profile Picture
    sannavajjala87 931 Super User 2026 Season 2 on at
    Hi,
     
    For a low-code approach, the recommended solution is to use Table Permissions in Power Pages.
    Since you have a many-to-many relationship between Contacts and Courses, you can configure a Table Permission on the Courses table that is scoped through the relationship to the logged-in Contact. This ensures users only see courses assigned to them, and the List component will automatically respect those permissions.
    Benefits:
    • No custom code required.
    • Secure, server-side filtering.
    • Works with Lists, Forms, and other Power Pages components.
    If Table Permissions don't fully meet your scenario, you could also use FetchXML with a link-entity to the intersect table and filter by the current contact, but I'd recommend trying Table Permissions first as it's the standard Power Pages approach for user-specific data access.
     
    Thanks & Regards,
    Manoj Annavajjala

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
Fubar Profile Picture

Fubar 33 Super User 2026 Season 1

#2
Mohsin Ali Profile Picture

Mohsin Ali 25

#3
SP2019admin Profile Picture

SP2019admin 20

Last 30 days Overall leaderboard

Featured topics

Solution to LinkedIn Authentication in Power Apps Portals
Welcome to the Power Pages forum!

Product updates

Microsoft Power Platform Community release plans