Showing results for 
Search instead for 
Did you mean: 
Advocate I
Advocate I

Inconsistency when Filtering a View by Related Entity in Model-Driven App



I'm having some trouble with the way results are displayed on a view when filtering using a related entity on a model-driven app. 


I have two custom entities with a N:N relationship:



Program Event Session


I have created a view under the Case entity which filters according to various attributes on the Program Event Session entity. There are about 600 records returning which correspond to the number of Program Event Session records. The view only returns each Case record once and does not show each individual Program Event Session related to the Case (which it does when on the view editor). 


This is not a problem for me as I don't need to see all the individual Program Event Sessions. However, I want to be able to view how many Case records are returning and the view is only showing 4 or 5 Cases per page. When I change my personalisation settings to show more than 50 records per page, the number of Cases per page does increase but there is inconsistency on each page as to how many Case records are showing (47, 50, and 26 across 3 pages on one example). I'm not really sure why this would be - this isn't such a big problem but it does make the UX less than appealing.


So far my solution is to export to Excel and remove duplicates but wondering if there's a better way.


Hope this makes sense - happy to provide more information. Sorry if some of my terminology is not quite correct - I do not have a coding/IT background and may have misused terminology.


Thank you Power Apps Community 😀

Super User II
Super User II

@jlindstrom any ideas? 

Helpful resources

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users


We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (68,434)