Hi @rmzn,
I took your example here and created a sample application with the following:
Parent table - would map to your CPMProjAppStatus table
Child table - would map to your ProjProcessAppStatusAssignedUsers table
I then created a gallery that would display the distinct Parent records that match the email of the signed in user on the child records.
The following shows the Items code I used Distinct(Filter(Children,Email=User().Email),'Parent')
and then in the Gallery itself I referenced the Title and Subtitle from the Parent's record
ThisItem.Result.Name
ThisItem.Result.'Created On'
I tested with two of the same emails on a child record to verify it filtered to only one parent record and did not duplicate (this is why I needed the distinct). Show records in child table in screen shot to show you what I tested.
The data environment was the Dataverse so hopefully this is ok...
Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks much,
Drew
