News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps get last in date of ea...

Power Apps - Building Power Apps

Unanswered

get last in date of each distinct shop.

(0) Share

Report

Report

Posted on by LoopinG2023

59

Hey,

How can i retrieve in a collection, the last in date of each store.

DATAVERSE TABLE:

StoreName	Created On	Name	Store Number
Store1	01/02/2022	S_86	5658
Store1	04/02/2022	S_87	5655
Store2	02/01/2022	S_65	2523
Store2	03/10/2023	S_64	6565

So that in my collection i have the S_87 of store1 and S_64 of store2 only.

Thanks.

Categories:

General Questions

All responses Img

All responses (1)

Answers Img

Answers (0)

BCBuizer 22,027 Super User 2025 Season 1 on at

Like (0)

Report
Re: get last in date of each distinct shop.

Hi @LoopinG2023 ,

My fist try includes using GroupBy to get the unique values for StroreName and AddColumns to get the name value of the most recent item per StoreName:

ClearCollect( CollectionName, AddColumns( GroupBy( DATAVERSE TABLE, "StoreName", "ItemsByStoreName" ), "LastCreatedName", First( Sort( ItemsByStoreName, 'Created On', SortOrder.Descending ) ).Name ).LastCreated )