Answered

Lookup last row

(0) Share

Report

Posted on by PPSA

238

I'm trying to work out something and need a lookup to give me the last entry rather than the first, is there a function for this ?

I need the label to output the highlighted 14.01 time.

LookUp(TimingsCarl,Gallery5.Selected.EstimateNo=Title&&!IsBlank(Pause),Pause)

Above is what I have currently.

Many thanks

2020-07-01 14_05_17-Steel - Tablet v2 - Saved (Unpublished) - Power Apps.png

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Try
Last (TimingsCarl).Unpause

Or
First(Sort(TimingsCarl, Descending)).Unpause
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Rahber 1,935 on at

Like
a
(0)

Report
Copy link

Link copied!

Try

Last(Filter(TimingsCarl,!IsBlank(Pause))).Pause
PPSA 238 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @eka24 , simple when you know how.
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@PPSA

Like this...

LookUp(Sort(TimingsCarl, ID, Descending),Gallery5.Selected.EstimateNo=Title&&!IsBlank(Pause),Pause)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."