PowerApp Dataverse GroupBy AddColumn and Filter Canvas Gallery

[todaytoo]

I am trying to create a gallery shows the unique week end date filtered by the resource manager. I have created a gallery and have set the items property to the below two queries, but I am stuck at this point.

The CAPACITY DETAIL TRACKER table is made up of 3 lookup columns. Each column has a relationship setup within dataverse using the below columns.

 

When I try to GroupBy with AddColumn and then Filter I get the below error message:

“The requested operation is invalid. Server Response CAPACITY DETAIL TRACKERS failed: entityRelationshipRole for given navigation property not found”

 

Alternatively, When I try GroupBy with Filter and then AddColumn, I do not get any errors however when I add a label in the gallery no values appear for either ThisItem._week nor ThisItem.group_week.’column name’.

If I remove the filter from the second option (GroupBy/Filter/AddColumn) it does populate a list of dates, but not the filtered dates I needed.