Filtering Entity list with Related entity records in PowerApps Portals

(0) Share

Report

Posted on by amer.riyal

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.

All responses (3)

Answers (0)

amer.riyal 5 on at

Like (0)

Report

RE: Filtering Entity list with Related entity records in PowerApps Portals

“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
amer.riyal 5 on at

Like (0)

Report

RE: Filtering Entity list with Related entity records in PowerApps Portals

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.
Abdul Wahab 12,085 Moderator on at

Like (0)

Report

RE: Filtering Entity list with Related entity records in PowerApps Portals

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