cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

LookUp last match, not first

Hey everyone,

 

Simple question here.

In the ITEM property of a Form I wrote:

 

LookUp(OPME_Table_2;Prontuario = DataCardValue55_2.Text)
 
This works fine (the form automatically filled in all the fields correctly), but there will be cases with more than one match for this formula, and I would like to fetch the LAST (most recent) one, not the first.
 
What would be the simplest way to change this formula?
 
Thanks,
 
Kris (The dumb one, not the real smart one I´ve seen answering questions around here).

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (6,922)