ClearCollect(
GroupedCollection,
AddColumns(
GroupBy(
MyCollection, // your collection name.
Date,
Person,
GroupedRecords
),
RecordCount,
CountRows(GroupedRecords),
created,
Last(
SortByColumns(
GroupedRecords,
"created",
SortOrder.Ascending
)
).created
)
);
ClearCollect(
FinalCollection,
ForAll(
GroupedCollection,
If(
Mod(
RecordCount,
2
) = 1, // checking is odd count.
ThisRecord
)
)
);
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,532 Super User 2024 Season 2
Martin Dráb 228,501 Most Valuable Professional
nmaenpaa 101,148