I may have gone about this wrong, but this is where I am at.
So we have two sets of engineers.
We can filter our list based on those engineers, and then we are also filtering that list with their current status.
We then SORT by their queue status.
So for example, if I pick Tech Talk, the code in on the filter button is this:
If(
l_TechTalk,
ClearCollect(
col_Engineers,
Filter(
col_Engineers,
EngineerQueueStatus.Value = "TechTalkLiveMeeting" || EngineerQueueStatus.Value = "TechTalkLiveSoon"
)
)
);
Another example, if we choose "in Office", this is the code to filter and sort those engineers
If(l_inoffice=true,
ClearCollect(
col_Engineers,SortByColumns(
AddColumns(
EngineersV2,"EngineerQueueStatus_value",EngineerQueueStatus.Value),
"EngineerQueueStatus_value",["Available","Out of Queue Soon","In Queue Soon","In Queue Later",
"Out of Queue","Assign No Cases","Assign No Crits","Assign Only Crits","TechTalkLiveMeeting","TechTalkLiveSoon"]
)
),
ClearCollect(col_Engineers,SortByColumns(EngineersV2,"Total_x0020_Assigned",SortOrder.Descending
)
)
);
At the end of the code block on Filter, we are setting row numbers
Clear(col_Display);
ForAll(col_Engineers,
Collect(col_Display,
Last(FirstN(AddColumns(col_Engineers,
"RowNumber",
CountRows(col_Display)+1
),
CountRows(col_Display)+1
)
)
)
);
On the gallery item, under FILL, we are setting the colors for the alternating row.
If(Mod(Value(ThisItem.RowNumber),2)=0,Color!WhiteSmoke,
If(Mod(Value(ThisItem.RowNumber),1)=0,Color!White))))
The problem I am having is keeping the alternate row colors AFTER I do an additional SORT
Here is an example of getting a specific set of engineers, who are all in office.
It sorts by queue status, and I have my alternating rows.
Now, lets say I take my current gallery items from the filter and I want to sort that by Accept Time:
You can see that my alternating row colors gets messed up.
So the previous owner built it so the variable col_display gets its row numbers in the filter button.
Now using Accept Time Sort, on select of that icon, I have the following code:
UpdateContext({acceptTimeSortDescending: !acceptTimeSortDescending});
UpdateContext({AcceptTimeVisible: !AcceptTimeVisible});
UpdateContext({EXOCountSortDescending: false});
UpdateContext({EXOCountVisible: false});
UpdateContext({CritCountSortDescending: false});
UpdateContext({CaseCountSortDescending: false});
UpdateContext({CaseCountVisible: false});
UpdateContext({CritCountVisible: false});
So when I hit the sort button for Accept time, it makes it true, hitting it again, false.
I set the other sorts to false as well.
Here is what I have my gallery items set to
//col_Display
If(acceptTimeSortDescending = true,
SortByColumns(col_Display,"Last_x0020_Assigned",SortOrder.Descending),
If(EXOCountSortDescending = true,
SortByColumns(col_Display,"EXOCaseCount",SortOrder.Descending),
If(CritCountSortDescending = true,
SortByColumns(col_Display,"Crits_x0020_Assigned",SortOrder.Descending),
If(CaseCountSortDescending = true,
SortByColumns(col_Display,"Total_x0020_Assigned",SortOrder.Descending),col_Display))))
When I hit sort i would like to keep the same format, alternating row colors.
But it seems since the gallery is already set with row numbers, when sorting, it messes up the alertanting rows.
Does anyone have any ideas on how to keep the alternating row colors?
