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.
Thats Exactly what i was looking for!!! thank you!
@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:
Record in CRM:
Portal: