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.
