Filtering Sorting and Selecting Last (Latest) item in a collection and using the value in a text label

(0) Share

Report

Posted on by ShaneITAutomate

301

Hi,

I have an app that needs to display in a text label the last item from a collection so i can then reuse that item to show what the next item should be for e.g.

My data is like this

Created	BoxID	Some Other Column
1/1/2000	Bx00001	zzz
1/1/2001	Bx00002	233
1/1/2002	Bx00003	42343

I cannot figure out how to sort the collection by the created date and display the text value in a label, do i need to put it in a gallery or a datatable first?

I dont right? i can just ClearCollect and Sort and filter and Lookup? if someone could help that would be great.

For example i want the item Bx00003 in a text label.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

WarrenBelz 153,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @ShaneITAutomate ,

This should work

First( Sort( YourListName, Created, Descending ) ).BoxID

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
ShaneITAutomate 301 on at

Like (0)

Report
Copy link

Link copied!

Cheers Warren, you always are a great help. Could i do something like below?

ClearCollect(Collection1, datasource),
Collect(Collection2),
First(
Sort(Collection1,Created,Descending)
).BoxID

(Sorry about the formating the code clearly aint right)

Currently im using the Onstart Function and Clearcollecting and then below that im sorting. It feels wrong for some reason however it works.

Was this reply helpful? Yes No
WarrenBelz 153,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @ShaneITAutomate ,

The second item is not a collection - it is a single value - you could make a Variable with it

ClearCollect( Collection1, datasource ); Set( gblBoxID, First( Sort( Collection1, Created, Descending ) ) ).BoxID

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No