web

You’re offline. This is a read only version of the page.

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.

Like (0) Share

Report

Report

Posted on 8 Mar 2023 13:24:05 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,262 Super User 2025 Season 2 on 08 Mar 2023 at 15:05:14

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 )