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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / N:N relationship for f...
Power Pages
Unanswered

N:N relationship for filtering list items based on contact access

(0) ShareShare
ReportReport
Posted on by

i have three tables: Trips (custom), Participants (custom) and Contacts (out of the box). Each Trip can have multiple associated contacts, and each contact can have multiple associated trips. There is an N:N relationship between the two tables. 

Participants are assigned a trip and a contact. Each participant appears only once. There is an N:1 relationship between participants and trip and contact respectively.

 

On a power page I have two lists. One shows the trips and the other shows the participants. Table permissions are set as 'contact access', with the relationship between contacts and participants being used and the N:N relationship between contacts and trips, only for authenticated users.

 

When I log in as a contact that has been associated with several trips and also been added as a contact for several participants, I expect to see only 'my' participants in the participant list and 'my' trips in the trip list. For the participant list this works as expected.

For the trip list, I get the general error "We're sorry, but something went wrong. Please try again, and if this persists, contact the website administrator."

 

I figure this must be because of the N:N relationship, but can't figure out how to configure it to make it work.

 

Any ideas? 

Categories:
I have the same question (0)

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

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Pages

#1
Suriyanarayanan V Profile Picture

Suriyanarayanan V 37

#2
Fubar Profile Picture

Fubar 32 Super User 2025 Season 2

#3
oliver.rodrigues Profile Picture

oliver.rodrigues 26 Most Valuable Professional

Last 30 days Overall leaderboard