PowerApp gallery with Groupby, filter, sortbycolumns and sum

[Syndicate_Admin]

I have table to track total tasks by staff.
I need a gallery to show past 7 days total tasks by Staff and Task type. the gallery need to order highest total task by person on top.

I used below however the filter is not working also unable to figure out how to sort by columns.
I used "AddColumns" because the "Person" column was not visible to Group.

GroupBy(Filter(AddColumns(
'Activities monitor',"StaffName",Person.DisplayName,"TotalTask",Sum(Total,0)), DateDiff('Date of Activity',Today(),Days)>=7), "StaffName","DATA")

[Anonymous]

Hi @Syndicate_Admin ,

You could directly create a Matrix visual to get such output:

Then apply [Date to Activity] field to slicer, select Relative Date type to remain last 7 days:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Syndicate_Admin]

@Syndicate_Admin 

I need this data in PowerApp, not in Power Bi

[lbendlin]

Yo may want to post in the PowerApps forums.