Hello,
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:
Case
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 😀
