Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Filter entity list based on a field of a custom entity in power apps portals

I have 3 entities:

1. Products(Custom Entity)

2. Contacts (oob Entity)

3 Locations(Custom entity)


They are linked in the following way:

Each product has a contact(lookup to contact entity).

Each Contact is associated to Location(Lookup to location entity).


Issue: I want to show a logged in portal user, the list of products that are linked to contacts who are based in the same location as the logged in user.


For example:

product 'A' is create by contact 'X' who is based in 'Canada'

Product A--> Contact X--> Location Canada

Product B --> Contact Y--> Location Canada

Product C--> Contact Z--> Location Canada

Product D --> Contact F--> Location USA


So, when Contact X navigates to a particular view/entity List on portal.. They see Products A,B,C as they are created by contacts based in location 'Canada'


Can someone please suggest how can I do that? I am not able to find good resources/Answers in other Forums



Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.


New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (2,201)