Power Platform Community Forum Thread Details

I have a great script that gives me the last row created per user in a sharepoint list.

The list contains data from just one day.

Filter(
 Ungroup(
 AddColumns(
 GroupBy(
 Sort(
 Filter(
 AttendanceList,
 Office = Vestiging,
 StartsWith(
 userName,
 FilterTextBox.Text
 )
 ),
 userName,
 Ascending
 ),
 "userName",
 "Office"
 "GroupedColumn"
 ) As wStuff,
 "LastCreated",
 Max(
 wStuff.GroupedColumn,
 Created
 )
 ),
 "GroupedColumn"
 ),
 Created = LastCreated
, Check_x0020_in_x005c_out = Radio1.Selected.Value)

Now i want the same script working on a Sharepoint list with data from 3 months, for last created row per user per day per office.

But I cant figure out what "as wstuff" does.

Challenge:

I have a list that contains data from different users check in\out for 3 months. They get paid when working from home and get travel expenses when working at the office.

Because they can check in or out several times a day per office,
I want users to be able to check there last check in\out (Created) per day, per office.