web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Pages Filterting EntityLists...

Power Pages

Unanswered

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:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Fubar 8,338 Super User 2025 Season 2 on at

Like (1)

Report
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)

Was this reply helpful? Yes No
Verceti87 44 on at

Like (0)

Report

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

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Season of Giving Solutions is Here!

Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Power Pages

#1

#2

Fubar 62 Super User 2025 Season 2

#3

sannavajjala87 31

Last 30 days Overall leaderboard

Featured topics

Solution to LinkedIn Authentication in Power Apps Portals

Welcome to the Power Pages forum!

Product updates

Microsoft Power Platform Community release plans