Unanswered

I want to use LookUp to return the most recent record in a collection

(0) Share

Report

Posted on by CRam3b92

I am trying to use LookUp to return the most recent record in a collection. What I have just now is:

If(
 TimeValue(
 LookUp(colTimeEntryWeek, Date_ = datDateSTE.SelectedDate, Finish_Time)) > TimeValue(drpStartTimeSTE1.Selected.Value & ":" & drpStartTimeSTE2.Selected.Value), true)

This is a formula to show / hide a label to say If Date in collection matches date input in datDateSTE field then return the finish time. If the time input in Start time boxes is after this Finish time then make it visible. It works fine with only one record in the collection but the issue is when I have more than one record with that date it gets confused on the return value and doesn't base it on the most recent Finish time.

If you need any more info let me know. Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Rusk 1,369 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @CRam3b92

Assuming that "Finish_Time" is the column that has your date / time info, try this:

First(Sort(colTimeEntryWeek, Finish_Time, Descending))

Was this reply helpful? Yes No
CRam3b92 34 on at

Like (0)

Report
Copy link

Link copied!

@Rusk
Hi - thanks for your reply. Finish_Time is a separate time column in the collection.
I can see the idea behind doing this but just wondering the best place to put it? Should it be nested inside my original formula or on a separate control? I would have thought nested inside my original formula so the returned Finish_Time is the most recent record.

Was this reply helpful? Yes No
Rusk 1,369 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
I think to incorporate that in your current formula, you could use something like this:

If( TimeValue( First( SortByColumns( Filter(colTimeEntryWeek, Date_ = datDateSTE.SelectedDate), "Finish_Time", Descending ) ).Finish_Time ) > TimeValue(drpStartTimeSTE1.Selected.Value & ":" & drpStartTimeSTE2.Selected.Value), true )

Was this reply helpful? Yes No