Share
Report
255I have a SharePoint list Incidents, with a lookup column Department which is from Departments SharePoint list. Departments list has also Supervisor column which is also a lookup column in Incidents list.
In PowerApps App I have grouped Incidents listing in Gallery by Department which works fine and I got a new variable "DepartmentGroupCol" which is derived from the Department title.
But when I want to add parallel columns to DepartmentGroupCol, for example DeptSupervisor, I won't get a proper variable/value for a certain DepartmentGroup.
I assume the problem is that DepartmentGroup is unambiguous since it's the main factor of grouping, but DeptSupervisor is not.
When making AddColumns for DeptSupervisor I think I should somehow choose "randomly" any Supervisor value since it's the same for all Incidents withing a DapertmentGroup?
All responses (
Answers (
