@WarrenBelz thanks for the tag, this was a tough one. Either that or I've got Sunday brain ...
@WJake
Try this on a button then use colIssuesCount as the Items of a gallery to see your count:
ClearCollect(
colMultiIssues,
yourListName.Issues
);
Clear(colIssues);
ForAll(
colMultiIssues,
Collect(
colIssues,
Filter(
Choices(yourListName.Issues),
Value in Issues.Value
).Value
)
);
ClearCollect(
colIssuesCount,
AddColumns(
Distinct(
colIssues,
Value
),
"Count",
CountRows(
Filter(
colIssues,
Value = Result
)
)
)
)
You can always move this code to the App OnStart or the OnVisible of a screen, the design choice is yours. I tried refactoring this code but couldn't reduce it down but you may be able to do that?
Let me know how you get on.
Note: depending on the size of your SP list you may also need to consider delegation eg I'm not sure if the first ClearCollect above will only look at the first 2000 records?
