I am trying to create a table that shows the number of jobs and statuses of each job is assigned to each person and put it in a table.
My database name is 'CAS Requests' which is a SharePoint list.
My Columns I want to capture are:
"Assigned" people or group
"Status" Choices (New, Processing,Complete)
"Title" text (project name)
Refresh button
:The idea is to have a table that shows
Employee | New | Processing | Complete |
Bob | 10 | 5 | 6 |
Can anyone help
Anyone?
Thanks for the fast reply I had a go but I am getting an error.
I took a screenshot of the Canvas and the collection I am getting from the data.
Not sure where to go from here or what am I doing really...?
Hi,
Please use below code Onselect property of button.
ClearCollect(
colCASRequests,
'CAS Requests'
);
ClearCollect(
colGroupedCASRequests,
AddColumns(
GroupBy(
colCASRequests,
"Assigned",
"GroupData"
),
"NewCount",
CountIf(GroupData, Status = "New"),
"ProcessingCount",
CountIf(GroupData, Status = "Processing"),
"CompleteCount",
CountIf(GroupData, Status = "Complete")
)
);
hi @binkie ,
Add the following code to the OnSelect property of the Refresh button to create a collection that groups and counts the job statuses for each employee:
ClearCollect(
colCASRequests,
'CAS Requests'
);
ClearCollect(
colGroupedCASRequests,
AddColumns(
GroupBy(
colCASRequests,
"Assigned",
"GroupData"
),
"NewCount",
CountIf(GroupData, Status = "New"),
"ProcessingCount",
CountIf(GroupData, Status = "Processing"),
"CompleteCount",
CountIf(GroupData, Status = "Complete")
)
);
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
Super User 2025 Season 2
mmbr1606
275
Super User 2025 Season 2