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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / How to access a record...
Power Pages
Answered

How to access a records that are indirectly related?

(0) ShareShare
ReportReport
Posted on by 7

I have two entities A: Client Group & B: Contact

Every Client Group must have 1 client which directly points to 1 Contact (A -> B) & 
Every Client Group can have n clients which indirectly points to n Contacts (A -> C -> B - by using Connections)

By default I can access the 1 Contact that is directly linked through the lookup relationship but

How do I access the n Contacts that are indirectly linked using the Connections entity?

 

Example Below:

Client Group has N:1 relationship with contact

Client Group 1 consists of (Adam, John, Jane)

Adam is the contact record set for Client Group 1

John & Jane are set as related contacts through connections for Client Group 1 

 

If I were to update information using the Client Group form it'll only work for Adam as he's directly related and has that "relationship" reference, however John & Jane do not as they're indirectly related and can't be "looked-up" because the lookup is 1-1

Categories:
I have the same question (0)
  • Verified answer
    Fubar Profile Picture
    8,487 Super User 2026 Season 1 on at

    Basically you create Table Permissions with a Scope = Parent for each of the Relationships from your Contact table.  In the new interface this is done via Child permissions. (Using Connections will probably make this more difficult, as you cannot specify for specific Connection Roles).

    e.g. to give permissions to an Accounts invoice line items, where the line item does not have a lookup to either Account or Contact you would have permissions something like:

    • Contact ->Account (Account scope)
    • Account -< Invoice (Account or Parent Scope)
    • Invoice  -< Invoice Line Item (Parent Scope)

    In your case you would go Contact through the Connections table relationships to your Client Group

  • Kevin Ngoh Profile Picture
    7 on at

    I tried this and it's giving me the results I want! Thanks legend

  • Kevin Ngoh Profile Picture
    7 on at

    I'm now getting this error however @Fubar 

    kevinngoh_0-1700641182704.png

     

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
rezarizvii Profile Picture

rezarizvii 53

#2
DP_Prabh Profile Picture

DP_Prabh 40

#3
oliver.rodrigues Profile Picture

oliver.rodrigues 28 Most Valuable Professional

Last 30 days Overall leaderboard