Skip to main content

Notifications

Power Pages - General Discussions
Answered

Filter List records baed on related contact

(0) ShareShare
ReportReport
Posted on by 504

Hi All,


I'm struggling with a filter on Power Pages. I have a list connected to a Dataverse table, and I want to filter that list based on my current contact. The problem is that each item in the list can be related to multiple contacts, so I created a many-to-many relationship, which means there is no lookup field to use as a filter.


I can't find a way to filter the records related to the current user. I have created a text column where I store the full name of the contact related to that record, just in case that makes filtering easier. However, I still don't understand how to write the JS or FetchXML filter.


Any help would be greatly appreciated.

 

Categories:
  • Giraldoj Profile Picture
    Giraldoj 504 on at
    Re: Filter List records baed on related contact

    Thats Exactly what i was looking for!!! thank you!

  • Verified answer
    Ajlan Profile Picture
    Ajlan 90 on at
    Re: Filter List records baed on related contact

    @Giraldoj Hey Mate,
    You need to configure your Dataverse table permission, set the access type as "Contact access" and in relationship select the appropriate many-to-many relationship.


    Custom Table Permission:

    Custom Table Permission.png

    Record in CRM:
    CRM Record.png

    Portal:

     

    Portal Record.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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,526

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard