Announcements
I have data source connected to Ms Excel.
in the first column, there is a list of Trolley ID :["1","2","3","4","5"]
How to display the latest entry of each trolley ID in the gallery?
hi @jchandra
Last(col).Value will give you the last entry.
e.g.
consider the the variable x as a table
Set(x,["1","2","3","4","5"])
Last(x).Value will return 5
Regards,
R
for example I have this table where each row is entry input in powerapp.so I would like to display only the latest entry of each Trolley ID (highlighted in yellow) on the gallery.
Please help if have any idea, thank you..
Hi @jchandra ,
I have made a test for your reference.
1. Here is my excel table.
2. Add a Button Control and apply the following formula on its OnSelect property as:
ForAll(Distinct(datasource,'Trolley ID'),Collect(collectionname,First(Sort(Filter(datasource,Value('Trolley ID')=Value(Result)),'Last Checked Date',Descending))))
3. Select the Gallery Control and set its items property to collectionname.
Best Regards,Charlie Choi
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 610
Haque 317
WarrenBelz 315 Most Valuable Professional
