PowerApp Dataverse GroupBy AddColumn and Filter Canvas Gallery
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.