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

Notifications

Announcements

No record found.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 137 Super User 2025 Season 2

#2
#ManoVerse Profile Picture

#ManoVerse 57

#3
Jimmy Passeti Profile Picture

Jimmy Passeti 50 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans