News and Announcements icon

Power Platform CommunityForums Power Pages - General Discussions Filterting EntityLists...

Power Pages - General Discussions

Answered

Filterting EntityLists by 2 contact fields

(0) Share

Report

Report

Posted on by Verceti87

44

Hi Experts I am trying to filter an entity list by 2 different fields on a case. Here is my setup:

How can i filter based on both primarycontactid and authorized agent so that when both of these users log in, they will see the same case record?

Thanks

Categories:

All responses Img

All responses (2)

Answers Img

Answers (1)

Verceti87 44 on at

Like (0)

Report

Re: Filterting EntityLists by 2 contact fields

Wow thank you so much. Your first method worked like a charm!
Verified answer

Fubar 7,962 Super User 2025 Season 1 on at

Like (1)

Report
Re: Filterting EntityLists by 2 contact fields

Several ways you could do it
Have the List without any filtering of the Contact records, and control it via Table Permissions i.e. (Table Permission to the Primary Contact lookup and a Table Permission to the Agent Lookup, assign both to one or more Web Roles that you assign to your Contact.
On the Views that you are going to use for that List, add both fields to the condition as an OR and select any Contact record for each Lookup so you can save the view definition (this is a now undocumented feature from back in the Adx days, Contact lookup in a View will resolve to the currently logged in Portal User's contact record irrespective of what record is populated in the query in Dataverse).
Create 2 Lists and use different Filter Conditions (as per your screen shot). For this to work well you need some other way of telling a Contact would be the Agent etc so you can put an IF statement in a Web Template and switch to the respective List (or have 2 menu options one for Agent List and the other for Contact List)
Custom Web Template with FetchXML and build your own list from the results.
(and of course will need relevant Table Permissions to each of the Lookup fields)

Helpful resources

News and Announcements

Upwork and Microsoft Power Platform Partnership

Welcome to the Power Platform Communities

Check out the New Agent Creator Community

Quick Links

Leaderboard > Power Pages

#1

Fubar 69 Super User 2025 Season 1

#2

oliver.rodrigues 49 Most Valuable Professional

#3

Jon Unzueta 43

Last month Overall leaderboard

Featured topics

Solution to LinkedIn Authentication in Power Apps Portals

Product updates

Microsoft Power Platform Community release plans