web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Unanswered

Filtering Entity list with Related entity records in PowerApps Portals

(0) ShareShare
ReportReport
Posted on by 5

I have a list of projects that represent an Entity list, the Project Entity has many to many RelationShip with the Contact entity that represents Contributors. I want to filter this Entity list based on two conditions :
1) Created by the Portal User which is a column inside the Project Entity.
2) be one of the Contributors to that Project.
I want to return all records that satisfy at least one of the two conditions.

I have the same question (0)
  • Abdul Wahab Profile Picture
    12,119 Moderator on at

    For the first condition, you can use as demonstrated in the attached image

    19032021.png

  • amer.riyal Profile Picture
    5 on at

    i already add the second condition using filter inside the view and it's working fine but if i add the first condition like this it's filtering the entity list with the record that satisfy the both conditions but i want to return the record that satisfy at least one of them.

  • amer.riyal Profile Picture
    5 on at

    “I'm are trying to filter on 2 different conditions, one of them is a field in the same table and the other is a relationship to another table. For example, I need to get the records of the logged in user as well as the records where the user is a contributor on

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Manoj - ManoVerse Profile Picture

Manoj - ManoVerse 77 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 45

#3
Chris1968 Profile Picture

Chris1968 20

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans